MX Release 3.1 (H06.23+, J06.12+)

SQL>set catalog CAT1;

-- SQL operation complete.

SQL>set schema invent;

--- SQL operation complete.

SQL>show schema

SCHEMA INVENT

SQL>show views

VIEW NAMES

----------------------------------------------------------------

VIEW207 VIEW207N VIEWCS VIEWCUST

For more information, see the “SHOW VIEWS command” (page 114).

Displaying run commands

To display commands that were recently run in the RMXCI session, run the history command.

The history command associates each command with a number, which you can use to rerun or

edit with the fc command. For more information, see “Editing and rerun a command” (page 39).

For example, the following command displays three commands that were entered in the session:

SQL>history

1> set idletimeout 0

2> set schema persnl;

3> select * from project;

To save the session history in a user-specified file, run the savehist command. For example, this

command saves the session history in a file named history.txt in the local directory where

you are running RMXCI:

SQL>savehist history.txt

For more information, see the “HISTORY command” (page 68) and the “SAVEHIST command”

(page 83).

Editing and rerun a command

To edit and rerun a command in the history buffer of an RMXCI session, run the fc command. For

more information, see “Displaying run commands” (page 39).

For example, the following fc command and the d (delete editing) command correct a SELECT

statement that was entered incorrectly:

SQL>fc

SQL>selecct * from employee;

..... d

SQL>select * from employee;

Pressing Enter runs the corrected SELECT statement.

For more information, see the “FC command” (page 64).

Clearing the interface window

After running commands in RMXCI, you can clear the interface window by using the clear

command. For example, the following command clears the interface window so that only the

prompt appears at the top of the window:

SQL>clear

For more information, see the “CLEAR command” (page 59).

Using RMXCI commands 39