| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| SCHEMA |
CHAR(8) NOT NULL |
Schema of the routine. |
G |
| OWNER |
CHAR(8) NOT NULL |
Owner of the routine. |
G |
| NAME |
CHAR(18) NOT NULL |
Name of the routine. |
G |
| SPECIFICNAME |
CHAR(18) NOT NULL |
Specific name of the routine. |
G |
| ROUTINETYPE |
CHAR(1) NOT NULL |
Type of routine:
F User-defined function or cast function
P Stored procedure |
G |
| CAST_FUNCTION |
CHAR(1) NOT NULL |
Whether the routine is a cast function:
N Not a cast function
Y A cast function
The only way to get a value of Y is if a user creates a distinct type when DB2
implicitly generates cast functions for the distinct type. |
G |
| PARMNAME |
CHAR(18) NOT NULL |
Name of the parameter. |
G |
| ROUTINEID |
INTEGER NOT NULL |
Internal identifier of the routine. |
S |
| ROWTYPE |
CHAR(1) NOT NULL |
Type of parameter:
P Input parameter.
O Output parameter; not applicable for functions
B Both an input and an output parameter; not applicable for functions
R Result before casting; not applicable for stored procedures
C Result after casting; not applicable for stored procedures
This column can have an additional value. If the routine is a user-defined function
that is sourced on a built-in function, an additional row is inserted into the catalog
table for each input parameter (ROWTYPE='P'). The additional row describes the
data type of the corresponding input parameter of the built-in function. When such
a row is added, the value of ROWTYPE is 'S'.
When PARAMETER CCSID is specified, the ROWTYPE is also 'S'. |
G |
| ORDINAL |
SMALLINT NOT NULL |
If ROWTYPE is B, O, P, or S, the ordinal number of the parameter within the routine
signature. If ROWTYPE is C or R, the value is 0. When ROWTYPE is S, because a
PARAMETER CCSID is specified, the ORDINAL value is 0. |
G |
| TYPESCHEMA |
CHAR(8) NOT NULL |
Schema of the data type of the parameter. |
G |
| TYPENAME |
CHAR(18) NOT NULL |
Name of the data type of the parameter. |
G |
| DATATYPEID |
INTEGER NOT NULL |
For a built-in data type, the internal ID of the built-in type. For a distinct type, the
internal ID of the distinct type. |
S |
| SOURCETYPEID |
INTEGER NOT NULL |
For a built-in data type, 0. For a distinct type, the internal ID of the built-in data
type upon which the distinct type is sourced. |
S |
| LOCATOR |
CHAR(1) NOT NULL |
Indicates whether a locator to a value, instead of the actual value, is to be passed
or returned when the routine is called:
N The actual value is to be passed.
Y A locator to a value is to be passed |
G |
| TABLE |
CHAR(1) NOT NULL |
The data type of a column for a table parameter:
N This is not a table parameter.
Y This is a table parameter. |
G |
| TABLE_COLNO |
SMALLINT NOT NULL |
For table parameters, the column number of the table. Otherwise, the value is 0. |
G |
| LENGTH |
INTEGER NOT NULL |
Length attribute of the parameter, or in the case of a decimal parameter, its
precision. |
G |
| SCALE |
SMALLINT NOT NULL |
Scale of the data type of the parameter. |
G |
| SUBTYPE |
CHAR(1) NOT NULL |
If the data type is a distinct type, the subtype of the distinct type, which is based on the subtype of its source type:
B The subtype is FOR BIT DATA.
S The subtype is FOR SBCS DATA.
M The subtype is FOR MIXED DATA.
blank The source type is not a character type. |
G |
| CCSID |
INTEGER NOT NULL |
CCSID of the data type for character, graphic, date, time, and timestamp data
types. When ROWTYPE is S and ORDINAL is 0, the CCSID column is the CCSID for
all string parameters. |
G |
| CAST_FUNCTION_I |
INTEGER NOT NULL |
Internal function ID of the function used to cast the argument, if this function is
sourced on another function, or result. Otherwise, the value is 0. Not applicable for
stored procedures. |
S |
| ENCODING_SCHEME |
CHAR(1) NOT NULL |
Encoding scheme of the parameter:
A ASCII
E EBCDIC
U UNICODE
blank The source type is not a character, graphic, or datetime type. |
G |
| IBMREQD |
CHAR(1) NOT NULL |
A value of Y indicates that the row came from the basic machine-readable material
(MRM) tape. For all other values, see Release dependency indicators in topic D.0. |
G |
