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 “SQL Statement Categories” 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.
Database administration statements	Authorization	Statements for controlling DBEnvironment access.
	DBEnvironment configuration and use	Statements for controlling DBEnvironments.
	Space management	Statements for managing DBEFiles used for tables and indexes; statements for managing temporary space for sorting.
	Logging	Statements for managing log files.
	DBEnvironment statistics management	Statements related to the system catalog.
	Procedure control flow statements	Statements used only inside procedures.
Procedure statements	General and Control Flow Statements	Statements used only inside procedures.

If you are embedding SQL statements in an application program, refer to the ALLBASE/SQL application programming guide for the language you are using. Bulk data manipulation is not available for FORTRAN. COBOL and FORTRAN do not provide the full set of dynamic preprocessing statements.

SQL Statement Categories

Technical documentation

» Table of Contents

» Index