apache > db
Apache DB Project
 
Font size:      

SYSSTATEMENTS

SYSSTATEMENTS

Contains one row per stored prepared statement.

Column NameTypeLengthNullabilityContents
STMTIDCHAR36falseunique identifier for the statement
STMTNAMEVARCHAR128falsename of the statement
SCHEMAIDCHAR36falsethe schema in which the statement resides
TYPECHAR1falsealways 'S'
VALIDBOOLEAN
falseTRUE if valid, FALSE if invalid
TEXTLONG VARCHAR
falsetext of the statement
LASTCOMPILEDTIMESTAMP
truetime that the statement was compiled
COMPILATION SCHEMAIDCHAR36falseid of the schema containing the statement
USINGTEXTLONG VARCHAR
truetext of the USING clause of the CREATE STATEMENT and ALTER STATEMENT statements

Previous Page
Next Page
Table of Contents
Index