NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
O-1
O
OBEY COMMAND
OBEY is an SQLCI command that executes SQL statements and SQLCI commands
from a file.
OBEY executes the statements and commands exactly as if you had entered them from
the terminal. After execution, SQLCI closes the file but does not return any setting
changed by the commands (such as a session attribute) to a previous state.
OBEY is often used to set DEFINEs or define reports, but is useful in any situation in
which you repeat a sequence of statements or commands. Using OBEY to execute
statements and commands from files makes tedious jobs faster, easier to reproduce, and
more reliable.
cmd-file
is the name of a closed file that contains commands to execute.
The file (called a command file or an OBEY command file) is usually an EDIT disk
file, but can also be a device or process. It cannot be the SQLCI IN, OUT, or log
file, or an executing command file, however, because these files are open.
section
is the name of a section in the file to execute.
For each section you specify, SQLCI executes the lines in the file from the
named section header to the next section header (or the end of the file). If you
specify more than one section, SQLCI executes the sections in the order in which
they appear in the file, not in the order you specify them. If more than one section in
the file has the name you specify, SQLCI executes only the first one; other sections
with the same name are ignored.
If you omit section, SQLCI executes all lines in the file.
Considerations—OBEY
•
Using parameters in command files
You can use named parameters as literals in DML statements or SQLCI commands
within command files. Use SET PARAM to supply values for the parameters before
you use OBEY to execute the statements or commands. (See Parameters
on
page P-12 for more information.)
•
Specifying sections in command files
O[BEY] cmd-file [ ( section [ , section ] ... ) ] ;