IBM Books

Administration Guide


SYSCAT.PROCPARMS

Contains a row for each parameter of a stored procedure.

Table 83. SYSCAT.PROCPARMS Catalog View
Column Name Data Type Nullable Description
PROCSCHEMA CHAR(8)
Qualified procedure name.
PROCNAME VARCHAR(18)
SPECIFICNAME VARCHAR(18)
The name of the procedure instance (may be system generated).
ORDINAL SMALLINT
The parameter's numerical position within the procedure signature.
PARMNAME VARCHAR(18)
Parameter name.
TYPESCHEMA CHAR(8)
Qualified name of data type of the parameter.
TYPENAME VARCHAR(18)
LENGTH INTEGER
Length of the parameter.
SCALE SMALLINT
Scale of the parameter.
CODEPAGE SMALLINT
Code page of parameter. 0 denotes either not applicable or a parameter for character data declared with the FOR BIT DATA attribute.
PARM_MODE VARCHAR(5)
IN=Input, OUT=Output, INOUT=Input/output
AS_LOCATOR CHAR(1)
Always 'N'


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]