KI_SET_DATESTAMP

Turn datestamping on/off

Synopsis:
CALL KI_SET_DATESTAMP handle, mode$ TO status
status = 'ki_set_datestamp( handle, mode$ )
ArgumentEnumerationPurpose
handleHandle
mode$"S"et or "U"nset datestamping
statusKDB_ERROR_ENUMReturn status
>KI_SET_DATESTAMP

KI_SET_DATESTAMP

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

CALL KI_SET_DATESTAMP handle, "S" TO status

turns datestamping on on the table currently open on handle. While,

CALL KI_SET_DATESTAMP handle, "U" TO status

turns datestamping off.

After datestamping has been turned on the column specified in the DATESTAMP table paramter to CREATE TABLE will be automatically filled with the current time and date (based on the number of seconds since 1970). Setting/unsetting datestamping on a table that already has it set/unset will have no effect and will not produce an error.

This function is only available for type 7 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_SERIAL, KI_SET_TIMESTAMP, KI_SET_USERSTAMP, KI_UNLOCK_FILE, KI_VERIFY
KCML database status codes