|
|
IMAGE/SQL Administration Guide: HP 3000 MPE/iX Computer Systems > Chapter 2 Using the IMAGE/SQL UtilityTask 14: Using IMAGE/SQL Utility Command Files |
|
This task describes how to execute an IMAGE/SQL utility command file in interactive or batch mode. Getting Ready An IMAGE/SQL utility command file can be created with a text editor or can be produced as part of the logging process. If you create or edit this file with an editor, it must be kept unnumbered. In the following examples, the file UPDATYPE contains the following commands:
Note that the commands in this command file assume the TurboIMAGE/XL database is already attached to the DBEnvironment. If you want to see commands and comments as the command file is executed, make sure the ECHO option is on. Performing the Task The XEQ command allows you to specify a file containing IMAGE/SQL utility commands as its parameter. To interactively execute commands listed in a command file, run the IMAGE/SQL utility by typing RUN IMAGESQL.PUB.SYS, then issue the XEQ command. Note that in this example ECHO is off.
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.
If an error occurs in batch mode, the job terminates. The remaining commands are flushed. Task Reference
|
|