HPlogo ALLBASE/SQL Reference Manual > Chapter 1 Introduction

SQL Statement Categories

MPE documents

Complete PDF
Table of Contents
Index

E0300 Edition 9 ♥
E0399 Edition 8
E0897 Edition 7

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 in Table 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 statementsDBEnvironment 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 statementsSingle 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 statementsAuthorization 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 statementsGeneral 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.



Using Comments within SQL Statements

Error Conditions in ALLBASE/SQL