The SYSPROCS view contains one row for each procedure created by the CREATE PROCEDURE statement.
The following table describes the columns in the SYSPROCS view:
| Column Name | System Column Name | Data Type | Description |
|---|---|---|---|
| SPECIFIC_SCHEMA | SPECSCHEMA | VARCHAR(128) | Schema name of the routine (procedure) instance. |
| SPECIFIC_NAME | SPECNAME | VARCHAR(128) | Specific name of the routine instance. |
| ROUTINE_SCHEMA | PROCSCHEMA | VARCHAR(128) | Name of the SQL schema (schema) that contains the routine. |
| ROUTINE_NAME | PROCNAME | VARCHAR(128) | Name of the routine. |
| ROUTINE_CREATED | RTNCREATE | TIMESTAMP | Identifies the timestamp when the routine was created. |
| ROUTINE_DEFINER | DEFINER | VARCHAR(128) | Name of the user that defined the routine. |
| ROUTINE_BODY | BODY | VARCHAR(8) | The type of the routine body:
|
| EXTERNAL_NAME | EXTNAME | VARCHAR(279) Nullable |
This column identifies the external
program name.
|
| EXTERNAL_LANGUAGE | LANGUAGE | VARCHAR(8) Nullable |
If this is an external routine, this
column identifies the external program name.
Contains the null value if this is not an external routine. |
| PARAMETER_STYLE | PARM_STYLE | VARCHAR(7) Nullable |
If this is an external routine, this
column identifies the parameter style (calling convention).
Contains the null value if this is not an external routine. |
| IS_DETERMINISTIC | DETERMINE | VARCHAR(3) | This column identifies whether the
routine is deterministic. That is, whether a call to the routine with
the same arguments will always return the same result.
|
| SQL_DATA_ACCESS | DATAACCESS | VARCHAR(8) | This column identifies whether a
routine contains SQL and whether it reads or modifies data.
|
| SQL_PATH | SQL_PATH | VARCHAR(3483) Nullable |
If this is an SQL routine, this column
identifies the path. Contains the null value if this is not an SQL routine. |
| PARM_SIGNATURE | SIGNATURE | VARCHAR(2048) | This column identifies the routine signature. |
| RESULT_SETS | RESULTS | SMALLINT | Identifies the maximum number of result sets returned. 0 indicates that there are no result sets. |
| IN_PARMS | IN_PARMS | SMALLINT | Identifies the number of input parameters. 0 indicates that there are no input parameters. |
| OUT_PARMS | OUT_PARMS | SMALLINT | Identifies the number of output parameters. 0 indicates that there are no output parameters. |
| INOUT_PARMS | INOUT_PARM | SMALLINT | Identifies the number of input/output parameters. 0 indicates that there are no input/output parameters. |
| LONG_COMMENT | REMARKS | VARGRAPHIC(2000) CCSID
1200Nullable ![]() |
A character string supplied with
the COMMENT statement. Contains the null value if there is no long comment. |
ROUTINE_DEFINITION![]() |
ROUTINEDEF![]() |
DBCLOB(2M) CCSID 13488 Nullable ![]() |
If this is an SQL routine, this column
contains the SQL routine body.
![]() |
| DBINFO | DBINFO | VARCHAR(3) Nullable |
Identifies whether information about
the database is passed to the procedure.
|
| COMMIT_ON_RETURN | CMTONRET | VARCHAR(3) Nullable |
This column identifies whether the
procedure commits on a successful return from the procedure.
|
| IASP_NUMBER | IASPNUMBER | SMALLINT | Specifies the independent auxiliary storage pool (IASP) number. |
| NEW_SAVEPOINT_LEVEL | NEWSAVEPTL | VARCHAR(3) Nullable |
This column identifies whether the
routine starts a new savepoint level.
|
| ROUNDING_MODE | DECFLTRND | CHAR(1) Nullable |
If this is an SQL procedure, identifies the
DECFLOAT rounding mode.
Contains the null value if the procedure is not an SQL procedure. |
ROUTINE_TEXT![]() |
LABEL![]() |
VARGRAPHIC(50) CCSID
1200Nullable ![]() |
Contains the label for a routine.
Contains the null value if a label does not exist.![]() |