SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

SQL>set prompt %server>
nsksys.ind.hp.com:18650>
• The following command displays the session catalog for the prompt:
SQL>set prompt “Catalog %catalog:”
Catalog NONSTOP_SYSTEM_NSK:
• 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 %CATALOG@SCHEMA>
NONSTOP_SYSTEM_NSK @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 56).
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.
%SCHEMA
displays the session schema as the prompt.
%DATASOURCE
displays the session data source as the prompt.
SET SQLPROMPT command 117