KI_TABLES

Create a pseudo table of tables in a database

Synopsis:
CALL KI_TABLES handle TO status
status = 'ki_tables( handle )
ArgumentEnumerationPurpose
handleHandle
statusKDB_ERROR_ENUMReturn status
>KI_TABLES

KI_TABLES

This function generates a result set containing information about all the tables available in the database to which the handle is connected.

The handle must have been allocated with a KI_ALLOC_HANDLE and it can be used in subsequent KI_FETCH calls to get the information. The row buffer passed for the fetch operation should be an instance of the _KDB_CATALOG record.

History
Introduced in KCML 5.02
See Also:
KI_BIND_COL, KI_BIND_PARAM, KI_BOUND_COL, KI_BOUND_PARAM, KI_COLUMNS, KI_DATABASES, KI_DEFAULT_ROW, KI_DESCRIBE_COL, KI_ERROR, KI_ERROR_TEXT, KI_EXECUTE, KI_FETCH, KI_GET_COL_LIST, KI_GET_ERROR_TEXT, KI_PARTITIONS, KI_PREFETCH_ROWS, KI_PREPARE, KI_SESSIONS, KI_SET_COL_LIST, KI_SQL, KI_SQL_XML, KI_TABLESPACES
KCML database status codes