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

%ROLE
displays the current Neoview role 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.
• Unlike SET SQLPROMPT, you can execute this command in all NCI modes.
• To reset the default prompt, enter this command:
SET PROMPT
Examples
• This SET PROMPT command sets the SQL prompt to ENTER>:
SQL>set prompt Enter>
ENTER>
• This SET PROMPT command sets the CS prompt to #:
ENTER>mode cs
CS#set prompt #
#
• To reset the CS prompt to the default, enter this SET PROMPT command:
#set prompt
CS#
• To reset the SQL prompt to the default, enter this SET PROMPT command:
CS#mode sql
ENTER>set prompt
SQL>
• This command displays the session user name for the prompt:
SQL>set prompt %user>
dba1>
• This command displays the current role for the prompt:
SQL>set prompt %role>
ROLE.DBA>
• This command displays the operating mode of the session for the prompt:
SQL>set prompt %mode:
SQL:
• This command displays the session host name and port number for the prompt:
SET PROMPT Command 119