HP 3000 Manuals HP 3000 Manuals
Basic Terms for Getting Started
The following definitions will get you started. A complete alphabetical
listing of all terms and their definitions can be found in the glossary
at the end of this guide.
[REV BEG]
* ATC--the terms Turbo CONNECT and ALLBASE/Turbo CONNECT (ATC) were
used for earlier versions of IMAGE/SQL. The acronym, ATC, still
appears in error messages for IMAGE/SQL (for example, ATCERR or
ATCWARN).
* ATCUtil--is the previous name for the IMAGE/SQL utility program,
now called IMAGESQL.[REV END]
* ISQL--stands for Interactive Structured Query Language. With
ISQL, you can interactively define and access data in an
ALLBASE/SQL relational database environment. Most ALLBASE/SQL
statements can be submitted interactively through ISQL, although a
few statements specifically support programmatic database access
and can only be submitted in application programs.
* SQLUtil--is the ALLBASE/SQL utility program. It is a different
utility from the IMAGE/SQL utility.
* DBEnvironment-- a collection of related files containing one or
more ALLBASE/SQL databases that share the same logging and
recovery process.
* Table--the basic unit of storage in an ALLBASE/SQL database.
Tables are made up of rows and columns of data.
* Attached Database--a TurboIMAGE/XL database whose data can be
accessed using relational access. Information about the attached
TurboIMAGE/XL database is stored in the DBEnvironment.
* Detached Database--a TurboIMAGE/XL database whose data cannot be
accessed using relational access. No information about the
TurboIMAGE/XL database is stored in the DBEnvironment. A
TurboIMAGE/XL database must be detached from a DBEnvironment
before it is restructured, with the exception of capacity change.
* Mapping--the process IMAGE/SQL uses to allow a TurboIMAGE/XL
database to emulate a DBEnvironment database. Mapping takes place
for TurboIMAGE/XL names, data sets, data items, indices, data item
types, and data security.
* Mapped Table--a table defined in the DBEnvironment based on a
TurboIMAGE/XL data set. Data set characteristics are mapped by
the IMAGE/SQL utility to ALLBASE/SQL characteristics.
* DBC (Database Creator)--the creator of the TurboIMAGE/XL database.
You must be either the database creator or give the TurboIMAGE/XL
database maintenance word to attach the database to a
DBEnvironment. Commands that add users, or view or modify user
information can only be executed by the DBC.
* DBECreator--the individual who originally configured the
DBEnvironment.
* DBA (Database Administrator)--a database administrator of the
DBEnvironment. You must be a DBA of the DBEnvironment to which
the TurboIMAGE/XL database is attached to issue most IMAGE/SQL
utility commands. The creator of the DBEnvironment is
automatically a DBA. Other ALLBASE/SQL users can be granted DBA
authority by a DBA.
* DBEConFile--DBEnvironment Configuration File, or DBEConFile,
contains basic information that is used every time the
DBEnvironment is opened. When you create a DBEnvironment,
IMAGE/SQL creates the DBEConFile with the same name as the
DBEnvironment itself. The DBEConFile points to the other
DBEnvironment components.