Reference Manual

Back Next

DTLDESCRIBE PROCEDURES Returned Information

The following table describes the columns:

Column Name	Description
PROCEDURE_CAT	Procedure Catalog, null if not present; VARCHAR.
PROCEDURE_SCHEM	Procedure Schema, null if not present; VARCHAR.
PROCEDURE_NAME	Procedure Name, not null; VARCHAR.
NUM_INPUT_PARAMS	Number of input parameters, not null (N/A for SQL Server); INTEGER.
NUM_OUTPUT_PARAMS	Number of output parameters, not null (N/A for SQL Server); INTEGER.
NUM_RESULT_SETS	Number of result sets, not null (N/A for SQL Server); INTEGER.
REMARKS	Comments; VARCHAR.
PROCEDURE_TYPE	Procedure type.