Neoview Command Interface (NCI) Guide (R2.4)

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 occurs and you are
prompted to reenter the directory. Note: Verify that this 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: PRUN puts the prun.err.log summary
file in the error subdirectory.
overwrite
If you specify (y), PRUN overwrites the contents of existing log files. By default, PRUN keep
the original information in the log files and appends new information at the end of each file.
connections
Enter a number for the maximum number of connections for the data sources. The data source
should support this number of connections.
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• You can execute this command only in SQL mode.
• If the PRUN command is executed without any arguments, NCI prompts for the PRUN
arguments. If one or more options are specified, the PRUN command runs without prompting
for more input. In the non-interactive mode, if any options are not specified then the default
value of is used.
• The -d option or -defaults cannot be specified with any other option.
• The PRUN log files also contain the log end time.
• Starting in release 2.3, the PRUN command displays the end time.
• PRUN does not support the SPOOL or LOG commands. These commands are ignored in
PRUN script files.
• The environment values from the main session (which are available through the SET
commands) are propagated to new sessions started via PRUN. However, prepared statements
and parameters are bound only to the main user session.
Example
• To use PRUN, enter the PRUN command in the NCI:
SQL>prun
Enter * as input to stop the current prun session
--------------------------------------------------
Enter the scripts directory : c:\ddl_scripts
Enter the script file extension[sql] :
Enter the logs directory[scripts dir] : c:\log
Overwrite the log files (y/n)[n]? : y
Enter the number of connections(2-248)[2]: 3
After you enter the number of connections, PRUN starts to process the script files and
displays this status:
Status: In Progress.......
After executing all the script files, PRUN returns a summary of the operation:
_____________________________________________
PARALLELRUN(PRUN) SUMMARY
_____________________________________________
Total files present ........................3
Total files processed ......................3
112 NCI Commands