Neoview Script Guide (R2.2)

Considerations
In the Neoview Script interface, you must enter the command on one line.
Examples
This command terminates the connection to the Neoview platform. You can connect to the
Neoview platform by using the CONNECT and RECONNECT commands:
SQL>disconnect
Session Disconnected. Please connect to the database by using connect/reconnect command.
ENV Command
ENV displays attributes of the current Neoview Script session. You can also use the SESSION
and SHOW SESSION commands to perform the same function.
Syntax
ENV
Considerations
• In the Neoview Script interface, 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 107).
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 47).
DATASOURCE
Current history options, which controls how the commands are added to the
history buffer. For more information, see “SET HISTOPT Command” (page 108).
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 57) and “SET IDLETIMEOUT Command” (page 109).
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 110).
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 68)
and “LOG Command” (page 96) or “SPOOL Command” (page 137).
LOG
Current look and feel of the Neoview Script interface. This property affects the
formatting of status messages. For more information, see “Setting the Look and
Feel of the Neoview Script Interface” (page 35).
LOOK AND FEEL
Current markup option selected for the session. The default option is RAW. For
more information, see “SET MARKUP Command” (page 111).
MARKUP
Current operating mode of the session. The default mode is SQL. For more
information, see “MODE Command” (page 97).
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 57) and “SET PROMPT Command” (page 114).
PROMPT
Current schema. The default is USR. For more information, see “Setting and
Showing the Current Schema” (page 59).
SCHEMA
ENV Command 89