ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-124
SQLProcedures
Description
SQLProcedures
SQLProcedures is a procedure that lists the procedures that are defined for a user-
requested database. The values for the result set are determined at the time the
procedure is added to the catalog for execution access through NOSUTIL.
Input parameters for SQLProcedures are:
•
PROCEDURE_QUALIFIER
•
PROCEDURE_OWNER
•
PROCEDURE_NAME
Table 7-7. Result Set for the SQLProcedureColumns 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.
COLUMN_NAME VARCHAR (60) The name of the column or parameter.
COLUMN_TYPE INT (2) A column type indicator:
1 SQL_PARAM_INPUT
2 SQL_PARAM_INPUT_OUTPUT
DATA_TYPE INT (2) The encoded value indicating the data
type of the parameter.
TYPE_NAME VARCHAR (60) The string identifier value indicating the
data type of the parameter.
PRECISION INT (2) The logical precision of the requested
column. The default is 1.
LENGTH INT (2) The logical length of the requested
column. The default is 1.
SCALE INT (2) The logical scale of the requested
column. The default is 10.
RADIX INT (2) The logical radix of the column data.
The default is 10.
NULLABLE INT (2) Indicates whether the procedure
column allows null values:
0 SQL_NO__NULLS
1 SQL_NULLABLE
The default is 1.
REMARKS VARCHAR (254) Assigned null.