The SYSPACKAGE view contains one row for each SQL package in the SQL
schema. The following table describes the columns in the 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. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.