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

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
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 terminator for the current session is a period (.):
SQL>show sqlterminator
SQLTERMINATOR .
For more information, see “Setting and Showing the SQL Terminator” (page 62).
148 NCI Commands