Product Documentation

FairCom ISQL

Previous Topic

Next Topic

Statement History Support

c-treeSQL ISQL provides statements to simplify the process of executing statements you have already typed. ISQL implements a history mechanism similar to the one found in the csh (C-shell) supported by UNIX.

The following table summarizes the ISQL statements that support retrieving, modifying, and rerunning previously entered statements.

Statement

Summary

HISTORY

Displays a fixed number of statements (specified by the SET HISTORY statement) which have been entered before this statement, along with a statement number for each statement. Other statements take the statement number as an argument. See "HISTORY" for details.

RUN [ stmt_num ]

Displays and executes the current statement or specified statement in the history buffer. See "RUN" details.

LIST [ stmt_num ]

Displays the current statement or specified statement in the history buffer, and makes that statement the current statement by copying it to the end of the history list. See "LIST" for details.

EDIT [ stmt_num ]

Edits the current statement or specified statement in the history buffer, and makes the edited statement the current statement by copying it to the end of the history list. The environment variable EDITOR can be set to the editor of choice. See "EDIT" for details.

SAVE filename

Saves the current statement in the history buffer to the specified file, which can then be retrieved through the GET or START statements. See "SAVE" for details.

GET filename

Fetches the contents of the specified file, from the beginning of the file to the first semicolon, and appends it to the history buffer. The statement fetched by the GET can then be executed by using the RUN statement. See "GET" for details.

START filename [ argument ... ]

Fetches and executes a statement stored in the specified file. Unlike the GET statement, START executes the statement and accepts arguments that it substitutes for parameter references in the statement stored in the file. START also appends the statement to the history buffer. See "START" for details.

TOCIndex