 |
» |
|
|
|
ALLBASE/SQL consists of several distinct components, which
are shown in Title not available. 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.
Utility Programs | |
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. |
