 |
» |
|
|
|
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. 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.
|