MX Release 3.2 (H06.25+, J06.14+)

Examples

• The following command displays the attributes of the current session:

SQL>env

COLSEP " "

DATASOURCE TDM_Default_DataSource

HISTOPT DEFAULT [No expansion of script files]

IDLETIMEOUT 30 min(s)

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>

• The following env command shows the effect of setting various session attributes:

SQL>env

COLSEP " "

DATASOURCE TDM_Default_DataSource

HISTOPT DEFAULT [No expansion of script files]

IDLETIMEOUT 0 min(s) [Never Expires]

LIST_COUNT 0 [All Rows]

LOG /usr/home/examples.log

LOOK AND FEEL RMXCI

MARKUP RAW

PROMPT 4:16:49 PM >

CATALOG NONSTOP_SYSTEM_NSK

SCHEMA PERSNL

SERVER nsksys.ind.hp.com:18650

SQLTERMINATOR ;

STATISTICS OFF

TIME ON

TIMING ON

USER super.super

4:16:49 PM >

ENV command 85