SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-68
Examples of CREATE PROCEDURE
EXTERNAL PATH '/usr/mydir/myclasses'
LANGUAGE JAVA
PARAMETER STYLE JAVA;
Because the OUT parameter is supposed to map to the Java wrapper class,
java.lang.Integer, you must specify the Java signature in the EXTERNAL
NAME clause. To call this SPJ, use this statement:
CALL samdbcat.sales.monthlyorders(3, ?);
NUMBER
-----------
4
•
This CREATE PROCEDURE statement registers the SPJ named
SALES.ORDER_SUMMARY and returns two result sets.
CREATE PROCEDURE SAMDBCAT.SALES.ORDER_SUMMARY
(
IN ON_OR_AFTER_DATE VARCHAR(20) CHARACTER SET ISO88591
, OUT NUM_ORDERS LARGEINT
)
DYNAMIC RESULT SETS 2
READS SQL DATA LANGUAGE JAVA PARAMETER STYLE JAVA
EXTERNAL NAME 'SPJMethods.orderSummary'
EXTERNAL PATH '/usr/mydir/myclasses';
•
This CREATE PROCEDURE statement registers the SPJ named
SALES.PART_DATA and returns four result sets.
CREATE PROCEDURE SAMDBCAT.SALES.PART_DATA
(
IN PARTNUM NUMERIC(4)
, OUT PARTDESC CHAR(18)
, OUT PRICE NUMERIC(8,2)
, OUT QTY_AVAIL NUMERIC(5)
)
DYNAMIC RESULT SETS 4
READS SQL DATA LANGUAGE JAVA PARAMETER STYLE JAVA
EXTERNAL NAME 'SPJMethods.partData'
EXTERNAL PATH '/usr/mydir/myclasses';
For more examples, see the SQL/MX Guide to Stored Procedures in Java.