ODBC Server Reference Manual

Managing Customized Catalogs

HP NonStop ODBC Server Reference Manual—429151-002

7-122

SQLColumns

SQLColumns is a procedure that returns a list of user-requested column names and

column information from user-requested tables. The view ZVUOCOL provides support

for SQLColumns. ZVUOCOL is a view over COLUMNS, ZNUOBJ, and ZNUDT.

Input parameters for SQLColumns are:

•

TABLE_QUALIFIER

•

TABLE_OWNER

•

TABLE_NAME

•

COLUMN_NAME

Table 7-5. Result Set for the SQLColumns Procedure

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.

COLUMN_NAME VARCHAR (30) The name of the column, converted from

CHAR (30).

DATA_TYPE INT (2) The type of data (described in

TYPE_NAME).

TYPE_NAME VARCHAR (60) The corresponding name for the data type

value in DATA_TYPE.

PRECISION INTEGER The precision of the requested column.

LENGTH INTEGER The length of the requested column.

SCALE INT (2) The scale of the requested column.

RADIX INT (2) The radix of the column data:

NULLABLE INT (2) Indicates whether the requested column

allows null values:

0 SQL_NO__NULLS

1 SQL_NULLABLE

REMARKS VARCHAR (254) Assigned "" (blank).