ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-125
SQLSpecialColumns
SQLSpecialColumns
SQLSpecialColumns is a procedure that lists the columns of a table that uniquely
identify a row in a table.
Input parameters for SQLSpecialColumns are:
•
COLTYPE, which must be:
°
SQL_BEST_ROWID, a define value set to 1
•
TABLE_QUALIFIER
•
TABLE_OWNER
•
TABLE_NAME
•
SCOPE, which must be:
°
SQL_SCOPE_TRANSACTION, a define value set to 1
•
NULLABLE, which must be:
°
SQL_NO_NULLS, a define value set to 0
Table 7-8. Result Set for the SQLProcedures Procedure
Result Column Data Type Description
PROCEDURE_QUALIFIER VARCHAR (60) Assigned null.
PROCEDURE_OWNER VARCHAR (60) The owner of the procedure.
PROCEDURE_NAME VARCHAR (60) The name of the procedure.
NUM_INPUT_PARAMS INT (2) The number of input parameters
defined for the procedure.
NUM_OUTPUT_PARAMS INT (2) The number of output parameters
defined for the procedure.
NUM_RESULT_SETS INT (2) The number of result sets defined for
the procedure.
REMARKS VARCHAR (254) Assigned "" (blank).
Table 7-9. Result Set for the SQLSpecialColumns Procedure (page 1 of 2)
Result Column Data Type Description
SCOPE INT (2) The duration of the result set. Assigned 2, indicating
the result set is good for the duration of the session.
COLNAME CHAR (30) The name of the column.
DATATYPE INT (2) The mode-dependent code for data type.
TYPENAME CHAR (30) A character-string value associated with the value for
DATATYPE.