KI_FETCH

Fetch the next row in a result set

Synopsis:
CALL KI_FETCH handle, SYM(rowbuf$) TO status
status = 'ki_fetch( handle, SYM(rowbuf$) )
ArgumentEnumerationPurpose
handleHandle
SYM(rowbuf$)Symbol of a buffer large enough to result
statusKDB_ERROR_ENUMReturn status
>KI_FETCH

KI_FETCH

This function returns the next row from a result set established on the handle by KI_EXECUTE, KI_DATABASES, KI_TABLESPACES, KI_TABLES, KI_PARTITIONS, KI_COLUMNS or KI_SESSIONS. The data is put into the buffer whose SYM() is passed in sym. This buffer must be large enough.

Note: A KI_PREPARE/KI_EXECUTE/KI_FETCH block MUST be followed by a KI_CLOSE before the handle can be re-used to parse another SQL statement or open a table.

History
Introduced in KCML 5.00
See Also:
KI_BIND_COL, KI_BIND_PARAM, KI_BOUND_COL, KI_BOUND_PARAM, KI_BUILD, KI_COLUMNS, KI_DATABASES, KI_DEFAULT_ROW, KI_DELETE, KI_DELETE_ROWS, KI_DELETE_WHERE, KI_DESCRIBE_COL, KI_END, KI_ERROR, KI_ERROR_TEXT, KI_EXECUTE, KI_GET_COL_LIST, KI_GET_ERROR_TEXT, KI_LOCK_OWNER, KI_MOVE_ROWS, KI_PARTITIONS, KI_PREFETCH_ROWS, KI_PREPARE, KI_READ, KI_READ_ARRAY, KI_READ_HOLD, KI_READ_HOLD_NEXT, KI_READ_HOLD_PTR, KI_READ_NEXT, KI_READ_PTR, KI_READ_RANDOM, KI_READ_RAW, KI_REWRITE, KI_SESSIONS, KI_SET_COL_LIST, KI_SET_ROWS, KI_SQL, KI_SQL_XML, KI_START, KI_START_BEG, KI_START_BETWEEN, KI_START_FIRST, KI_START_ON, KI_START_ROW, KI_START_ROW_BETWEEN, KI_TABLES, KI_TABLESPACES, KI_UNLOCK, KI_WRITE, KI_WRITE_PTR, KI_WRITE_RAW
KCML database status codes