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