KI_TABLESPACES

Create a pseudo table of tablespaces in a database

Synopsis:
CALL KI_TABLESPACES handle TO status
status = 'ki_tablespaces( handle )
ArgumentEnumerationPurpose
handleHandle
statusKDB_ERROR_ENUMReturn status
>KI_TABLESPACES

KI_TABLESPACES

This function generates a result set containing information about all the tablespaces 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. If the buffer passed to KI_FETCH is not big enough to hold the tablespace name, the name will be truncated and the final 3 characters filled with .'s to indicate that truncation has occurred.

History
Introduced in KCML 6.00
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_TABLES
KCML database status codes