SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

line for the next section (or the end of the script file). If you omit section-name, the obey
command runs the entire script file. For more information, see “Section headers” (page 69).
wild-card-pattern
is a character string used to search for and display groups with names that match the character
string. wild-card-pattern matches a string (depends on the OS for case-sensitivity) unless
you enclose it within double quotes. To look for similar values, specify only part of the characters
of wild-card-pattern combined with these wild-card characters:
Use an asterisk (*) to indicate zero or more characters
of any type. For example, *art* matches SMART,
ARTIFICIAL, and PARTICULAR.
*
Use a question mark (?) to indicate any single character.
For example, boo? matches BOOK and BOOT but not
BOO or BOOTS.
?
Considerations
• You must enter the command in one line.
• Put a space between obey and the first character of the filename.
• You can run this command in a script file.
• Before putting dependent SQL statements across multiple files, consider the order of the file
execution. If a directory is not passed to the obey command, the file or wildcard is assumed
to be in the current directory.
• If the (*) is issued in the obey command, all files are run in the current directory. Some of
the files in the directory might be binary files. The obey command tries to read those binary
files and junk or invalid characters are displayed on the console. For example, the following
command causes invalid characters to be displayed on the console:
SQL> obey /usr/home/rmxci/bin/*
• The command detects recursive obey files (for example, a sql file that obeys itself) and prevents
infinite loops using a maximum depth environment variable. If no variable is passed to the
JVM, the default depth is set to 10. To change this depth (for example, to a value of 20), set
the java environment variable as follows:
-Drmxci.obeydepth=20
Examples
• The following command runs the script file from the local directory :
SQL>obey ddl.sql
• The following command runs the script file in the specified directory on a Linux client
workstation:
SQL>obey ./my_files/ddl.sql
The following command runs the script file in the specified directory on a Windows client
workstation:
SQL>obey C:\my_files\ddl.sql
• The following sample file contains sections to be used in conjunction with the obey command:
?section droptable
DROP TABLE COURSE
?section create
CREATE TABLE COURSE
(
CNO VARCHAR(3) NOT NULL,
OBEY command 97