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: |
| QUOTE | QUOTE | CHAR(1) | Escape character specification (Y/N): |
| COMMA | COMMA | CHAR(1) | Comma option specification (Y/N): |
| 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. |
| ROUNDING_MODE | DECFLTRND | CHAR(1) | The rounding mode for the package:
|
| CONCURRENTACCESSRESOLUTION | CONCURRENT | CHAR(1) | Specifies the concurrent access resolution:
|