Tabelas SYSIBM

Contains a row for each parameter of a routine or multiple rows for table parameters (one for each column of the table).

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