ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-123
SQLPrimaryKeys
SQLPrimaryKeys
SQLPrimaryKeys is a procedure that lists keys for base tables. It does not report keys
for views. ODBC does not require views to have independent indexes.
SQLPrimaryKeys is a view on ZNOBJ, KEYS, COLUMNS, and INDEXES. A view
specific to the NonStop ODBC Server is not provided for this result set.
Input parameters for SQLPrimaryKeys are:
•
TABLE_QUALIFIER
•
TABLE_OWNER
•
TABLE_NAME
SQLProcedureColumns
SQLProcedureColumns is a procedure that lists columns defined for a stored
procedure. The columns can be input or output types. The values are determined at
the time the procedure is added through NOSUTIL.
SQLProcedureColumns is a join over the mapping tables, ZNUPCOL and ZNUDT. The
values for the result set are determined at the time NOSUTIL adds the procedure to
the system.
Input parameters for SQLProcedureColumns are:
•
PROCEDURE_QUALIFIER
•
PROCEDURE_OWNER
•
PROCEDURE_NAME
•
COLUMN_NAME
If you omit COLUMN_NAME, SQLProcedureColumns lists all columns for the specified
procedure.
Table 7-6. Result Set for the SQLPrimaryKeys Procedure
Result Column Data Type Description
TABLE_QUALIFIER VARCHAR (60) Assigned null.
TABLE_OWNER VARCHAR (60) The table owner.
TABLE_NAME VARCHAR (60) The name of the table.
COLUMN_NAME CHAR (30) The name of the column.
KEY_SEQ INT (2) The sequence number of the column in
column (key sequence number + 1).