Basic Terms for Getting Started

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.

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.