KI_SET_TIMESTAMP
Argument | Enumeration | Purpose |
---|---|---|
handle | Handle | |
mode$ | "S"et or "U"nset timestamping | |
status | KDB_ERROR_ENUM | Return status |
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.