SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)
in the @ or obey command. For more information, see the“@ command” (page 79) or the “OBEY
command” (page 96).
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 50).
For example, on Linux, 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) on Linux and rmxci.cmd file on Windows, 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 32).
SQL>@/home/usr/scripts/sch_invent.sql
SQL>-- CREATE SCHEMA
70 Running scripts in RMXCI










