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

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 current role for the prompt:
SQL>set sqlprompt %role>
ROLE.DBA>
• 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:
SQL>set sqlprompt %server>
neo0101.mylab.mycorp.net:18650>
• This command displays the session schema for the prompt:
SQL>set sqlprompt "Schema %schema:"
Schema USR:
• This command displays the session data source for the prompt:
SQL>set sqlprompt "%datasource SQL>"
TDM_Default_DataSource SQL>
• This command displays multiple session variables:
SQL>set sqlprompt %USER@%SCHEMA>
super.super@USR>
nci0101:23000@TDM_Default_DataSource>
SQL>set sqlprompt ”%schema NVSCRIPT> ”
NVSCHEMA NVSCRIPT>
For more information, see “Customizing the Standard Prompt” (page 47).
SET SQLPROMPT Command 121