Contains one row per stored prepared statement.
Column Name
Type
Length
Nullability
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
false
TRUE if valid, FALSE if invalid
TEXT
LONG VARCHAR
false
text of the statement
LASTCOMPILED
TIMESTAMP
true
time that the statement was compiled
COMPILATION SCHEMAID
CHAR
36
false
id of the schema containing the statement
USINGTEXT
LONG VARCHAR
true
text of the USING clause of the CREATE STATEMENT and ALTER
STATEMENT statements