Neoview Script Guide (R2.2)

PRUN options are -scriptsdir c:/_nvs/prun
-logsdir c:/_nvs/prun/logs
-extension sql
-overwrite y
-connections 5
Status: Complete
_____________________________________________
PARALLELRUN(PRUN)SUMMARY
_____________________________________________
Total files present ......................99
Total files processed ....................99
Total sqls processed ....................198
Total errors ..............................0
Total warnings ............................0
Total warnings ............................0
Total connections .........................5
Total connection failures..................0
You can execute this command only in SQL mode.
• PRUN can be started in non-interactive mode using the –q parameter, thus requiring no
input:
hpnvs.cmd -h neo0101.caclab.cac.cpqcorp.net -dsn
TDM_Default_DataSource -u super.services -p host1
-q "prun –sd c:/_nvs/prun -o y -c 3"
• PRUN can be started in non-interactive mode from an obey file:
SQL>obey startPrun.txt
SQL>prun -sd c:/_nvs/prun -ld c:/_nvs/prun/logs -e sql -o y -c 5
PRUN options are -scriptsdir c:/_nvs/prun
-logsdir c:/_nvs/prun/logs
-extension sql
-overwrite yes
-connections 5
Status: Complete
For a summary of all errors and warnings that occurred during the PRUN operation, go to the
error subdirectory in the same directory as the log files (for example, C:\log\error) and
open the prun.err.log summary file.
For details about the errors that occurred during the execution of a script file, open each individual
log file (<script-file.sql>.log)
QUIT Command
The QUIT command disconnects from and exits the Neoview Script interface.
Syntax
QUIT [IF ERRORCODE{=|<|>|<=|>=|<>}error-code]
error-code
is an integer that represents an error condition of the previously executed command. If the
previously executed command returns this error code, the Neoview Script interface disconnects
and exits.
Commands that execute successfully in the Neoview Script interface have an error code of
zero (0). Interface commands that do not perform SQL operations and that fail to execute
have an error code of -1. A failed SQL operation has a specific SQL error code associated with
the error condition. For more information about SQL error messages, see the Neoview Messages
Manual.
102 Neoview Script Interface Commands