The table contains one row per stored prepared statement.
The following table shows the contents of the SYSSTATEMENTS system table.
SYSSTATEMENTS system table
For each column in the SYSSTATEMENTS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents.
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