ALLBASE/SQL Reference Manual (36216-90216)

288 Chapter10
SQL Statements A - D
SQL Statement Summary
WHENEVER Specifies an action to be taken
depending on the outcome of an
SQL statement.
Dynamically preprocessed queries
DESCRIBE Obtains information about the
results of a dynamic statement.
EXECUTE
EXECUTE IMMEDIATE
PREPARE
Refer to general-purpose
statements.
Status
messages
SQLEXPLAIN Retrieves a message describing the
status of SQL statement execution.
Database Administration Statements
Authorization
GRANT Grants authorities to all users,
specific users, or groups.
REVOKE Revokes authorities from all users,
specific users, or groups.
TRANSFER OWNERSHIP Makes a different user or
authorization group the owner of a
table, view, authorization group, or
procedure.
Authorization groups
ADD TO GROUP Adds one or more users or groups to
an authorization group.
CREATE GROUP Defines an authorization group.
DROP GROUP Removes the definition of an
authorization group from the
system catalog.
REMOVE FROM GROUP Removes one or more users or
groups from an authorization group.
DBEnvironment configuration and use
START DBE NEW Configures a new DBEnvironment.
START DBE Makes a DBEnvironment available
in a mode different from that
defined in the DBECon file; also
starts up a DBEnvironment when
the autostart flag is off.
Table 10-1. SQL Statement Summary
Group Category Statement Statement Use