KI_CLOSE_TABLE

Close all the zero ref count pooled handles for a table

Synopsis:
CALL KI_CLOSE_TABLE connection, [table$], [bClose] TO [status], [handle]
handle = 'ki_close_table( connection, [table$], [bClose] )
ArgumentEnumerationPurpose
connectionCurrent database connection
table$Table name
bCloseTRUE for force close even if non-zero ref count
statusKDB_ERROR_ENUMReturn status
handleFirst non-zero ref count handle remaining
>KI_CLOSE_TABLE

KI_CLOSE_TABLE

This function closes all the zero reference count handles cached for a given table. If any handles remain because their count was non-zero then one of the handle numbers is returned in the optional last argument.

If the tablename is omitted or is the empty string then all the zero reference count pooled handles on all tables for that connection are closed.

If the bClose argument is TRUE the all the handles will be closed irrespective of their reference count.

History
Introduced in KCML 6.60
See Also:
KI_ADD_TRACKED_LOCK, KI_ALLOC_HANDLE, KI_CLEAR, KI_CLEAR_HANDLES, KI_CLOSE, KI_DB_NAME, KI_DROP_TABLE, KI_DROP_TRACKED_LOCK, KI_EXTEND, KI_FREE_HANDLE, KI_GET_HANDLE, KI_GET_SERIAL, KI_GET_TRACKED_LOCKS, KI_HANDLE_GET_ATTR, KI_HANDLE_GET_ATTR_STR, KI_HANDLE_SET_ATTR, KI_HANDLE_SET_ATTR_POOL, KI_HANDLE_SET_ATTR_STR, 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_TIMESTAMP, KI_SET_USERSTAMP, KI_UNLOCK_FILE, KI_VERIFY
KCML database status codes