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.

Setting IMAGE/SQL File Equations

Technical documentation

» Table of Contents

» Glossary

» Index

Setting a File Equation for ATCINFO

Setting a File Equation for ATCLOG

ATCINFO Reference

ATCLOG Reference