ALLBASE/SQL Reference Manual (36216-90216)

286 Chapter10
SQL Statements A - D
SQL Statement Summary
Executing
procedures
EXECUTE PROCEDURE Invokes a procedure.
Other RAISE ERROR Causes a user-defined error to occur
and specifies the error number and
text to be raised.
Concurrency
CREATE TABLE Defines the automatic locking
strategy and implicit authority
grants used for a table.
LOCK TABLE Locks a table, explicitly overriding
ALLBASE/SQL's automatic locking
strategy.
START DBE Defines the maximum number of
transactions that can execute
concurrently, when used with the
TRANSACTION= parameter.
Module maintenance
DROP MODULE Deletes a module from the system
catalog, optionally retaining
authorization information.
GENPLAN Places optimizer's access plan in
SYSTEM.PLAN (from ISQL only).
SETOPT Modifies access optimization plan
used by queries.
VALIDATE Validates modules and procedures.
Application Programming Statements
Single row data manipulations
FETCH Retrieves a single row from an
active set associated with a cursor.
INSERT Inserts a single row into a table.
SELECT Retrieves a single row not
associated with a cursor.
Bulk manipulations
BULK FETCH Retrieves multiple rows from an
active set associated with a cursor.
(See FETCH.)
Table 10-1. SQL Statement Summary
Group Category Statement Statement Use