HP NEOVIEW 544530-001 Manual do Utilizador descarregar pdf (Página 111)

%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

1 2 ... 106 107 108 109 110 111 112 113 114 115 116 ... 141 142

Sem comentários

HP NEOVIEW 544530-001 Manual do Utilizador Página 111