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

LIST HISTORY

Technical documentation

» Table of Contents

» Index

Scope

ISQL Syntax

Parameters

Description

Example