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

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 >
EXIT Command
The EXIT command disconnects from and exits NCI.
Syntax
EXIT [IF ERRORCODE{=|<|>|<=|>=|<>}error-code]
error-code
is an integer that represents an error condition of the previously executed command. If the
previously executed command returns this error code, NCI disconnects and exits.
Commands that execute successfully in NCI have an error code of zero (0). Interface commands
that do not perform SQL operations and that fail to execute have an error code of -1. A failed
EXIT Command 97