SYSSTATEMENTS
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 |
Previous Page
Next Page
Table of Contents
Index