HP 3000 Manuals

ALLBASE/SQL Reference Manual

ALLBASE/SQL Components 

ALLBASE/SQL consists of several distinct components, which are shown in
Figure 1-1 .


          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.
[REV BEG]

TurboIMAGE/XL database management system is now integrated with the
ALLBASE/SQL interface enabling access to TurboIMAGE data through standard
SQL.[REV END]

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. 
[REV BEG]

Utility Programs 

In addition, these utility programs help you perform the necessary
maintenance tasks:[REV END]

   *   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. 
       [REV BEG]

   *   SQLCheck checks the integrity of a DBEnvironment. 
       [REV END]

   *   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. 
[REV BEG]

The utility programs listed that are not included in Figure 1-1 all
interact with the Storage Manager (DBCore).[REV END]

ISQL is described in the ISQL Reference Manual for ALLBASE/SQL and 
IMAGE/SQL. The preprocessors are documented in separate ALLBASE/SQL
application programming guides for each language and the release specific
ALLBASE/SQL Advanced Application Programming Guide.
[REV BEG]

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.[REV END]

MPE/iX 5.5 Documentation