Specifies whether or not changes to data in system-period temporal tables made by static or dynamic SQL statements make changes to the corresponding history table.
Restriction: TEMPORAL-HISTORY is supported by DB2 LUW version 10.5 or later.
Syntax:
TEMPORAL-HISTORY={YES | NO}
Parameters:
- YES
- A change to data in a system-period temporal table triggers a change to the corresponding history table. This is equivalent to the IBM PRECOMPILE WITH TEMPORAL HISTORY option.
- NO
- A change to data in a system-period temporal table does not trigger a change to the corresponding history table. This is equivalent to the IBM PRECOMPILE WITHOUT TEMPORAL HISTORY option.
Note: Your DBA can provide values to override the ROW-BEGIN, ROW-END, and TRANSACTION-START-ID columns even when they are defined as GENERATED ALWAYS.
Properties:
| Default:
|
TEMPORAL-HISTORY=YES
|
Comments:
DBADM authority is required to use TEMPORAL-HISTORY. For more information, see the IBM DB2 documentation.
