HP 3000 Manuals

ALLBASE/ISQL Reference Manual

RECALL 

The RECALL command displays the current contents of[REV BEG] the command
buffer (up to 32K bytes).  Optionally, it places a[REV END] command from
the command history buffer or the contents of a file into the command
buffer and displays it.

Scope 

ISQL only.

ISQL Syntax 

         {C[URRENT]              }
REC[ALL] {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 MPE XL
                        conventions:

                             FileName[/Lockword][.Group[.Account]]

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=>
       [REV BEG]

   *   Up to 32K bytes of a command file are stored in the command buffer
       and displayed.[REV END]

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

MPE/iX 5.0 Documentation