ALLBASE/SQL Reference Manual (36216-90216)

54 Chapter1
Introduction
SQL Statement Categories
SQL Statement Categories
Writing queries is the basis of data manipulation in ALLBASE/SQL. All users employ the
SELECT statement for this purpose. SQL has several other general-purpose statements,
and also has statements specifically for use by application programmers or database
administrators. The SQL statements are functionally summarized inTable 1-1. For the
commands in each category, refer to Table 10-1., “SQL Statement Summary.”
Table 1-1. SQL Statement Categories
Group Category Purpose
General-purpose
statements
DBEnvironment
session management
Statements for obtaining and terminating
database access.
Data definition Statements for defining tables, views, indexes,
DBEFiles, DBEFileSets, TempSpace, and other
SQL objects.
Data manipulation Statements for selecting, inserting, and
changing rows.
Transaction
management
Statements for committing or rolling back work
done within a single transaction. A transaction
is a unit of work and may consist of one or
multiple SQL statements.
Concurrency Statements for managing data contention in
multiuser mode.
Module Maintenance Statements for managing modules and
procedures.
Application
programming
statements
Single row data
manipulation
Statements for manipulating a single row with
each statement execution.
Bulk data
manipulation
Statements for manipulating multiple rows
with a single statement execution.
Cursor management Statements for manipulating individual rows
in a set of rows that satisfy a SELECT
statement.
Preprocessor directives Statements for declarations in application
programming.
Dynamically
preprocessed queries
Statements for handling statements
preprocessed at run time.
Status messages A statement for retrieving an ALLBASE/SQL
message describing the status of an SQL
statement execution.