SYSSTATEMENTS system table

The SYSSTATEMENTS table describes the prepared statements in the database.

The table contains one row per stored prepared statement.

The following table shows the contents of the SYSSTATEMENTS system table.

Table 1. SYSSTATEMENTS system table
Column Name Type Length Nullable Contents
STMTID CHAR 36 false Unique identifier for the statement
STMTNAME VARCHAR 128 false Name of the statement
SCHEMAID CHAR 36 false The schema in which the statement resides
TYPE CHAR 1 false Always 'S'
VALID BOOLEAN 1 false Whether or not the statement is valid
TEXT LONG VARCHAR 32,700 false Text of the statement
LASTCOMPILED TIMESTAMP 29 true Time that the statement was compiled
COMPILATIONSCHEMAID CHAR 36 true ID of the schema containing the statement
USINGTEXT LONG VARCHAR 32,700 true Text of the USING clause of the CREATE STATEMENT and ALTER STATEMENT statements