[top]
[prev]
[next]

Documentation Top
Global Index
Reference Manual
TOC Index
Grammar Index
Developer’s Guide
TOC Index
Tuning Cloudscape
TOC Index
|
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 |
|
false |
time that the statement was compiled |
COMPILATIONSCHEMAID |
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 |
Indexes
- SYSSTATEMENTS_INDEX1 unique BTREE index on STMTID
- SYSSTATEMENTS_INDEX2 unique BTREE index on STMTNAME, SCHEMAID
Sample Queries
SELECT COLUMNNUMBER, COLUMNDEFAULT, COLUMNDATATYPE.toString() FROM SYS.SYSCOLUMNS C, SYS.SYSSTATEMENTS S WHERE C.REFERENCEID = S.STMTID AND S.STMTNAME = 'GETFULLFLIGHTINFO'
|