procedure_name

char(256)

Name of database procedure

procedure_owner

char(32)

Owner of database procedure

param_name

char(256)

Name of parameter

param_sequence

smallint

Which argument this parameter corresponds to (1 = first)

param_datatype

char(32)

Data type of parameter

param_datatype_code

smallint

Numeric representation of datatype.
See column_ing_datatype in iicolumns for these values.

param_length

integer

The column length
Displays the precision for decimal data type, zero for money and date

param_scale

integer

Displays the scale for decimal data type, zero for all other data types

param_nulls

char(1)

Y if this parameter is NULLable

param_defaults

char(1)

Y if this parameter has a default value

param_default_val

varchar(1501)

Default value used if default parameter provided

param_input

char(1)

Y if the corresponding procedure parameter is declared as IN in the database procedure definition

param_output

char(1)

Y if the corresponding procedure parameter is declared as OUT

param_inout

char(1)

Y if the corresponding procedure parameter is declared as INOUT