PROCEDURECOLUMNS System Table 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