The system table PACKAGES describes all the packages for which the current user has privileges.
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 |