SYSTIMESENSITIVE bind option

The SYSTIMESENSITIVE option specifies whether references to system-period temporal tables in both static and dynamic SQL statements are affected by the value of the CURRENT TEMPORAL SYSTEM_TIME special register.

Command option	Option values	Used with
SYSTIMESENSITIVE	(YES) (NO)	BIND PACKAGE BIND SERVICE REBIND PACKAGE ¹ REBIND TRIGGER PACKAGE

Note:

The SYSTIMESENSITIVE bind option is not valid for REBIND of packages for complied SQL functions, native SQL procedures, or advanced triggers.

Option descriptions for SYSTIMESENSITIVE

SYSTIMESENSITIVE(YES): References to system-period temporal tables are affected by the value of the CURRENT TEMPORAL SYSTEM_TIME special register.
SYSTIMESENSITIVE(NO): References to system-period temporal tables are not affected by the value of the CURRENT TEMPORAL SYSTEM_TIME special register.

Interactions with the PLANMGMT option: If you plan to change this option and the PLANMGMT option in a REBIND command, see PLANMGMT bind option for the implications.

Default values for SYSTIMESENSITIVE

Process	Default value
BIND SERVICE	YES
BIND PLAN	N/A
BIND PACKAGE	YES
REBIND PLAN	N/A
REBIND PACKAGE	Existing value
REBIND TRIGGER PACKAGE	Existing value