DEFRECORD KDB_INFO_HAND
KDB open table summary information (type 7 superset)| FLD name | Pack format | Purpose |
|---|---|---|
| INFO_HAND_Telltale$ | CHAR(1) | 'K' for native KDB database table |
| INFO_HAND_Version$ | CHAR(1) | Version number (ASCII '7') |
| INFO_HAND_MinorVersion$ | CHAR(1) | Minor version number |
| INFO_HAND_PageSize | UINT(1) | Page size in Kb |
| INFO_HAND_RowLen | UINT(2) | Row length in Kb |
| INFO_HAND_IdxCount | UINT(1) | Number of indices |
| INFO_HAND_WsCount | UINT(1) | Number of word search indices |
| INFO_HAND_Connection | UINT(1) | Connection handle number |
| INFO_HAND_Serial | UINT(4) | Serial number |
| INFO_HAND_SerialOffset | UINT(2) | Serial number offset |
| INFO_HAND_ExclLockedBY | UINT(2) | Partition number of exclusive owner (in binary) |
| INFO_HAND_MajorError | UINT(1) | Last major error number |
| INFO_HAND_MinorError | UINT(1) | Last minor error number |
| INFO_HAND_SysError | UINT(1) | Last operating system errno value |
| INFO_HAND_HandleStatus | UINT(1) | Handle status |
| INFO_HAND_RowCount | UINT(4) | Count of rows in table |
| INFO_HAND_OpenMode$ | CHAR(1) | Mode the table was opened with, eg 'R'ead or 'W'rite |
| INFO_HAND_PageCount | UINT(4) | Number of pages in use |
| INFO_HAND_PageTotal | UINT(4) | Number of pages in table |
| INFO_HAND_StampFlags | UINT(4) | Date, user and timestamp flags |
| INFO_HAND_DateOffset | UINT(2) | Offset to auto-datestamp |
| INFO_HAND_UserOffset | UINT(2) | Offset to auto-userstamp |
| INFO_HAND_UserLen | UINT(1) | Length of auto-userstamp |
| INFO_HAND_ExcludeColumnOffset | UINT(2) | Offset to exclude column |
| INFO_HAND_FileName$ | CHAR(128) | KISAM filename |
| INFO_HAND_TableName$ | CHAR(128) | Table name |
| INFO_HAND_iprefix$ | CHAR(20) | IPREFIX from CREATE TABLE statement for KI_FLD |
| INFO_HAND_TimeOffset | UINT(2) | Offset to auto-timestamp |
| INFO_HAND_LockCount | UINT(4) | Number of locks on table (KDB only) |
| INFO_HAND_CacheFileId | UINT(4) | Cache file version number |
| INFO_HAND_bModified | UINT(1) | Table was modified since open |
| INFO_HAND_Status | UINT(4) | Handle status in full |
| INFO_HAND_Revoke | UINT(2) | REVOKE bitmap |
| INFO_HAND_RefCount | UINT(1) | Reference count on cached handle |
| INFO_HAND_bInLogging | UINT(1) | Table is part of a LOGGING pair |
| INFO_HAND_CursorCount | UINT(2) | Number of DB cursors in use |
| INFO_HAND_ConnectionMagic | Connection handle magic number | |
| INFO_HAND_TableSpace$ | CHAR(128) | Table space |
| INFO_HAND_bHasPartitions | UINT(1) | Table is a master table with partitions |
| INFO_HAND_bIsPartition | UINT(1) | Table is a partition in a master table |
| INFO_HAND_SqlState$ | CHAR(5) | Last database error code, SQLSTATE or ORA error code |
| INFO_HAND_LoggingTableName$ | CHAR(128) | Logging Table name |
| INFO_HAND_CompressionState | UINT(1) | |
| INFO_HAND_bOraRowDependencies | UINT(1) | This table was created with ROWDEPENDENCIES set |
| INFO_HAND_bCached | UINT(1) | Using cache table |
| INFO_HAND_CacheMajorError | UINT(1) | Major error number if failed to use cache table |
| INFO_HAND_CacheMinorError | UINT(1) | Minor error number if failed to use cache table |
| INFO_HAND_bUseKRCN | UINT(1) | Table always uses K$RCN, even if ROWDEPENDENCIES is set |