SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)

Host Name/IP Address: nsksys.ind.hp.com:18650
User Name: super.super
Password:
DataSource Name [TDM_Default_DataSource]:
--- SQL operation complete.
Example of running an RMXCI command with -q or -sql
To run multiple script files simultaneously from the command line, use -q or -sql options with the
prun command.
From the client terminal window, run the following command:
/home:cd rmxci-installation-directory/rmxci/bin
where:
rmxci-installation-directory is the location where you have installed the RMXCI software
files, for example: /home/usr/rmxci.
/home/usr/rmxci/bin:./rmxci.sh -q "prun"
After you enter the RMXCI command, the SQL/MX Remote Conversational interface launches and
prompts you to log in by default (if you did not specify -h, -u, -p, and -dsn on the command
line), and runs the command. The parallel run operation prompts you to enter the settings and then
runs script files. At the end of the PRUN operation, RMXCI returns to the command prompt. For
more information about the PRUN operation, see “PRUN command” (page 77).
Running a script file when launching RMXCI
To run a script file when launching RMXCI, use the -s or -script command-line parameter.
NOTE: You cannot specify this parameter at the same time as the -q or -sql parameter.
After you launch RMXCI with -s or -script, RMXCI runs the script file in an interactive mode.
RMXCI remains open until you run an exit, quit, or disconnect command. To quit the interface
immediately after executing a script file, include the exit, quit, or disconnect command at
the end of the script file.
Example of a script file
You can create a script file that contains set commands, which customizes a session when you
launch RMXCI as shown:
For more information, see “Creating a script file” (page 48).
Example of running a script file with -s or -script
From the client terminal window, run these commands:
/home:cd rmxci-installation-directory/rmxci/bin
where:
Logging in to the database platform 29