SYSSTATEMENTS system table

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 1 false TRUE if valid, FALSE if invalid
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