BUSTIMESENSITIVE bind option

The BUSTIMESENSITIVE option determines whether references to application-period temporal tables in both static and dynamic SQL statements are affected by the value of the CURRENT TEMPORAL BUSINESS_TIME special register.

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

Note:

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

Option descriptions for BUSTIMESENSITIVE

( YES ): References to application-period temporal tables are affected by the value of the CURRENT TEMPORAL BUSINESS_TIME special register.
( NO ): References to application-period temporal tables are not affected by the value of the CURRENT TEMPORAL BUSINESS_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 BUSTIMESENSITIVE

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