HP 3000 Manuals HP 3000 Manuals
Using ATCUtil Command Files: Task 13
This task describes how to execute an ATCUtil command file in interactive
or batch mode.
Getting Ready
An ATCUtil command file can be created with a text editor or can be
produced as part of the logging process (see Task Reference). If you
create or edit this file with an editor, note that it must be kept
unnumbered.
In the following examples, the file UPDATYPE contains the following
commands:
_______________________________________________________
| |
| SET TURBODB SALES.SERED.ATC |
| SET SQLDBE PARTSDBE.SERED.ATC |
| UPDATE TYPE IN CUSTOMER.CREDIT_RATING TO CHAR(4)|
| EXIT |
_______________________________________________________
Note that the commands in this command file assume the TurboIMAGE/XL
database is already attached to the DBEnvironment.
If you wish to see commands and comments as the command file is executed,
make sure the ECHO option is on (see Task Reference).
Performing the Task
The XEQ command allows you to specify a file containing ATCUtil commands
as its parameter. To interactively execute commands listed in a command
file, run ATCUtil and then issue the XEQ command. Note that in this
example ECHO is off.
_______________________________________________________________________________
| |
| :ATCUTIL |
| |
| HP36385A A.00.00 ATC Utility TurboIMAGE/XL|
| (C) COPYRIGHT HEWLETT-PACKARD COMPANY 1989 |
| |
| >> XEQ UPDATYPE |
| Updated information in table CUSTOMER. |
| : |
_______________________________________________________________________________
The SALES database is now attached to the PartsDBE DBEnvironment and data
type mapping information has been updated for the CUSTOMER.CREDIT_RATING
column of the INVENTORY table.
You can also issue XEQ commands in batch mode. The following job stream
file contains XEQ commands that execute the commands in the UPDATYPE
file.
______________________________________________________________________________
| |
| !job JATCUTIL,NANCY/RYAN.ATC/MGR,SERED/ALL |
| !comment************************************************************** |
| !comment* This job executes an ATCUTIL command file. |
| !comment************************************************************** |
| ! |
| !tell NANCY.ATC; /-->Start JATCUTIL for SALES |
| ! |
| !run ATCUTIL.PUB.SYS |
| ! |
| !comment************************************************************** |
| !comment* The UPDATYPE command file contains commands that SET |
| !comment* the SALES database and the PartsDBE DBEnvironment. |
| !comment* It then specifies alternate data type mapping for source|
| !comment* data set fields and exits ATCUtil. |
| !comment************************************************************** |
| ! |
| XEQ UPDATYPE |
| ! |
| !tell NANCY.ATC; /-->End JATCUTIL for SALES |
| ! |
| !eoj |
______________________________________________________________________________
Note that in batch mode, if an error occurs, the job terminates. The
remaining commands are flushed.
Task Reference
* A Turbo CONNECT command file is an unnumbered file containing a list
of Turbo CONNECT commands. If commands span more than one line, use
an ampersand (&) to continue the command to the next line.
* Task 12, "Logging ATCUtil Commands," shows how to use the ATCUtil
logging facility to create and save files containing often-issued
ATCUtil commands.
* For the syntax of the ECHO command, refer to chapter 4, "ATCUtil
Command Syntax."