Contains one or more rows for each SQL statement in each package in the
database.
Table 63. SYSCAT.STATEMENTS Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| PKGSCHEMA | CHAR(8) |
| Name of the package. |
| PKGNAME | CHAR(8) |
| |
| STMTNO | SMALLINT |
| 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 |
| Sequence number of this row; the first portion of the SQL text is stored on row one, and successive rows have increasing values for SEQNO. |
| TEXT | VARCHAR (3600) |
| Text or portion of the text of the SQL statement. |