SYSSTATEMENTS

Describes all prepared statements in the distributed system.

The table contains one row per stored prepared statement.

Table 1. SYSSTATEMENTS system table
Column Name Type Length Nullable Contents
STMTID CHAR 36 No Unique identifier for the statement
STMTNAME VARCHAR 128 No Name of the statement
SCHEMAID CHAR 36 No The schema in which the statement resides
TYPE CHAR 1 No Always 'S'
VALID BOOLEAN 1 No Whether or not the statement is valid
TEXT LONG VARCHAR 32,700 No Text of the statement
LASTCOMPILED TIMESTAMP 29 Yes Time that the statement was compiled
COMPILATIONSCHEMAID CHAR 36 Yes ID of the schema containing the statement
USINGTEXT LONG VARCHAR 32,700 Yes Not used.