DBPROCEDURES 

Use

This table contains all the database procedures for which the current user has privileges.

Structure

DBPROCEDURES

OWNER

CHAR(32)

Name of the owner of the database procedure

DBPROCNAME

CHAR(32)

Name of the database procedure

PACKAGE

CHAR(32)

Package containing the database procedure

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

EXCECUTION_KIND

CHAR(6)

Execution type of the database procedure (inproc / local / remote)

SQL_SUPPORT

CHAR(3)

Database procedure may contain SQL statements (yes / no)

REMOTE_LOCATION

CHAR(132)

Execution location

COMMENT

LONG

Comment on the database procedure

Integration

System tables