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

After running set param commands in the session:
• You can specify named parameters (?param-name) in a DML statement.
• You can run a prepared statement with named parameters by using the execute statement
without a using clause.
• You can run a prepared statement with unnamed parameters by using the execute command
with a using clause that contains either literal values or a list of the named parameters set
by set param command or both.
The execute statement substitutes parameter values for the parameters in the prepared statement.
For more information about execute, see the SQL/MX Release 3.x Reference Manual.
Syntax
SET PARAM param-name param-value
param-name
is the name of the parameter for which a value is specified. Parameter names are case-sensitive.
For example, the parameter ?pn is not equivalent to the parameter ?PN. param-name can
be preceded by a question mark (?), such as ?param-name.
param-value
is a numeric or character literal that specifies the value for the parameter. If you do not specify
a value, RMXCI returns an error.
If param-value is a character literal and the target column type is a character string, you do
not have to enclose the value in single quotation marks. Its data type is determined from the
data type of the column to which the literal is assigned. Character strings specified as parameter
values are always case-sensitive even if they are not enclosed in quotation marks.
Considerations
• You must enter the command in one line.
• Use separate set param commands to name and assign values to each unique parameter
in a prepared SQL statement before running the execute command.
• Parameter names are case-sensitive. If you specify a parameter name in lowercase in the set
param command, you must specify it in lowercase in other statements, such as DML statements
or execute statement.
• The named parameter (?param-name) in a DML statement must be identical to the parameter
name (param-name) that you specify in a set param command.
Examples
• The following command sets a value for the ?sal parameter:
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
SET PARAM command 115