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

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 58)
and “LOG Command” (page 93) or “SPOOL Command” (page 148).
LOG
Current look and feel of the NCI. This property affects the formatting of status
messages. For more information, see “Setting the Look and Feel of NCI” (page 25).
LOOK AND FEEL
Current markup option selected for the session. The default option is RAW. For
more information, see “SET MARKUP Command” (page 114).
MARKUP
Current operating mode of the session. The default mode is SQL. The prompt for
NS mode is NS%. For more information, see “MODE Command” (page 95).
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 47) and “SET PROMPT Command” (page 118).
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 49).
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 35).
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 48) and “SHOW
SQLTERMINATOR Command” (page 140).
SQLTERMINATOR
Current statistics for the session. For more information, see “SET STATISTICS
Command” (page 122).
STATISTICS
Current setting (on or off) of the local time as part of the prompt. By default, the
local time is off. For more information, see “Customizing the Standard Prompt”
(page 47) and “SET TIME Command” (page 123).
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 48) and “SET
TIMING Command” (page 124).
TIMING
User name that you entered when logging in to the database platform. For more
information, see “Logging In to the Database Platform” (page 35).
USER
Examples
• This command displays the attributes of the current session:
SQL>show session
COLSEP ","
DATASOURCE TDM_Default_DataSource
HISTOPT ALL
IDLETIMEOUT 30 min(s)
LIST COUNT 0 [All Rows]
LOG OFF
LOOK AND FEEL NVS
MARKUP XML
MODE SQL
PROMPT SQL>
ROLE DBA
SCHEMA USR
SERVER neo0101.acme.com:18650
SERVICE NAME HP_DEFAULT_SERVICE
SQLTERMINATOR ;
STATISTICS OFF
TIME OFF
SHOW SESSION Command 139