KI_SET_TIMESTAMP

Turn timestamping on/off

Synopsis:
CALL KI_SET_TIMESTAMP handle, mode$ TO status
status = 'ki_set_timestamp( handle, mode$ )
ArgumentEnumerationPurpose
handleHandle
mode$"S"et or "U"nset timestamping
statusKDB_ERROR_ENUMReturn status
>KI_SET_TIMESTAMP

KI_SET_TIMESTAMP

Allows timestamping to be toggled on or off. For example:

CALL KI_SET_TIMESTAMP handle, "S" TO status

turns timestamping on on the table currently open on handle. While

CALL KI_SET_TIMESTAMP handle, "U" TO satus

turns timestamping off.

After timestamping has been turned on the column specified in the TIMESTAMP table parameter to CREATE TABLE will be automatically filled with the current timestamp (based on the number of milliseconds since year 0000, ie one day before the first of January 0001). Setting/unsetting timestamping on a table that already has it set/unset will have no effect and will not produce an error.

Timestamping is on by default when a table is opened by KI_OPEN.

This function is only available for KDB7 and Oracle tables.

History
Introduced in KCML 6.00
See Also:
KI_CLOSE, KI_CLOSE_TABLE, KI_DB_NAME, KI_DROP_TABLE, KI_EXTEND, KI_GET_HANDLE, KI_GET_SERIAL, KI_INFO, KI_INITIALISE, KI_LOCK_ALL, KI_OPEN, KI_PREFETCH_ROWS, KI_REBUILD, KI_RESET_CACHEID, KI_SET_DATESTAMP, KI_SET_SERIAL, KI_SET_USERSTAMP, KI_UNLOCK_FILE, KI_VERIFY
KCML database status codes