SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

H-5

HISTORY Command

HISTORY is an SQLCI command that displays the commands or statements most

recently entered during the SQLCI session. HISTORY identifies each command by a

number that you can use with the FC command to reexecute or edit the command.

(HISTORY is similar to the TACL command HISTORY.)

The default is 10.

number

is the number of commands to display.

The history buffer contains at the most 25 commands. You can use the FC

command to edit and reexecute a command in the history buffer, or use the

exclamation point command (!) to reexecute a command without modifying it.

Example—HISTORY

This command displays the last five commands or statements entered during the

SQLCI session:

>> HISTORY 5;

4> SHOW PREPARED *;

5> VOLUME PERSNL;

6> ENV;

7> LOG;

8> HISTORY 5;

Host Identifiers

Host identifiers are names used in host language programs to identify data items,

structures, functions, or labels declared in the programs.

In an SQL statement or directive, a host identifier is always preceded by a colon (:), but

other rules for host identifiers depend on the programming language. For information

about the rules for host identifiers in a specific language, see the SQL/MP

programming manual for the host language you use.

HISTORY [ number ] ;