MX Release 3.1 (H06.23+, J06.12+)

Examples

• The following command sets the prompt to ENTER>:

SQL>set prompt Enter>

ENTER>

• The following command displays the session user name for the prompt:

SQL>set prompt %user>

usr>

• The following command displays the session host name and port number for the prompt:

SQL>set prompt %server>

nsksys.ind.hp.com:18650>

• The following command displays the session schema for the prompt:

SQL>set prompt "Schema %schema:"

Schema PUBLIC_ACCESS_SCHEMA:

• The following command displays the session data source for the prompt:

SQL>set prompt "%datasource SQL>"

TDM_Default_DataSource SQL>

• The following commands display different session variables for the prompt:

SQL>set prompt %USER@%SCHEMA>

usr@PUBLIC_ACCESS_SCHEMA>

SQL> set prompt %SERVER@DATASOURCE>

nsksys.ind.hp.com:18650@TDM_Default_DataSource>

SQL>set prompt ”%schema RMXCI> ”

PUBLIC_ACCESS_SCHEMA RMXCI>

For more information, see “Customizing the standard prompt” (page 35).

SET SQLPROMPT command

The set sqlprompt command sets the SQL prompt for the current RMXCI session. The default is

SQL>.

Syntax

SET SQLPROMPT [string] [%USER] [%SERVER]

[%SCHEMA] [%DATASOURCE]

string

is a string value to be displayed as the SQL prompt. The string may contain any characters.

Spaces are allowed if you enclose the string in double quotes. If you do not enclose the string

in double quotes, the prompt appears in uppercase.

%USER

displays the session user name as the prompt.

%SERVER

displays the session host name and port number as the prompt.

94 RMXCI commands