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 | 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 |