RECALL

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:

 



   [PathName/]FileName

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=>

RECALL

Technical documentation

» Table of Contents

» Index

Scope

ISQL Syntax

Parameters

Description

Example