Neoview Script Guide (R2.2)

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 47).
SERVER
Current SQL statement terminator. The default is a semicolon (;). For more
information, see “Setting and Showing the SQL Terminator” (page 58) and “SHOW
SQLTERMINATOR Command” (page 131).
SQLTERMINATOR
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 57) and
“SET TIME Command” (page 118).
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 58) and “SET
TIMING Command” (page 119).
TIMING
User name that you entered when logging in to the database platform. For more
information, see “Logging In to the Database Platform” (page 47).
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 NVS
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 NVS
MARKUP RAW
MODE SQL
PROMPT 4:16:49 PM >
SCHEMA PERSNL
SERVER neo0101.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.
90 Neoview Script Interface Commands