HP 3000 Manuals

Information Access Server: Database Administration

Command File Execution 

Once a command file has been properly prepared, it can be run on the host
as a job through the MPE "stream" facility or it can be run directly from
within the Host Batch Facility.

Running the Job Through MPE or HDPBATCH 

When running the command file directly on the HP 3000, certain MPE
commands are required to process the file correctly.  You distinguish MPE
commands from other Access PC commands by prefacing them with a colon
(:).  A :RUN command is needed at the beginning of the file to start the
Host Batch Facility.  An :EOJ is needed at the end of the file to
terminate the job.  Here is an example:

:JOB user.acct,group     -- job command
:RUN HDPBATCH.PPC.SYS    -- start Host Batch Facility
SQL "SELECT * FROM &     -- specify name and password
SCHEDULE &               -- select table
WHERE COST > 200;"       -- define query
OUTPUT_TAB sam ASCII     -- specify output
EXIT                     -- exit Host Batch Facility
:EOJ                     -- end MPE job stream

If you want the job to run at some pre-specified time, use the "job
schedule" feature provided in the :STREAM command.

You can also execute a command file from within HDPBATCH using the XEQ
command described earlier, or you can execute a command file
automatically by specifying an XEQ command in the INFO string of the RUN
command.  For example:

         :RUN HDPBATCH.PPC.SYS;INFO="XEQ CMDFILE"

MPE/iX 5.0 Documentation