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

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

Start of change 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. End of change

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