HP 3000 Manuals HP 3000 Manuals
XEQ
Executes DBChange commands from a file instead of the terminal or batch
files.
Syntax
X[EQ] FileName
Parameters
FileName is the name of an ASCII file containing commands and
parameters.
Description
Use this command to execute DBChange commands from a file instead of the
standard input device. All commands that are accepted by DBChange Plus
are allowed in an XEQ file. To create an XEQ file, use a text editor.
When an XEQ command is entered, DBChange reads the specified file and
executes the commands until it reaches the end-of-file. The command file
must contain all data needed. When the end-of-file is reached, control
returns to the original command input device (in session mode, the
terminal; or in batch mode, the batch file).
In session mode, during the execution of an XEQ file, the DBCPLUS program
displays the contents of the file and any messages on the screen. You
are prompted if any changes in the file may have unexpected results or
may cause loss of data. If an error occurs when the database is being
opened, the DBCPLUS program closes the XEQ file and prompts for another
command. If an error occurs when executing a DBChange Plus command,
error messages are displayed on the screen. You can then correct the XEQ
file and enter the XEQ command again. If the XEQ file contains a PERFORM
COMMANDS command, you are prompted for confirmation before the database
is restructured.
In batch mode, during the execution of an XEQ file, if an error occurs
when the database is being opened, DBChange closes the XEQ file and
terminates the job. If an error occurs while executing a DBChange
command, the error message is sent to DBCOUT, and XEQ continues
processing subsequent commands.
Example
>xeq xeqfile
><<This command file creates a new change file for the ORDERS database >>
><< and stores the addition of the data item REGION in the change file >>
>
>base orders <---- DBChange command
>delete item date <---- DBChange command
Deleting this data item will cause loss of data, delete [y/N]? y
Deletion of data item accepted.
>add item region j 2 (11,12/14) <---- DBChange command
Addition of data item accepted.
>
> XEQ file is at end-of-file.
>
This example interactively executes the file XEQFILE. Note that, because
the deletion of the data item DATE will cause loss of data, DBChange
prompts for confirmation.