Filter
Top Products
SHOW SESSION Command
SHOW SESSION or SESSION displays attributes of the current Neoview Script session. You can
also use the ENV command to perform the same function.
Syntax
[SHOW] SESSION
Considerations
• In the Neoview Script interface, you must enter the command on one line. The command
does not require an SQL terminator.
• SHOW SESSION or SESSION displays these attributes:
Current column separator, which is used to control how query results are
presented. For more information, see “SET COLSEP Command” (page 101).
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 45).
DATASOURCE
Current history options, which controls how the commands are added to the
history buffer. For more information, see “SET HISTOPT Command” (page 102).
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 53) and “SET IDLETIMEOUT Command” (page 103).
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 106).
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 63)
and “LOG Command” (page 91) or “SPOOL Command” (page 130).
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 104).
MARKUP
Current operating mode of the session. The default mode is SQL. For more
information, see “MODE Command” (page 92).
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 53) and “SET PROMPT Command” (page 109).
PROMPT
Current schema. The default is USR. For more information, see “Setting and
Showing the Current Schema” (page 55).
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 45).
SERVER
Current SQL statement terminator. The default is a semicolon (;). For more
information, see “Setting and Showing the SQL Terminator” (page 54) and “SHOW
SQLTERMINATOR Command” (page 124).
SQLTERMINATOR
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 53) and “SET TIME Command” (page 112).
TIME
122 Neoview Script Interface Commands