IBM Books

Administration Guide


SYSCAT.STATEMENTS

Contains one or more rows for each SQL statement in each package in the database.

Table 87. 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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]