The SYSSTATEMENTS table describes the prepared statements in the database.
The table contains one row per stored prepared statement.
The following table shows the contents of the SYSSTATEMENTS system table.
Column Name | Type | Length | Nullable | 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 | Whether or not the statement is valid |
TEXT | LONG VARCHAR | 32,700 | false | Text of the statement |
LASTCOMPILED | TIMESTAMP | 29 | true | Time that the statement was compiled |
COMPILATIONSCHEMAID | CHAR | 36 | true | 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 |