The DO command lets you execute any of the commands in the
command history buffer.
Scope
ISQL only.
ISQL Syntax
DO [ CommandNumber CommandString ]
Parameters
CommandNumber
identifies one of the commands in the command history buffer.
The command history buffer holds the fifty most recently submitted
commands, numbered 1 through 50. The CommandNumber of the
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.
If no parameter is specified, the most recently
submitted command is assumed.
DO cannot be used from a command file or the command buffer.
Example
isql=> LIST HISTORY @;
1 SELECT SalesPrice FROM PurchDB.Parts;
2 INFO PurchDB.Parts;
3 EDIT MyFile;
.
.
.
isql=> DO 2;The "INFO PurchDB.Parts" command is executed because it is the secondcommand in the command history buffer.
isql=> DO;
The "INFO PurchDB.Parts" command is executed again because it is the mostrecent command in the command history buffer.
isql=> DO ED;The "EDIT MyFile" command is executed because it is the most recent commandin the command history buffer that begins with the string "ED".