Each row represents an SQL statement in a package.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
PKGSCHEMA | VARCHAR (128) | Schema name of the package. | |
PKGNAME | VARCHAR (128) | Unqualified name of the package. | |
STMTNO | INTEGER | Line number of the SQL statement in the source module of the application program. | |
SECTNO | SMALLINT | Number of the package section containing the SQL statement. | |
SEQNO | INTEGER | Always 1. | |
TEXT | CLOB (2M) | Text of the SQL statement. | |
UNIQUE_ID | CHAR (8) FOR BIT DATA | Identifier for a specific package when multiple packages having the same name exist. | |
VERSION | VARCHAR (64) | Y | Version identifier for the package. |