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

SQL>set param ?sal 40000.00

• The following command sets a character string value, GREEN, for the ?lastname parameter:

SQL>set param ?lastname GREEN

• The following commands set values for named parameters used in a subsequent SELECT

statement:

SQL>set param ?sal 80000.00

SQL>set param ?job 100

SQL>select * from persnl.employee

where salary = ?sal

and jobcode = ?job;

EMPNUM FIRST_NAME LAST_NAME DEPTNUM JOBCODE SALARY

------ --------------- -------------------- ------- ------- ----------

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 42).

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]

[%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.

%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

SET PROMPT command 93