|
|
ALLBASE/SQL consists of several distinct components, which are shown in
Figure 1-1 "Components of ALLBASE/SQL".
Figure 1-1 Components of ALLBASE/SQL
To access data with ALLBASE/SQL, you use ALLBASE/SQL statements, which conform
to industry standards for SQL statements for relational databases.
You can submit SQL statements interactively or in application
programs as described here:
Interactively, you use ISQL (Interactive SQL) to key in
statements at a terminal. ISQL is the interactive interface to
ALLBASE/SQL.
Programmatically, you embed statements in a C, COBOL, FORTRAN, or
Pascal application program. Then, before compiling the program, you
use an ALLBASE/SQL preprocessor to prepare the program for
run-time database access. The preprocessor converts an embedded SQL
program into a source file for input to a C, COBOL, FORTRAN, or
Pascal compiler.
As SQL statements come from ISQL or from the preprocessors,
they are passed along to the two following subsystems:
Query Processor checks the syntax of each statement,
verifies that the user has the appropriate authorization for it, and
processes queries.
Storage Manager performs physical file management, and
transaction and logging tasks. The Storage Manager is also referred
to as DBCore.
In addition, these utility programs help you perform the necessary maintenance
tasks:
SQLUtil assists with file maintenance, backup, and
recovery.
SQLGEN generates statements for re-creating a given
DBEnvironment.
SQLMigrate lets you move DBEnvironments between releases of
ALLBASE/SQL.
SQLCheck checks the integrity of a DBEnvironment.
SQLMON helps you monitor DBEnvironment performance.
SQLVer checks the version strings of the ALLBASE/SQL
files.
SQLAudit organizes audit log records for analysis of
operations such as UPDATE, INSERT, or DELETE, perhaps
for security reasons.
The utility programs listed that are not included in Figure 1-1 all interact
with the Storage Manager (DBCore).
ISQL is described in the ALLBASE/ISQL Reference Manual. The
preprocessors are documented in separate ALLBASE/SQL application programming
guides for each language and the release specific ALLBASE/SQL Advanced
Application Programming Guide.
SQLUtil, SQLGEN, SQLMigrate, SQLCheck, SQLVer, and SQLAudit
are documented in the ALLBASE/SQL Database Administration Guide.
SQLMON is documented in the ALLBASE/SQL Performance
and Monitoring Guidelines. The rest of this manual describes
SQL, pointing out differences between interactive and programmatic
usage when they exist. Most of the SQL statements can be executed
through either interface.
|