ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 289
SQL Statements A - D
SQL Statement Summary
STOP DBE
Terminates all DBE
sessions and causes a
checkpoint to be taken,
recovering log file space if
nonarchive logging is in
effect.
TERMINATE QUERY Terminates a running Query.
TERMINATE
TRANSACTION
Stops the transaction.
TERMINATE USER Stops the DBE session for a specific
user.
DBEnvironment settings
ENABLE RULES Turns rule checking on for the
current DBEnvironment session.
DISABLE RULES Turns rule checking off for the
current DBEnvironment session.
SET PRINTRULES Specifies whether rule names and
statement types are to be issued as
messages when the rules are fired
during a DBEnvironment session.
SET USER TIMEOUT Specifies the amount of time the
user waits if requested database
resource is unavailable.
Space Management
DBEFiles ADD DBEFILE Associates a DBEFile with a
DBEFileSet.
ALTER DBEFILE Changes the type attribute of a
DBEFile.
CREATE DBEFILE Defines and creates a DBEFile.
DROP DBEFILE Removes the definition of an empty
DBEFile not associated with a
DBEFileSet.
REMOVE DBEFILE Disassociates a DBEFile from a
DBEFileSet.
DBEFileSets CREATE DBEFILESET Defines a DBEFileSet.
Table 10-1. SQL Statement Summary
Group Category Statement Statement Use