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

SQL>session

COLSEP " "

DATASOURCE TDM_Default_DataSource

HISTOPT DEFAULT [No expansion of script files]

IDLETIMEOUT 0 min(s) [Never Expires]

LIST_COUNT 0 [All Rows]

LOG OFF

LOOK AND FEEL RMXCI

MARKUP RAW

PROMPT SQL>

CATALOG NONSTOP_SYSTEM_NSK

SCHEMA PUBLIC_ACCESS_SCHEMA

SERVER nsksys.ind.hp.com:18650

SQLTERMINATOR ;

STATISTICS OFF

TIME OFF

TIMING OFF

USER super.super

SQL>

For more information, see the “ENV command” (page 61) or “SHOW SESSION command”

(page 109).

Setting and showing the idletimeout value for the session

The idle timeout value of a session determines when the session expires after a period of inactivity.

To set the idle timeout value for a session, run the set idletimeout command. For example,

the following command sets the idle timeout to an infinite amount of time so that the session never

expires:

SQL>set idletimeout 0

To show the idle timeout value which is in effect for the session, run the show idletimeout

command. For example, this command displays an idle timeout of zero minutes, which means that

the session never expires:

SQL>show idletimeout

IDLETIMEOUT 0 min(s) [Never Expires]

For more information, see the “SET IDLETIMEOUT command” (page 87) and the “SHOW

IDLETIMEOUT command” (page 103).

Customizing the standard prompt

To change the standard prompt in the RMXCI interface, use one or both of these commands:

• “SET PROMPT command” (page 93)

• “SET TIME command” (page 36)

SET PROMPT command

The set prompt command changes the default prompt to a specified character or string. For

example, the following command changes the prompt to SQL ENTER>:

SQL>set prompt "SQL ENTER>"

Using RMXCI commands 35