ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 283
SQL Statements A - D
SQL Statement Summary
10 SQL Statements A - D
Chapters 10, 11 and 12 describe all the SQL statements in alphabetical order, giving
syntax, parameters, descriptions, authorization requirements, and examples for each
statement. Examples often consist of groups of statements so you can see how each
statement is related to other statements functionally.
SQL Statement Summary
SQL statements fall into four groups. General-purpose statements are used
programmatically, interactively, and in procedures. Application programming statements
are used in application programs. Database administration statements are usually used
interactively. Procedure, control flow, and status statements are used only in procedures.
Within each of these groups, the SQL statements fall into categories, as shown in Table
10-1.
Table 10-1. SQL Statement Summary
Group Category Statement Statement Use
General Purpose Statements
DBEnvironment session management
CONNECT Begins a DBEnvironment session.
DISCONNECT Terminates a connection to a
DBEnvironment, or all connections.
SET CONNECTION Sets the current connection within
the currently connected set of
DBEnvironments.
SET MULTI
TRANSACTION
Switches between
single-transaction mode and
multi-transaction mode.
RELEASE Terminates a DBEnvironment
session.
Data definition
Databases CREATE SCHEMA Defines a database and associates it
with an authorization name.
Indexes CREATE INDEX Defines an index for a table based
on one or more of its columns.
DROP INDEX Deletes an index.