1
Download Informix CLI Programmer`s Manual, Version 2.5
Transcript
SQLPrimaryKeys The lengths of VARCHAR columns shown in the table are maximums; the actual lengths depend on the data source. To determine the actual lengths of the TABLE_QUALIFIER, TABLE_OWNER, TABLE_NAME, and COLUMN_NAME columns, call SQLGetInfo with the SQL_MAX_QUALIFIER_NAME_LEN, SQL_MAX_OWNER_NAME_LEN, SQL_MAX_TABLE_NAME_LEN, and SQL_MAX_COLUMN_NAME_LEN options. Column Name Data Type Comments TABLE_QUALIFIER VARCHAR(128) Primary-key table-qualifier identifier; NULL if not applicable to the data source. TABLE_OWNER VARCHAR(128) Primary-key table-owner identifier; NULL if not applicable to the data source. TABLE_NAME VARCHAR(128) not NULL Primary-key table identifier. COLUMN_NAME VARCHAR(128) Primary-key column identifier. not NULL KEY_SEQ SMALLINT not NULL Column sequence number in key (starting with 1). PK_NAME VARCHAR(128) Primary-key identifier. NULL if not applicable to the data source. Related Functions For information about See Assigning storage for a column in a result set SQLBindCol Canceling statement processing SQLCancel Fetching a block of data or scrolling through a result set SQLExtendedFetch 13-254 Fetching a row of data SQLFetch Returning table statistics and indexes SQLStatistics INFORMIX-CLI Programmer’s Manual
