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 arc0101.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-codeis 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.

Considerations

In the Neoview Script interface, you must enter the command on one line. The command does not require an SQL terminator.

Examples

•This command disconnects from and exits the Neoview Script interface, which disappears from the screen:

SQL>quit

•In a script file, the conditional exit command causes the script file to quit running and disconnect from and exit the Neoview Script interface when the previously run command returns error code 4082:

QUIT Command 97