SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-86
Examples of CREATE PROCEDURE
•
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.