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

SET SQLPROMPT Command
The SET SQLPROMPT command sets the SQL prompt of the current session to a specified string.
The default is SQL>.
Syntax
SET SQLPROMPT [string] [%USER] [%MODE] [%SERVER]
[%SCHEMA] [%DATASOURCE]
string
is a string value to be displayed as the SQL prompt. The string may contain any characters.
Spaces are allowed if you enclose the string in double quotes. If you do not enclose the string
in double quotes, the prompt is displayed in uppercase.
%USER
displays the session user name as the prompt.
%MODE
displays the operating mode of the session as the prompt.
%SERVER
displays the session host name and port number as the prompt.
%SCHEMA
displays the session schema as the prompt.
%DATASOURCE
displays the session data source as the prompt.
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.
• To reset the default SQL prompt, enter this command:
SET SQLPROMPT
Examples
• This command sets the SQL prompt to ENTER>:
SQL>set sqlprompt Enter>
ENTER>
• To reset the SQL prompt to the default, enter this command:
ENTER>set sqlprompt
SQL>
• This command displays the session user name for the prompt:
SQL>set sqlprompt %user>
dba1>
• This command displays the operating mode of the session for the prompt:
SQL>set sqlprompt %mode:
SQL:
• This command displays the session host name and port number for the prompt:
SET SQLPROMPT Command 129