Object documentationDBPROCEDURES Locate this document in the navigation structure

 

The system table DOMAIN.DBPROCEDURES contains all the database procedures for which the current user has privileges.

Structure

DBPROCEDURES

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

More Information

Evaluating System Tables, DBPROCEDURES

SQL Reference Manual, Name of a Database Procedure (dbproc_name)

Database Administration in CCMS, DB Procedures