SQL/MX Quick Start (G06.24+, H06.03+)

Using the Same SELECT Statement Repeatedly
HP NonStop SQL/MX Quick Start—523724-002
7-2
Providing the Parameter Values
Providing the Parameter Values
You have prepared the statement CKO for execution. The parameters are ?order and
?part. You must provide the values for the parameters before execution.
Example
The first order on the stack is number 200300, and you want to know if the unit price is
correct for part number 2002:
SET PARAM ?order 200300;
SET PARAM ?part 2002;
EXECUTE CKO;
The output of the EXECUTE statement is:
Order/Num Part/Num Unit/Price Qty/Ord
--------- -------- ------------ ---------
200300 2002 1400.00 10
--- 1 row(s) selected.
Tip
•
Statement names and parameter names are not case-sensitive.
•
The prepared statement CKO can be executed repeatedly within your MXCI
session. To execute this statement with different values, use SET PARAM with
different values before statement execution.