KI_PARTITIONS

Create a pseudo table of partitions for a given base table

Synopsis:
CALL KI_PARTITIONS handle, table$ TO status
status = 'ki_partitions( handle, table$ )
ArgumentEnumerationPurpose
handleHandle
table$Base table name
statusKDB_ERROR_ENUMReturn status
>KI_PARTITIONS

KI_PARTITIONS

This function generates a result set containing the names of all the partitions in the given table.

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. Only the table name and tablespace name columns will be updated and all other columns will be space filled.

History
Introduced in KCML 6.60
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_PREFETCH_ROWS, KI_PREPARE, KI_SESSIONS, KI_SET_COL_LIST, KI_SQL, KI_SQL_XML, KI_TABLES, KI_TABLESPACES
KCML database status codes