Neoview Command Interface (NCI) Guide (R2.4)

Current setting (on or off) of the local time as part of the prompt. When this
command is set to on, military time is displayed. By default, the local time is off.
For more information, see “Customizing the Standard Prompt” (page 61) and
“SET TIME Command” (page 131).
TIME
Current setting (on or off) of the elapsed time. By default, the elapsed time is off.
For more information, see “Displaying the Elapsed Time” (page 62) and “SET
TIMING Command” (page 132).
TIMING
User name that you entered when logging in to the database platform. For more
information, see “Logging In to the Database Platform” (page 51).
USER
Examples
• This ENV 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 NCI
MARKUP RAW
MODE SQL
PROMPT SQL>
ROLE DBA
SCHEMA USR
SERVER neo0101.acme.com:18650
SERVICE NAME HP_DEFAULT_SERVICE
SQLTERMINATOR ;
STATISTICS OFF
TIME OFF
TIMING OFF
USER role.dba
• This ENV command shows the effect of setting various session attributes:
4:16:43 PM >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 c:\mydir\examples.log
LOOK AND FEEL NCI
MARKUP RAW
MODE SQL
PROMPT 4:16:49 PM >
ROLE DBA
SCHEMA PERSNL
SERVER neo0101.mylab.mycorp.net:18650
SERVICE NAME HP_DEFAULT_SERVICE
SQLTERMINATOR .
STATISTICS OFF
TIME ON
TIMING ON
USER dba1
4:16:49 PM >
ENV Command 95