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

in the @ or obey command. For more information, see the“@ command” (page 57) or the “OBEY

command” (page 74).

Example of a script file

This script file creates tables in the inventory schema.

Running a script file

To run a script file in RMXCI, use the @ or obey command. These commands run one script file at

a time in the SQL/MX Remote Conversational Interface. To run a script file when launching RMXCI,

see “Running a script file when launching RMXCI” (page 29).

For example, this command runs a script file, sch_invent.sql, that creates tables in the inventory

schema:

/home/usr/scripts/sch_invent.sql

NOTE: If the script file is outside the directory for rmxci.sh file (by default, the RMXCI bin

directory), you must specify the full path of the script file in the command. For the install files in

RMXCI bin directory, see Table 2 (page 17).

SQL>@/home/usr/scripts/sch_invent.sql

SQL>-- CREATE SCHEMA

Running a script file 49