ALLBASE/SQL Reference Manual: HP 3000 MPE/iX Computer Systems > Chapter 1 IntroductionALLBASE/SQL Components |
|
ALLBASE/SQL consists of several distinct components, which are shown in 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:
TurboIMAGE/XL database management system is now integrated with the ALLBASE/SQL interface enabling access to TurboIMAGE data through standard SQL. As SQL statements come from ISQL or from the preprocessors, they are passed along to the two following subsystems:
In addition, these utility programs help you perform the necessary maintenance tasks: The utility programs listed that are not included in Figure 1-1 all interact with the Storage Manager (DBCore). 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. 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. |