MX Release 3.1 (H06.23+, J06.12+)

Welcome to the NonStop(TM) SQL/MX Remote Conversational Interface

Connected to DataSource: TDM_Default_DataSource

SQL>

Running a command when launching RMXCI

To run an SQL statement or an RMXCI command when launching the SQL/MX Remote

Conversational Interface, use the -q or -sql command line parameter. This parameter enables

you to run a single command on the command-line without having to enter commands in RMXCI.

NOTE: You cannot specify this parameter at the same time as the -s or -script parameter.

When using -q or -sql, you must enclose the command in double quotes. The SQL terminator is

not required at the end of an SQL statement and is not allowed after an RMXCI command.

Although you can run any of the RMXCI commands with -q or -sql, the @, obey, and prun

commands are the most useful. For a list of supported SQL statements, see Appendix B (page 119).

Example of running an SQL statement with -q or -sql

When launching RMXCI, use -q or -sql with the create schema statement to create a schema:

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.

The following command creates the schema persnl in the default catalog NONSTOP_SYSTEM_NSK:

/home/usr/rmxci/bin:./rmxci.sh -q "create schema persnl"

After you enter the SQL statement, RMXCI launches and prompts you to log in by default (if you

did not specify -h, -u, -p, and -dsn on the command line), runs the SQL statement, and then

returns to the command prompt, as shown:

28 Launching RMXCI