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

Sample SPJs
HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004
A-11
The createprocs.sql File
The createprocs.sql File
CREATE PROCEDURE statements register SPJ methods in an SQL/MX database.
Before registering the methods described in Class Files and Java Methods on
page A-3, you must compile the Java source files into class files. See Compiling Java
Classes on page 3-13.
An OBEY command file named createprocs.sql in SampleSPJs.jar contains the
CREATE PROCEDURE statements shown in Example A-4.
Example A-4. createprocs.sql—An OBEY Command File (page 1 of 2)
CREATE PROCEDURE samdbcat.sales.lowerprice()
EXTERNAL NAME 'Sales.lowerPrice'
EXTERNAL PATH '
<mydir>'
LANGUAGE JAVA
PARAMETER STYLE JAVA
MODIFIES SQL DATA;
CREATE PROCEDURE samdbcat.sales.dailyorders(IN DATE, OUT number INT)
EXTERNAL NAME 'Sales.numDailyOrders'
EXTERNAL PATH '
<mydir>'
LANGUAGE JAVA
PARAMETER STYLE JAVA
READS SQL DATA;
CREATE PROCEDURE samdbcat.sales.monthlyorders(IN INT, OUT number INT)
EXTERNAL NAME 'Sales.numMonthlyOrders'
EXTERNAL PATH '
<mydir>'
LANGUAGE JAVA
PARAMETER STYLE JAVA
READS SQL DATA;
CREATE PROCEDURE samdbcat.sales.totalprice(IN qty NUMERIC(18),
IN rate VARCHAR(10),
INOUT price NUMERIC(18,2))
EXTERNAL NAME 'Sales.totalPrice'
EXTERNAL PATH '
<mydir>'
LANGUAGE JAVA
PARAMETER STYLE JAVA
READS SQL DATA;
CREATE PROCEDURE samdbcat.persnl.adjustsalary(IN empnum NUMERIC(4),
IN percent FLOAT,
OUT newsalary NUMERIC(8,2))
EXTERNAL NAME 'Payroll.adjustSalary'
EXTERNAL PATH '
<mydir>'
LANGUAGE JAVA
PARAMETER STYLE JAVA
MODIFIES SQL DATA;