Cloudscape System Tables
Page 14 of 17

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

-- Find information about each of the parameters used by
-- the getFullFlightInfo statement. Return the position
-- of the parameter, its sample value (if any), and its type
SELECT COLUMNNUMBER, COLUMNDEFAULT, COLUMNDATATYPE.toString()
FROM SYS.SYSCOLUMNS C, SYS.SYSSTATEMENTS S
WHERE C.REFERENCEID = S.STMTID
AND S.STMTNAME = 'GETFULLFLIGHTINFO'