Contains one or more rows for each SQL statement in each package in the
database.
Table 84. SYSCAT.STATEMENTS Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| PKGSCHEMA | VARCHAR(128) |
| Name of the package. |
| PKGNAME | CHAR(8) |
| |
| 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 | SMALLINT |
| Always 1. |
| TEXT | CLOB (64K) |
| Text of the SQL statement. |