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 |