MX Release 3.2 (H06.25+, J06.14+)

--- 1 row(s) inserted.

The following command runs all files with .sql extension:

SQL>obey /usr/home/rmxci/*.sql;

SQL> obey /usr/home/rmxci

The following command runs all files beginning with the word script and contains one

character after the word script and ends with .sql extension. For example:

script1.sql,script2.sql,scriptZ.sql and so on:

SQL>obey /usr/home/rmxci/script?.sql

The following command runs all files that contain the word test. This includes the files that

do not end with .sql extension.

SQL>obey /usr/home/rmxci/*test*

This command runs all files that begin with the word script and contains one character after

the word script and ends with an extension prefixed by a dot. For example: script1.sql,

script2.bat, scriptZ.txt and so on.

SQL>obey /usr/home/rmxci/script?.*

The following command runs all files that have .txt extension in the current directory:

SQL>obey *.txt;

The following command prompts the user to enter the script filename or a pattern. The default

value is *.sql.

SQL>obey;

Enter the script filename [*.sql]:

PRUN command

The prun command runs script files in parallel.

Syntax

PRUN [-d | -defaults] | PRUN [-sd | -scriptsdir directoryName]

[-e | -extension extension]

[-ld | -logsdir logDirectory]

[-o | -overwrite {y | n}]

[-c | -connections num]

scriptsdir

In this directory, prun processes every file with the specified extension. If you do not specify

a directory or if you specify an invalid directory, an error message is returned and you are

prompted to re-enter the directory.

NOTE: Verify that the specified directory contains valid script files.

extension

The default is .sql.

logsdir

In this directory, prun creates a log file for each script file by appending the .log extension

to the name of the script file. If you do not specify a log file directory, prun places the log files

in the same directory as the script files.

NOTE: The prun command puts the prun.err.log summary file in the error subdirectory.

overwrite

If you specify (y), prun command overwrites the contents of existing log files. By default, prun

command keeps the original information in the log files and appends new information at the

end of each file.

PRUN command 99