ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 285
SQL Statements A - D
SQL Statement Summary
INSERT Adds a row to a single table or view.
SELECT Retrieves data from one or more
tables or views.
UPDATE Changes the values of one or more
columns in all rows of a specific
table or view that satisfy a search
condition.
DROP MODULE Deletes a preprocessed module.
EXECUTE Executes dynamically preprocessed
statements.
EXECUTE IMMEDIATE Defines and executes dynamic
statements.
PREPARE Dynamically preprocesses
statements, storing them as a
module if issued interactively.
Transaction management
BEGIN WORK Begins a transaction and optionally
sets its isolation level and priority.
COMMIT WORK Ends a transaction and makes
permanent any changes it made to
the DBEnvironment.
ROLLBACK WORK Ends a transaction and undoes
changes made to the
DBEnvironment during the whole
transaction or back to a savepoint
within the transaction.
SAVEPOINT Defines a point within a transaction
back to which you can roll back
work.
SET DML ATOMICITY Sets the general error checking
level.
SET CONSTRAINTS Sets the level of constraint error
checking.
SET SESSION Sets transaction attributes for a
session.
SET TRANSACTION Sets execution attributes for a
transaction.
Table 10-1. SQL Statement Summary
Group Category Statement Statement Use