HP 3000 Manuals

ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL

LIST HISTORY 

The LIST HISTORY command displays one or all commands in the command
history buffer.

Scope 

ISQL only.

ISQL Syntax 

LI[ST] H[ISTORY] {CommandNumber}
                 {@            }
Parameters 

CommandNumber           is a number in the range 1 through 50, where 1
                        identifies the most recently submitted ISQL or
                        SQL command in the ISQL session.

@                       refers to the entire command history buffer.

Description 

   *   Display of commands longer than 65 bytes is truncated, and an
       ellipsis is inserted at the end of the line to indicate
       truncation.

   *   In prompting mode, ISQL prompts you for an option as follows:

            isql=> LIST; 

            Option (s[et], f[ile], i[nstall], or h[istory])> HISTORY; 
            Command number or @> @ 

Example 

     isql=> LIST HISTORY @; 

      1     SELECT * FROM PurchDB.Parts;
      2     SELECT * FROM PurchDB.Vendors;
      3     SELECT * FROM PurchDB.PartInfo;
      4     CONNECT TO 'PartsDBE.SomeGrp.SomeAcct';
      5
      6
      7
      8
      9
     10

     isql=>

MPE/iX 5.0 Documentation