HP NEOVIEW 544530-001 manual 123

TIMING	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).
USER	User name that you entered when logging in to the database platform. For more
	information, see “Logging In to the Database Platform” (page 45).

Examples

•This SHOW SESSION 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	BTEQ
MARKUP	XML
MODE	SQL
PROMPT	SQL>
SCHEMA	USR
SERVER	neo0101.acme.com:18650
SQLTERMINATOR	;
TIME	OFF
TIMING	OFF
USER	role.dba

•This SESSION command shows the effect of setting various session attributes:

SQL>session
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.dba

SHOW SQLPROMPT Command

The SHOW SQLPROMPT command displays the value of the SQL prompt for the current Neoview Script session.

Syntax

SHOW SQLPROMPT

SHOW SQLPROMPT Command 123