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

%SCHEMA

displays the session schema as the prompt.

%DATASOURCE

displays the session data source as the prompt.

Considerations

• You must enter the command in one line.

• To reset the default SQL prompt, enter this command:

set sqlprompt

Examples

• The following command sets the SQL prompt to ENTER>:

SQL>set sqlprompt Enter>

ENTER>

• The following command resets the SQL prompt to the default:

ENTER>set sqlprompt

SQL>

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

SQL>set sqlprompt %user>

usr>

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

SQL>set sqlprompt %server>

nsksys.ind.hp.com:18650>

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

SQL>set sqlprompt "Schema %schema:"

Schema PUBLIC_ACCESS_SCHEMA:

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

SQL>set sqlprompt "%datasource SQL>"

TDM_Default_DataSource SQL>

• These commands display different session variables for the prompt:

SQL>set sqlprompt %USER@%SCHEMA>

usr@PUBLIC_ACCESS_SCHEMA>

SQL>set sqlprompt %SERVER@%SCHEMA>

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

SQL>set sqlprompt ”%schema NVSCRIPT> ”

PUBLIC_ACCESS_SCHEMA NVSCRIPT>

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

SET SQLPROMPT command 95