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