KDB KI_INFO options constants

>Database Constants

KI_INFO constants

These are enumerated constants used with the KI_INFO KDB database routines to determine how the information should be gathered especially on SQL databases where row counting is expensive. There are two types of option, an enumeration of the row counting modes and an independent serial number attribute which can be added.

DEF ENUM enumeration name KDB_INFO_OPTS_ENUM

Enumeration Value	Value	Description
_KDB_INFO_DEFAULT	0x00	Get exact row count and serial for KDB but return zero for SQL databases
_KDB_INFO_ROW_COUNT	0x01	Get exact row count
_KDB_INFO_NO_ROW_COUNT	0x02	Never get row count, always return zero
_KDB_INFO_TEST_FOR_ROWS	0x03	Return zero if empty table or one if at least one row available
_KDB_INFO_APPROX_ROWS	0x04	Get approximate row count
_KDB_INFO_SERIAL	0x08	Get exact serial number
_KDB_INFO_BLOCKS	0x10	Get approximate free and used block counts
_KDB_INFO_NAME_ONLY	0x20	Get name, mode, connection only.
_KDB_INFO_COMPRESSION_STATE	0x40	Get compression state

Back to the list of Enumerations and Constants