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

Output of /usr/home/b.txt

====================

JOBCODE JOBDESC

------- ------------------

100 MANAGER

450 PROGRAMMER

900 SECRETARY

300 SALESREP

500 ACCOUNTANT

400 SYSTEM ANALYST

250 ASSEMBLER

420 ENGINEER

600 ADMINISTRATOR

200 PRODUCTION SUPV

--- 10 row(s) selected

The following command stops the logging process:

SQL>log off

For more information, see “Logging output” (page 45).

OBEY command

The obey command runs the SQL statements and RMXCI commands of a specified script file or

an entire directory. This command accepts a single filename or a filename with a wildcard pattern

specified. Executing the obey command without optional parameters prompts you to enter a

filename. If a filename is not specified, then *.sql is used.

Syntax

OBEY [script-file | wild-card pattern ] [ section-name ]

script-file

is the name of an ASCII text file that contains SQL statements, RMXCI commands, and comments.

If the script file exists outside the local directory where you launch RMXCI , specify the full

directory path of the script file.

(section-name)

is the name of a section within the script-file. If you specify section-name, the obey

command runs the commands between the header line for the specified section and the header

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 48).

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.

74 RMXCI commands