HPlogo ALLBASE/ISQL Reference Manual: HP 9000 Computer Systems > Chapter 4 ISQL Commands

LIST HISTORY

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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. If @ is the line-kill character on your system, you must precede the @ with the current HP-UX escape character.

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 '../sampledb/PartsDBE';

    5

    6

    7

    8

    9

   10



   isql=>
Feedback to webmaster