Neoview Script Guide (R2.2)

Syntax
EXIT [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.
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>exit
• 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:
log c:\errorCode.log
select * from employee;
exit if errorcode=4082
log off
These results are logged when error code 4082 occurs:
SQL>select * from employee;
*** ERROR[4082] Table, view or stored procedure NEO.USR.EMPLOYEE
does not exist or is inaccessible.
SQL>exit if errorcode=4082
FC Command
The FC command allows you to edit and reissue a command in the history buffer of a Neoview
Script session. You can display the commands in the history buffer by using the HISTORY
command. For information about the history buffer, see the “HISTORY Command” (page 94).
Syntax
FC [text | [-]number]
text
is the beginning text of a command in the history buffer. Case is not significant in matching
the text to a command.
[-]number
is either a positive integer that is the ordinal number of a command in the history buffer or
a negative integer that indicates the position of a command relative to the most recent
command.
FC Command 91