DB2 Universal Database for iSeries SQL Reference

SYSPACKAGE

The SYSPACKAGE view contains one row for each SQL package in the SQL schema. The following table describes the columns in the SYSPACKAGE view:

Table 120. SYSPACKAGE view

Column Name System Column Name Data Type Description
PACKAGE_CATALOG LOCATION VARCHAR(128) Relational database name (RDBNAME) of the SQL package
PACKAGE_SCHEMA COLLID VARCHAR(128) Name of the schema
PACKAGE_NAME NAME VARCHAR(128) Name of the SQL package
PACKAGE_OWNER OWNER VARCHAR(128) Owner of the SQL package
PACKAGE_CREATOR CREATOR VARCHAR(128) Creator of the SQL package
CREATION_TIMESTAMP TIMESTAMP CHAR(26) Timestamp of when the SQL package was created
DEFAULT_SCHEMA QUALIFIER VARCHAR(128) Implicit name for unqualified tables, views, and indexes
PROGRAM_NAME PROGNAME VARCHAR(128) Name of program the package was created from
PROGRAM_SCHEMA LIBRARY VARCHAR(128) Name of schema containing the program
PROGRAM_CATALOG RDB VARCHAR(128) Name of the relational database where the program resides
ISOLATION ISOLATION CHAR(2) Isolation option specification:
RR Repeatable Read (*RR)
RS Read Stability (*ALL)
CS Cursor Stability (*CS)
UR Uncommitted Read (*CHG)
NO None (*NONE)
QUOTE QUOTE CHAR(1) Escape character specification (Y/N):
Y = Quotation mark
N = Apostrophe
COMMA COMMA CHAR(1) Comma option specification (Y/N):
Y = Comma
N = Period
PACKAGE_TEXT LABEL VARCHAR(50) A character string you supply with the LABEL statement.
LONG_COMMENT REMARKS VARCHAR(2000) A character string supplied with the COMMENT statement.

Contains the null value if there is no long comment.

CONSISTENCY_TOKEN CONTOKEN CHAR(8) FOR BIT DATA Consistency token of package
SYSTEM_PACKAGE_NAME SYS_NAME CHAR(10) System name of the package.
SYSTEM_PACKAGE_SCHEMA SYS_DNAME CHAR(10) System name of the schema containing the package.
SYSTEM_DEFAULT_SCHEMA SYS_DDNAME CHAR(10) System name of the implicit qualifier for unqualified table, views, indexes, and packages.
SYSTEM_PROGRAM_NAME SYS_PNAME CHAR(10) System name of the program.
SYSTEM_PROGRAM_SCHEMA SYS_PDNAME CHAR(10) System name of the schema containing the program
IASP_NUMBER IASPNUMBER SMALLINT Specifies the independent auxiliary storage pool (IASP) number.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]