%DATASOURCE displays the session data source as the prompt.
Considerations
• In the Neoview Script interface, 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:
SQL>set sqlprompt %server>
sys0101.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>
nvs0101:23000@TDM_Default_DataSource>
SQL>set sqlprompt ”%schema NVSCRIPT> ”
NVSCHEMA NVSCRIPT>
For more information, see “Customizing the Standard Prompt” (page 53).
SET SQLPROMPT Command 111