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