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

------ --------------- -------------------- ------- ------- ----------
72 GLENN THOMAS 3300 100 80000.00
--- 1 row(s) selected.
SQL>
NOTE: The named parameters, ?sal and ?job, in the SELECT statement are identical to
the parameter names, sal and job, in the set param command.
For more information, see “Setting parameters” (page 63).
SET PROMPT command
The set prompt command sets the prompt of the current RMXCI session to a specified string or
to these session variables:%USER, %SERVER, %SCHEMA, %DATASOURCE. The default prompt
is SQL>.
Syntax
SET PROMPT [string] [%USER] [%SERVER]
[%CATALOG] [%SCHEMA] [%DATASOURCE]
string
is a string value to be displayed as the 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.
%CATALOG
displays the session catalog as the prompt.
%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 prompt, enter the following command:
set prompt
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:
116 RMXCI commands