IBM Books

Administration Guide


SYSCAT.PROCEDURES

Contains a row for each stored procedure that is created.

Table 82. SYSCAT.PROCEDURES 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).
PROCEDURE_ID INTEGER
Internal ID of stored procedure.
DEFINER CHAR(8)
Authorization of the procedure definer.
PARM_COUNT SMALLINT
Number of procedure parameters.
PARM_SIGNATURE VARCHAR(180) FOR BIT DATA
Concatenation of up to 90 parameter types, in internal format. Zero length if procedure takes no parameters.
ORIGIN CHAR(1)
Always 'E' = User defined, external
CREATE_TIME TIMESTAMP
Timestamp of procedure registration.
DETERMINISTIC CHAR(1)
  Y=Results are deterministic.
  N=Results are not deterministic.

FENCED CHAR(1)
  Y=Fenced
  N=Not Fenced

NULLCALL CHAR(1)
Always Y=NULLCALL
LANGUAGE CHAR(8)
Implementation language of procedure body. Possible values are C and JAVA.
IMPLEMENTATION VARCHAR(254) Yes Identifies the path/module/function or class/method that implements the procedure.
PARM_STYLE CHAR(8)
  DB2DARI=Language is C
  DB2GENRL=Language is Java

RESULT_SETS SMALLINT
Estimated upper limit of returned result sets.
REMARKS VARCHAR(254) Yes User supplied comment, or null.


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

[ DB2 List of Books | Search the DB2 Books ]