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:

COLSEP

Current column separator, which is used to control how query results are

 

presented. For more information, see “SET COLSEP Command” (page 101).

DATASOURCE

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).

HISTOPT

Current history options, which controls how the commands are added to the

 

history buffer. For more information, see “SET HISTOPT Command” (page 102).

IDLETIMEOUT

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).

LIST COUNT

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).

LOG

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).

LOOK AND FEEL

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).

MARKUP

Current markup option selected for the session. The default option is RAW. For

 

more information, see “SET MARKUP Command” (page 104).

MODE

Current operating mode of the session. The default mode is SQL. For more

 

information, see “MODE Command” (page 92).

PROMPT

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).

SCHEMA

Current schema. The default is USR. For more information, see “Setting and

 

Showing the Current Schema” (page 55).

SERVER

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).

SQLTERMINATOR

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).

TIME

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).

122 Neoview Script Interface Commands