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

Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• ENV displays these attributes:
Current column separator, which is used to control how query results are displayed.
For more information, see “SET COLSEP Command” (page 117).
COLSEP
Name of the data source that you entered when logging in to the database platform.
For more information, see “Logging In to the Database Platform” (page 53).
DATASOURCE
Current history options, which controls how the commands are added to the
history buffer. For more information, see “SET HISTOPT Command” (page 118).
HISTOPT
Current idle timeout value, which determines when the session expires after a
period of inactivity. By default, the idle timeout is 30 minutes. For more
information, see “Setting and Showing the Idle Timeout Value for the Session”
(page 63) and “SET IDLETIMEOUT Command” (page 119).
IDLETIMEOUT
Current list count, which is the maximum number of rows that can be returned
by SELECT statements. By default, the list count is all rows. For more information,
see “SET LIST_COUNT Command” (page 120).
LIST_COUNT
Current log file and the directory containing the log file. By default, logging during
a session is turned off. For more information, see “Logging Output” (page 73)
and “LOG Command” (page 104) or “SPOOL Command” (page 151).
LOG
Current look and feel of NCI. This property affects the formatting of status
messages. For more information, see “Setting the Look and Feel of NCI” (page 42).
LOOK AND FEEL
Current markup option selected for the session. The default option is RAW. For
more information, see “SET MARKUP Command” (page 121).
MARKUP
Current operating mode of the session. The default mode is SQL. For more
information, see “MODE Command” (page 106).
MODE
Current prompt for the session. In SQL mode, the default is SQL>. In CS mode,
the default is CS#. For more information, see “Customizing the Standard Prompt”
(page 63) and “SET PROMPT Command” (page 125).
PROMPT
Current role for the session. For more information about user-ids and roles, see
the Neoview Database Administrator's Guide.
ROLE
Current schema. The default is USR. For more information, see “Setting and
Showing the Current Schema” (page 65).
SCHEMA
Host name and port number that you entered when logging in to the database
platform. For more information, see “Logging In to the Database Platform”
(page 53).
SERVER
Current service name for the session.SERVICE NAME
Current SQL statement terminator. The default is a semicolon (;). For more
information, see “Setting and Showing the SQL Terminator” (page 64) and “SHOW
SQLTERMINATOR Command” (page 144).
SQLTERMINATOR
Current setting (on or off) of statistics. For more information about statistics, see
the Neoview Database Administrator's Guide.
STATISTICS
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 63) and
“SET TIME Command” (page 130).
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 64) and “SET
TIMING Command” (page 131).
TIMING
User name that you entered when logging in to the database platform. For more
information, see “Logging In to the Database Platform” (page 53).
USER
96 NCI Commands