.-SQL-. .-LOCAL--. >>-GET--+-----+--DESCRIPTOR--+--------+--SQL-descriptor-name----> '-GLOBAL-' .-,---------------. V | >--+---get-header-info-+----------------------------+---------->< | .-,-------------. | | V | | '-VALUE--+-integer----------+----get-item-info-+-' '-integer-variable-'
get-header-info: |--variable-1-- = --+-COUNT-----------------+-------------------| +-DYNAMIC_FUNCTION------+ +-DYNAMIC_FUNCTION_CODE-+ +-KEY_TYPE--------------+ '-DB2_MAX_ITEMS---------' get-item-info: |--variable-2-- = --+-DATA-----------------------+--------------| +-DATETIME_INTERVAL_CODE-----+ +-DB2_BASE_CATALOG_NAME------+ +-DB2_BASE_COLUMN_NAME-------+ +-DB2_BASE_SCHEMA_NAME-------+ +-DB2_BASE_TABLE_NAME--------+ +-DB2_CCSID------------------+ +-DB2_COLUMN_CATALOG_NAME----+ +-DB2_COLUMN_GENERATED-------+ +-DB2_COLUMN_GENERATION_TYPE-+ +-DB2_COLUMN_NAME------------+ +-DB2_COLUMN_SCHEMA_NAME-----+ +-DB2_COLUMN_TABLE_NAME------+ +-DB2_COLUMN_UPDATABILITY----+ +-DB2_CORRELATION_NAME-------+ +-DB2_LABEL------------------+ +-DB2_PARAMETER_NAME---------+ +-DB2_SYSTEM_COLUMN_NAME-----+ +-INDICATOR------------------+ +-KEY_MEMBER-----------------+ +-LENGTH---------------------+ +-LEVEL----------------------+ +-NAME-----------------------+ +-NULLABLE-------------------+ +-OCTET_LENGTH---------------+ +-PARAMETER_MODE-------------+ +-PARAMETER_ORDINAL_POSITION-+ +-PARAMETER_SPECIFIC_CATALOG-+ +-PARAMETER_SPECIFIC_NAME----+ +-PARAMETER_SPECIFIC_SCHEMA--+ +-PRECISION------------------+ +-RETURNED_LENGTH------------+ +-RETURNED_OCTET_LENGTH------+ +-SCALE----------------------+ +-TYPE-----------------------+ +-UNNAMED--------------------+ +-USER_DEFINED_TYPE_CATALOG--+ +-USER_DEFINED_TYPE_CODE-----+ +-USER_DEFINED_TYPE_NAME-----+ '-USER_DEFINED_TYPE_SCHEMA---'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.