HP 3000 Manuals HP 3000 Manuals
REDO
The REDO command lets you edit any of the commands in the command history
buffer and optionally execute the edited command. The original command
in the command history buffer is left unchanged.
Scope
ISQL only.
ISQL Syntax
[REV BEG]RED[O] [CommandNumber] [REV END]
[CommandString]
Parameters
CommandNumber identifies one of the commands in the command
history buffer. The command history buffer holds
the fifty most recently submitted[REV BEG]
commands, numbered 1 through 50. The
CommandNumber of the[REV END] most recently
submitted command is 1.
CommandString identifies the most recent command in the
command history buffer that begins with the
CommandString.
Description
* You can use the LIST HISTORY @ command to identify the
CommandNumber associated with each command currently in the
command history buffer.[REV BEG]
* If no parameter is specified, the most recently submitted command
is assumed.[REV END]
* REDO cannot be used from a command file or the command buffer.
* Once the REDO command is submitted, you are placed in edit mode,
and the first line of the command is displayed. You enter the
following editing subcommands on the line beneath the displayed
line, referred to as the current edit line. You can use either
uppercase or lowercase for the alphabetic subcommands listed here:
B breaks the line being edited by moving the
character above the B and all subsequent
characters on the line to the next line,
which becomes the current edit line.
D deletes the character above the D. You can
delete multiple characters by entering the
D below the first and the last character
to be deleted, leaving blanks between
them. You can delete, then insert,
characters by using one or more Ds
followed by an I.
E exits the REDO command without executing
the edited command.
H lists all the valid editing subcommands,
then redisplays your current edit line.
I inserts one or more characters starting at
the location of the I. You can delete,
then insert, characters by using one or
more Ds followed by an I.
L lists the complete command as it is
currently edited, then redisplays the
current edit line.
R replaces one or more characters in the
line being edited. Characters are
replaced beginning with the character
above the R one for one with any
characters you enter following the R. The
R can be omitted unless one of the other
edit subcommands is the first replacement
character.
X executes the edited version of the
command.
+[n] makes the nth line forward in the command
being edited available for editing; n is 1
by default. If you enter a number greater
than the number of lines remaining in the
command, the last line in the command is
made available for editing.
-[n] makes the nth line back in the command
being edited available for editing; n is 1
by default. If you enter a number greater
than the number of lines earlier in the
command, the first line in the command is
made available for editing.
Return makes the next line of the command being
edited available for editing. If the
current edit line is the last line, the
edited command is executed.
* Any characters other than those listed above are interpreted as
replacement characters; they replace the characters above them in
the current edit line.
* Use the space bar, not the arrow keys to move forward on the line
to be edited.
* The edit line cannot exceed 72 characters. If inserting
additional characters will cause the line to exceed 72 characters,
use the B subcommand to break the line before inserting.
Example
isql=> SELECT PartName, SalesPrice
> FROM PurchDB.Prts
> WHERE PartName IS NUL;
SELECT PartName, SalesPrice FROM PurchDB.Prts WHERE PartName IS NUL;
|
Syntax error. (DBERR 1001)
isql=> REDO;
SELECT PartName, SalesPrice FROM PurchDB.Prts WHERE PartName IS NUL;
B
SalesPrice FROM PurchDB.Prts WHERE PartName IS NUL;
-1
SELECT PartName,
IPartNumber,
SELECT PartName, PartNumber,
+
SalesPrice FROM PurchDB.Prts WHERE PartName IS NUL;
a
SalesPrice FROM PurchDB.Pats WHERE PartName IS NUL;
H
Valid commands are: B, D, E, H, I, L, R, X, +n, -n
SalesPrice FROM PurchDB.Pats WHERE PartName IS NUL;
ir
SalesPrice FROM PurchDB.Parts WHERE PartName IS NUL;
RL;
SalesPrice FROM PurchDB.Parts WHERE PartName IS NULL;
L
1. SELECT PartName, PartNumber,
2. SalesPrice FROM PurchDB.Parts WHERE PartName IS NULL;
SalesPrice FROM PurchDB.Parts WHERE PartName IS NULL;
Return
Edited command is executed.
isql=>
[REV BEG]
isql=> REDO SEL;
The most recent command in the command buffer beginning with the string
"SEL" is displayed in edit mode.
SELECT PartName, PartNumber, SalesPrice FROM PurchDB.Parts WHERE
PartName IS NULL;
Return
The command is executed.[REV END]