%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