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

condition
is the same as the condition parameter defined for the “IF...THEN Command” (page 90). See
“Condition Parameter” (page 90).
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• After you disconnect from the Neoview platform, you can still run these NCI commands:
Table A-1 NCI Commands That Can Be Run Without a Connection
SET/SHOW SQLTERMINATORSAVEHISTHELPALIAS
SET/SHOW TIMESESSIONHISTORYCLEAR
SET/SHOW TIMINGSET/SHOW COLSEPLABELCONNECT
SHOW ALIAS/ALIASESSET/SHOW HISTOPTLOCALHOSTDELAY
SHOW MODESET/SHOW
IDLETIMEOUT
LOGDISCONNECT
SHOW SESSIONSET/SHOW MARKUPQUITENV
SPOOLSET/SHOW PARAMREPEATEXIT
VERSIONSET PROMPTRESET LASTERRORFC
SET/SHOW
SQLPROMPT
RESET PARAMGOTO
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 NCI session. You can also use the SESSION and SHOW
SESSION commands to perform the same function.
Syntax
ENV
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 109).
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 35).
DATASOURCE
Current history options, which controls how the commands are added to the
history buffer. For more information, see “SET HISTOPT Command” (page 111).
HISTOPT
ENV Command 81