IMAGE/SQL includes TurboIMAGE/XL, certain components of ALLBASE/SQL, and a database
administration tool that links them together. The database administration
tool is the IMAGE/SQL utility. The components of IMAGE/SQL are described below:
TurboIMAGE/XL |
 |
A set of programs and procedures for defining, creating, accessing,
and maintaining TurboIMAGE/XL databases. TurboIMAGE/XL databases can be accessed
using TurboIMAGE/XL procedures, utilities, and applications. IMAGE/SQL adds the
ability to access TurboIMAGE/XL databases by using the industry-standard
SQL language.
ALLBASE/SQL |
|
A set of programs and procedures for creating, maintaining, and accessing
relational database environments. IMAGE/SQL includes the ALLBASE/SQL components
needed to provide relational access to TurboIMAGE/XL databases.
HP PC API for ALLBASE/SQL and IMAGE/SQL |
|
Software that provides a programmatic interface to IMAGE/SQL
for creating Microsoft windows-based client-server applications.
With HP PC API for ALLBASE/SQL and IMAGE/SQL, you use
one of several available 4GL and decision support
tools to build your application,
which connects to ALLBASE/SQL over a network through ALLBASE/NET.
ALLBASE/NET |
|
Works with HP PC API for ALLBASE/SQL and IMAGE/SQL
in connecting users with databases over a network.
IMAGE/SQL Utility |
|
A database administrator's tool for managing TurboIMAGE/XL databases in a
relational access environment. This tool attaches and detaches
databases to and from DBEnvironments for access via SQL. Other
management functions, such as security and data type mapping,
are accomplished through this utility.
Refer to the HP IMAGE/SQL Administration Guide for details on the IMAGE/SQL utility.
ISQL |
|
An interactive command processor that lets you enter SQL
statements at the keyboard and observe query results, messages, and
other information on a video display. SQL is a
language--not a software system. Therefore, you need an
interactive way to submit SQL statements.
ISQL is the main tool used
by IMAGE/SQL programmers and database administrators to
create and modify DBEnvironments. It
is also used by anyone who needs to submit queries using the SQL
language. ISQL is especially useful for loading and unloading data.
SQLGEN |
|
A database administrator's tool that generates the commands used
to recreate all or part of an existing DBEnvironment. It also
generates LOAD/UNLOAD and UPDATE STATISTICS statements. These
commands are placed in one or more data files called schema files,
which can then be used as ISQL command files to recreate the DBEnvironment
(not the TurboIMAGE/XL database.)
SQLUtil |
|
A database administrator's tool for displaying and setting the
basic parameters of a DBEnvironment (explained further in
Chapter 2, "Basic Concepts"), storing and restoring DBEnvironments, setting the
size of system buffers, and purging DBEnvironments. The database
administrator (DBA) is the individual who creates and maintains
objects in a DBEnvironment. SQLUtil is seldom needed by the ordinary user.
Preprocessors |
|
Tools that convert source programs containing SQL statements into
source code that can be compiled
in a programming language of your choice. Different
preprocessors let you code applications in C, COBOL, FORTRAN, and
Pascal.
