SQL/MX 3.2 Guide to Stored Procedures in Java (H06.25+, J06.14+)

Sample SPJs
HP NonStop SQL/MX Release 3.2 Guide to Stored Procedures in Java—691166-001
A-24
ORDERSUMMARY Stored Procedure
" FROM sales.odetail D, sales.parts P, sales.orders O " +
" WHERE D.partnum = P.partnum AND D.ordernum = O.ordernum " +
" AND O.order_date >= cast(? as date) " +
" ORDER BY D.ordernum ";
java.sql.PreparedStatement ps3 = c.prepareStatement(s);
ps3.setString(1, onOrAfter);
detail[0] = ps3.executeQuery();
}
CREATE PROCEDURE Statement
CREATE PROCEDURE SAMDBCAT.SALES.ORDER_SUMMARY
(IN ON_OR_AFTER_DATE VARCHAR(20) CHARACTER SET ISO88591, OUT NUM_ORDERS
LARGEINT)
DYNAMIC RESULT SETS 2
EXTERNAL NAME 'SPJMethods.orderSummary(java.lang.String,
long[],java.sql.ResultSet[], java.sql.ResultSet[])'
EXTERNAL PATH '/usr/mydir/myclasses';
LOCATION \ALPINE.$SYSTEM.ZSDCR2C6.L1Z7NW00
LANGUAGE JAVA
PARAMETER STYLE JAVA
READS SQL DATA
NOT DETERMINISTIC
ISOLATE
;
--- SQL operation complete.