Contains a row for each stored procedure that is created.
Table 217. 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. |