DB2 Version 10.1 for Linux, UNIX, and Windows

SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY procedure - disable recording of temporal history

The SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY procedure sets the internal option to disable recording of temporal history for a system-period temporal table and allows values to be specified for the special temporal columns.

Authorization

One of the following authorizations is required:

EXECUTE privilege on the routine

SECADM authority is required to grant EXECUTE privilege on the SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY procedure. EXECUTE privilege WITH GRANT OPTION cannot be granted for this routine (SQLSTATE 42501).

Default PUBLIC privilege

None

Syntax


>>-SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY--(--)--------------><

The schema is SYSPROC.

Usage notes

Disabling the recording of temporal history for a system-period temporal table with the SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY procedure lasts for the duration of the current session.

Example

Set the internal option to disable recording of temporal history for a system-period temporal table and allow values to be specified for the special temporal columns.

call SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY()