DBPROCEDURES

Definition

The system table 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

PARAMETER

FIXED(4)

Number of parameters for the database procedure

CREATEDATE

DATE(10)

Creation date of the database procedure

CREATETIME

TIME(8)

Creation time of the database procedure

EXECUTION_KIND

CHAR(6)

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)

NO

REMOTE_LOCATION

CHAR(132)

NULL

DEFINITION

LONG

SQL statement for defining the database procedure

COMMENT

LONG

Comment on the database procedure

See also:

Evaluating System Tables, DBPROCEDURES

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