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

Sample SPJs

HP NonStop SQL/MX Guide to Stored Procedures in Java—540433-003

A-25

ORDERSUMMARY Stored Procedure

CALL Statement to Invoke the SPJ

CALL samdbcat.sales.order_summary('01/01/2001', ?);

The ORDER_SUMMARY procedure accepts the date and returns this output in MXCI:

NUM_ORDERS

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

ORDERNUM NUM_PARTS AMOUNT Order/Date Last Name

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

100210 4 19020.00 2003-04-10 HUGHES

100250 4 22625.00 2003-01-23 HUGHES

101220 4 45525.00 2003-07-21 SCHNABL

200300 3 52000.00 2003-02-06 SCHAEFFER

200320 4 9195.00 2003-02-17 KARAJAN

200490 2 1065.00 2003-03-19 WEIGL

--- 13 row(s) selected.

Order/Num Part/Num Unit/Price Qty/Ord Part Description

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

100210 2001 1100.00 3 GRAPHIC PRINTER,M1

100210 2403 620.00 6 DAISY PRINTER,T2

100210 244 3500.00 3 PC GOLD, 30 MB

100210 5100 150.00 10 MONITOR BW, TYPE 1

100250 6500 95.00 10 DISK CONTROLLER

100250 6301 245.00 15 GRAPHIC CARD, HR

--- 70 row(s) selected.

--- SQL operation complete.