The system table DOMAIN.DBPROCEDURES contains all the database procedures for which the current user has privileges.
SCHEMANAME |
CHAR(32) |
Name of the schema of the database procedure |
DBPROCNAME |
CHAR(32) |
Name of the database procedure |
OWNER |
CHAR(32) |
Name of the owner of the database procedure |
PACKAGE |
CHAR(32) |
Package containing the database procedure |
DBPROCID |
CHAR(8) |
ID of the database procedure in hexadecimal format |
PARAMETER |
FIXED(4) |
Number of parameters for the database procedure |
CREATEDATE |
DATE |
Creation date of the database procedure |
CREATETIME |
TIME |
Creation time of the database procedure |
EXECUTION_KIND |
CHAR(10) |
Execution location of database procedure (INPROC | LOCAL) |
LANGUAGE |
CHAR(32) |
Implementation language of database procedure (SPL | C++ | JAVA | ...) |
SQL_SUPPORT |
CHAR(3) |
Database procedure may contain SQL statements (YES | NO) |
CURSOR_SUPPORT |
CHAR(3) |
The database system returns a cursor (YES | NO) |
WAIT_FOR_CHCKPT |
CHAR(3) |
NULL |
REMOTE_LOCATION |
CHAR(132) |
NULL |
DEFINITION |
CLOB |
SQL statement for defining the database procedure |
COMMENT |
CLOB |
Comment on the database procedure |
Evaluating System Tables, DBPROCEDURES
SQL Reference Manual, Name of a Database Procedure (dbproc_name)
Database Administration in CCMS, DB Procedures