Filter
Top Products
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 54) and “SET
TIMING Command” (page 113).
TIMING
User name that you entered when logging in to the database platform. For more
information, see “Logging In to the Database Platform” (page 45).
USER
Examples
• This ENV command displays the attributes of the current session:
SQL>env
COLSEP " "
DATASOURCE TDM_Default_DataSource
HISTOPT ALL
IDLETIMEOUT 30 min(s)
LIST COUNT 0 [All Rows]
LOG OFF
LOOK AND FEEL BTEQ
MARKUP RAW
MODE SQL
PROMPT SQL>
SCHEMA USR
SERVER neo0101.acme.com:18650
SQLTERMINATOR ;
TIME OFF
TIMING OFF
USER role.dbaSQL>
• This ENV command shows the effect of setting various session attributes:
4:16:43 PM >env
COLSEP " "
DATASOURCE TDM_Default_DataSource
HISTOPT ALL
IDLETIMEOUT 0 min(s) [Never Expires]
LIST COUNT 0 [All Rows]
LOG c:\mydir\examples.log
LOOK AND FEEL BTEQ
MARKUP RAW
MODE SQL
PROMPT 4:16:49 PM >
SCHEMA PERSNL
SERVER sys0101.mylab.mycorp.net:18650
SQLTERMINATOR .
TIME ON
TIMING ON
USER dba1
4:16:49 PM >
EXIT Command
The EXIT command disconnects from and exits the Neoview Script interface.
Syntax
EXIT [IF ERRORCODE{=|<|>|<=|>=|<>}error-code]
86 Neoview Script Interface Commands