ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 291
SQL Statements A - D
SQL Statement Summary
Audit
logging
DISABLE AUDIT
LOGGING
Disables current audit logging for a
session.
Log
comment
LOG COMMENT Enters a user comment in the log
file.
ENABLE AUDIT LOGGING Enables audit logging for a session
after being disabled.
Recovery Rollback
START DBE Rolls back transactions that were
incomplete the last time the
DBEnvironment was shut down.
TERMINATE USER Ends a user's transactions, backing
out any work not committed.
STOP DBE Terminates all DBE sessions and
causes a checkpoint to be taken,
Rollforward BEGIN ARCHIVE
COMMIT ARCHIVE
Creates an archive record in the
rollforward log(s) and initiates
archive mode logging.
DBEnvironment statistics
RESET Resets ALLBASE/SQL accounting
and statistical data activity
management.
UPDATE STATISTICS Updates system catalog information
used to optimize data access
operations on a per table basis.
Procedure Statements
General statements
Assignment (=) Assignsa value to a localvariable or
parameter in a procedure.
DECLARE Variable Defines a local variable within a
procedure.
PRINT Stores information to be displayed
by ISQL or an application program.
Control flow statements
BEGIN Begins a single statement or group
of statements within a procedure.
GOTO Permits a jump to a labeled
statement within a procedure.
Table 10-1. SQL Statement Summary
Group Category Statement Statement Use