ALLBASE/SQL Reference Manual (36216-90216)

42 Chapter1

Introduction

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 ﬁle 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, veriﬁes that the user has the

appropriate authorization for it, and processes queries.

• Storage Manager performs physical ﬁle management, and transaction and logging

tasks. The Storage Manager is also referred to as DBCore.