PROCEDURECOLUMNS System Table Description

Description

Maintains, for each SQL or Java Stored Procedure defined, a list of input and/or output parameters.

Fields

Field Type Description
SCHEMA string The schema in which the procedure was created.
PROCEDURENAME string The name of the procedure.
NAME string The name of the parameter.
TYPE integer Indicates the type of the parameter: 1 for an IN parameter, 2 for an INOUT, 4 for an OUT parameter
DATATYPE integer The integer for the type as represented by the ID column in DATATYPES. (See DATATYPES System Table Description.)
DATATYPENAME string The type as represented by the NAME column in DATATYPES. (See DATATYPES System Table Description.)
PRECISION integer The precision specified for a fixed precision numeric, CHAR or BINARY type; the max precision possible for other numeric types
LENGTH integer Length associated with the data type - this is the precision assigned to a CHAR or BINARY type or the size in bytes of the type
SCALE integer The scale specified for a fixed precision numeric type
OCTET_LENGTH integer The size in bytes of the parameter
ORDINAL integer The placement of this parameter in the procedure call

Indexes

None