PACKAGES

Definition

The system table PACKAGES describes all the packages for which the current user has privileges.

Structure

PACKAGES

OWNER

CHAR(32)

Name of the owner of the package

PACKAGE

CHAR(32)

Name of the package

CREATEDATE

DATE

Creation date of the package

CREATETIME

TIME

Creation time of the package

EXCECUTION_KIND

CHAR(6)

Execution location of database procedure (INPROC | LOCAL)

SQL_SUPPORT

CHAR(3)

Database procedure may contain SQL statements (YES | NO)

REMOTE_LOCATION

CHAR(132)

Execution location

FILE

CHAR(256)

File name of the library that contains the implementation of this package

COMMENT

LONG

Comment for the package