Font size:

SYSSTATEMENTS

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