SQL/MX Guide to Stored Procedures in Java (G06.24+, H06.03+)

Invoking SPJs in NonStop SQL/MX
HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004
5-7
Using MXCI Unnamed Parameters
The output of the prepared CALL statement is:
In an MXCI session, invoke the SPJ named TOTALPRICE again by preparing and
executing a CALL statement in which all three parameters accept values that are set
by the USING clause of the EXECUTE statement. The INOUT parameter returns the
total price:
PREPARE stmt2 FROM CALL totalprice(?,?,?);
EXECUTE stmt2 USING 3, 'economy', 16.99;
The output of the prepared CALL statement is:
PRICE
---------------------
136.77
--- SQL operation complete.
PRICE
---------------------
57.12
--- SQL operation complete.