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

Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• You cannot execute this command in a script file. You can execute this command only at a
command prompt.
• As each line of the command is displayed, you can modify the line by entering these editing
commands (in uppercase or lowercase letters) on the line below the displayed command
line:
Deletes the character immediately above the letter D. Repeat to delete
more characters.
D
Inserts characters in front of the character immediately above the letter
I.
Icharacters
Replaces existing characters one-for-one with characters, beginning with
the character immediately above the letter R.
Rcharacters
Replaces existing characters one-for-one with characters, beginning with
the first character immediately above characters. characters must
begin with a nonblank character.
characters
To specify more than one editing command on a line, separate the editing commands with
a double slash (//). The end of a line terminates an editing command or a set of editing
commands.
After you edit a line of the command, NCI displays the line again and allows you to edit it
again. Press Enter without specifying editing commands to stop editing the line. If that line
is the last line of the command, pressing Enter executes the command.
To terminate a command without saving changes to the command, use the double slash (//),
and then press Enter.
Examples
• Reexecute the most recent command that begins with SH:
SQL>fc sh
SQL>show schema
....
Pressing Enter executes the SHOW SCHEMA command and displays the current schema,
PERSNL:
SQL>fc sh
SQL>show schema
....
SCHEMA PERSNL
SQL>
• Correct an SQL statement that you entered incorrectly by using the delete (D) editing
command:
SQL>select * from persnl.employee;
*** ERROR[15001] A syntax error occurred at or before:
selecct * from persnl.employee;
^
SQL>fc
SQL>selecct * from persnl.employee;
.... d
SQL>select * from persnl.employee;
....
Pressing Enter executes the corrected SELECT statement.
• Correct an SQL statement that you entered incorrectly by using more than one editing
command:
FC Command 85