Filter
Top Products
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.
*** ERROR[8822] The statement was not prepared.
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 90).
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.
Without text or number, FC retrieves the most recent command.
FC Command 87