HP 3000 Manuals

Getting Started with HP IMAGE/SQL

Setting IMAGE/SQL File Equations 

This task describes how to set IMAGE/SQL utility file equations for two
files:  ATCINFO and ATCLOG.

Performing the Task 

Setting a File Equation for ATCINFO 

An ATCINFO file equation can only be set before the file is created
(before any TurboIMAGE/XL databases are attached to the DBEnvironment;
see Task Reference).  Only the file name can be specified.  Other
parameters of the FILE command will not be valid at attach time.

For example:
_____________________________________
|                                   |
|     :FILE ATCINFO = SONGSCR       |
|     :                             |
_____________________________________

            

Setting a File Equation for ATCLOG 

A file equation for ATCLOG can be issued before beginning an IMAGE/SQL
utility session.

For example:
_____________________________________
|                                   |
|     :FILE ATCLOG = LOGA1; SAVE    |
|     :                             |
_____________________________________

            

In the above example, when the logging option is on, IMAGE/SQL Utility
commands are logged to the permanent file, LOGA1.

A file equation for ATCLOG can also be set or reset from within the
IMAGE/SQL utility.

For example:
_____________________________________
|                                   |
|     >>:FILE ATCLOG = LOGA2; SAVE  |
|     >>                            |
_____________________________________

            

Now when the logging option is on, IMAGE/SQL utility commands are logged
to the permanent file, LOGA2 (see Task Reference).

Task Reference 

ATCINFO Reference.     

   *   ATCINFO is a permanent privileged file containing mapping
       information about data set and field names, data types, and user
       security.  Its formal file designator is ATCINFO. The default name
       of the ATCINFO file is DBEnvironment-nameCR.

   *   One ATCINFO file exists for each DBEnvironment.  It is created in
       the same group and account as the DBEnvironment and is considered
       part of the DBEnvironment.

   *   The ATCINFO file equation can only be used to specify a different
       file name.  It cannot be used to override other ATCINFO file
       characteristics.

ATCLOG Reference.     

   *   ATCLOG is a temporary unnumbered ASCII file to which all IMAGE/SQL
       utility commands are written when IMAGE/SQL utility logging is on.
       If this file does not already exist, it is created.  If it already
       exists as a temporary or permanent file, log file records are
       appended to it.  Its formal file designator is ATCLOG.

   *   When an IMAGE/SQL utility session begins, logging is on and the
       ATCLOG file is created (if it does not already exist) and opened
       in the user's logon group and account.  By default, it is a
       temporary file named ATCLOG, but you may wish to set a file
       equation for this file.

   *   If you want to save the temporary file, either specify SAVE as a
       part of the FILE command or save the file before ending your
       current MPE/iX session.

   *   The FILE command can be used to override default ATCLOG file
       attributes, such as size and file domain.  However, the log file
       must remain an unnumbered ASCII file.

MPE/iX 5.0 Documentation