 |
» |
|
|
|
The RECALL command displays the current contents of
the command buffer (up to 32K bytes). Optionally, it places a
command from the command history buffer or the contents of a
file into the command buffer and displays it.
Scope | |
ISQL only. ISQL Syntax | |
REC[ALL] {
C[URRENT]
F[ILE]FileName
H[ISTORY]CommandNumber
} Parameters | |
- CURRENT
displays the current contents of the command
buffer (including comments). The following commands place information into the
command buffer:
HOLD
RECALL FILE
RECALL HISTORY
|
- FILE FileName
puts the contents of a file into the command buffer and displays
it (including comments).
File name qualification follows HP-UX conventions:
Unless you specify an absolute path name, ISQL assumes that any
path name you specify is relative to your current working
directory.
- HISTORY CommandNumber
puts one of the commands currently in the command history buffer
into the command buffer and displays it. The command history
buffer holds the ten most recently submitted commands, numbered
1 through 10. The CommandNumber of the most recently
submitted command is 1. You can use the LIST HISTORY @ command
to identify the CommandNumber associated with each command
currently in the command history buffer.
Description
| |
All options of the RECALL command concatenate command lines. For
example:
isql=> RECALL FILE FileName;
UPDATE STATISTICS FOR TABLE PurchDB.OrderItems; ...; UP
DATE STATISTICS FOR TABLE PurchDB.Inventory;
isql=>
|
If RECALL HISTORY 1 is invoked right after a multiple-command
command file is executed, the command displayed is the last SQL
or ISQL command processed, not all the commands in the command
file.
When commands are in the command buffer, you can operate on them
with the following ISQL commands:
CHANGE
RECALL CURRENT
START
STORE
In prompting mode, ISQL prompts you for RECALL options as follows:
isql=> RECALL;
Recall option (c[urrent], f[ile], or h[istory])> HISTORY;
Command number> 1;
COMMIT WORK;
isql=>
|
Up to 32K bytes of a command file are stored in the command
buffer and displayed.
Example | |
isql=> HOLD SELECT * FROM
> PurchDB.Orders;
isql=> RECALL CURRENT;
SELECT * FROM PurchDB.Orders;
isql=> SET ECHO OFF;
isql=> START Daily;
isql=> RECALL HISTORY 1;
UPDATE STATISTICS FOR TABLE PurchDB.Orders;
isql=>
|
|
