ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-126
SQLStatistics
SQLStatistics
SQLStatistics is a procedure that lists index information for base tables.
Input parameters for SQLStatistics are:
•
TABLE_QUALIFIER
•
TABLE_OWNER
•
TABLE_NAME
•
UNIQUE, which is one of the following:
°
SQL_INDEX_UNIQUE, a define value set to 0
°
SQL_INDEX_ALL, a define value set to 1
PRECISION INT (4) The number of digits or bits of precision for numeric
data types.
LENGTH INT (4) The number of bytes for nonnumeric data types.
SCALE INT (2) The scale of numeric data types.
Table 7-10. Result Set for SQLProcedureColumns Procedure (page 1 of 2)
Result Column Data Type Description
TABLE_QUALIFIER VARCHAR (60) Assigned null.
TABLE_OWNER VARCHAR (60) The owner of the table.
TABLE_NAME VARCHAR (60) The name of the table.
NON_UNIQUE INT (2) Indicates whether the index allows duplicate
values:
1 INDEXES.UNIQUEVALUE = “N”
0 INDEXES.UNIQUEVALUE = “Y”
INDEX_QUALIFIER VARCHAR (60) Assigned null.
INDEX_NAME VARCHAR (60) The name of the index.
TYPE INT (2) The subject of the statistics. If the value for
INDEX_NAME is NULL, statistics are about
the primary key on the indicated table. If it is
not NULL, statistics are about other indexes.
SEQ_IN_INDEX INT (2) Index column sequence number.
COLUMN_NAME VARCHAR (60) The COLUMN IDENTIFIER.
Table 7-9. Result Set for the SQLSpecialColumns Procedure (page 2 of 2)
Result Column Data Type Description