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

SQL ENTER>

For more information, see the “SET PROMPT command” (page 93).

SET TIME command

The set time on command causes the current time of the client workstation to appear in the

prompt:

SQL ENTER>set time on

20:32:26 SQL ENTER>

The set time off command removes the current time from the prompt:

20:32:26 SQL ENTER>set time off

SQL ENTER>

For more information, see the “SET TIME command” (page 97).

Setting and showing the SQL terminator

The SQL terminator symbolizes the end of an SQL statement. By default, the SQL terminator is a

semicolon (;).

To change the SQL terminator, run the set sqlterminator command. For example, the following

command sets the SQL terminator to a period (.):

SQL>set sqlterminator .

SQL>insert into sales.custlist

+> (select * from invent.supplier where suppnum=8) .

--- 1 row(s) inserted.

To show the SQL terminator which is in effect for the session, run the show sqlterminator

command. For example, the following command displays SQLTERMINATOR ., where the period

(.) is the SQL terminator for the session:

SQL>show sqlterminator

SQLTERMINATOR .

For more information, see the “SET SQLTERMINATOR command” (page 96) and the “SHOW

SQLTERMINATOR command” (page 111).

Displaying the elapsed time

By default, RMXCI does not display the elapsed time of an SQL statement after the statement is

run. To display the elapsed time after each SQL statement is run, run the following command:

SQL>set timing on

SQL>select suppname, street, city, state, postcode

+> from invent.supplier

+> where suppnum=3;

SUPPNAME STREET CITY STATE POSTCODE

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

HIGH DENSITY INC 7600 EMERSON NEW YORK NEW YORK 10230

--- 1 row(s) selected.

Elapsed :00:00:00.111

To prevent the elapsed time from being displayed after each SQL statement is run, run the set

timing off command:

SQL>set timing off

For more information, see the “SET TIMING command” (page 98).

36 Interactively running commands in RMXCI