Considerations

•In the Neoview Script interface, 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:

D

Deletes the character immediately above the letter D.

 

Repeat to delete more characters.

 

 

Icharacters

Inserts characters in front of the character immediately

 

above the letter I.

 

 

Rcharacters

Replaces existing characters one-for-one with characters,

 

beginning with the character immediately above the

 

letter R.

 

 

characters

Replaces existing characters one-for-one with characters,

 

beginning with the first character immediately above

 

characters. characters must begin with a nonblank

 

character.

 

 

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, Neoview Script 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>selecct * from persnl.employee;

***ERROR[15001] A syntax error occurred at or before: selecct * from persnl.employee;

^

***ERROR[8822] The statement was not prepared.

SQL>fc

SQL>selecct * from persnl.employee;

.... d

88 Neoview Script Interface Commands