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

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
You must enter the command on one line. The command does not require an SQL terminator.
Examples
• This command disconnects from and exits the NCI, 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 NCI 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 an NCI
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 102).
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.
98 NCI Commands