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

TIMING OFF
USER role.dba
• This 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 NVS
MARKUP RAW
MODE SQL
PROMPT SQL >
ROLE DBA
SCHEMA USR
SERVER neo0101.acme.com:18650
SERVICE NAME HP_DEFAULT_SERVICE
SQLTERMINATOR ;
STATISTICS OFF
TIME OFF
TIMING OFF
USER role.dba
SHOW SQLPROMPT Command
The SHOW SQLPROMPT command displays the value of the SQL prompt for the current NCI
session.
Syntax
SHOW SQLPROMPT
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• You can execute this command only in SQL mode.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Example
This command shows that the SQL prompt for the current session is SQL>:
SQL>show sqlprompt
SQLPROMPT SQL>
SHOW SQLTERMINATOR Command
The SHOW SQLTERMINATOR command displays the SQL statement terminator of the current
NCI session.
Syntax
SHOW SQLTERMINATOR
140 NCI Commands