A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iiproc_rescols Catalog
 
Share this page                  
iiproc_rescols Catalog
The iiproc_rescols catalog is a standard interface catalog with information about the parameters and result columns of an Ingres database procedure. It has one row for each parameter, the same as the rows of iiproc_params. It also contains one row for each result column of a row producing procedure.
Column Name
Data Type
Description
procedure_name
char(256)
The name of the procedure
procedure_owner
char(32)
The owner of the procedure
rescol_name
char(256)
The name of the parameter/result column
rescol_sequence
integer
Ordinal position of parameter or result column in procedure declaration
rescol_datatype
char(32)
Datatype of parameter/result column
rescol_datatype_code
smallint
Numeric representation of datatype
rescol_length
integer
Length of parameter/result column
rescol_scale
integer
The second number in a two-part user length specification; for type name (len1, len2) it is len2
rescol_nulls
char(1)
Y indicates this parameter is null
rescol_param
char(1)
Y indicates this is a parameter
N indicates this is a result column
rescol_defaults
char(1)
Y indicates this parameter has a default value
rescol_default_val
varchar(1501)
Default value used if default parameter provided