The table contains one row per stored prepared statement.
The following table shows the contents of the SYSSTATEMENTS system table.
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
false
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