SYSCAT.STATEMENTS catalog view
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. |