SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

111

112

113

114

115

116

117

118

119

120

Example 4 createprocs.sql-An OBEY Command File

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;

CREATE PROCEDURE samdbcat.persnl.employeejob(IN empnum INT,

OUT jobcode INT)

EXTERNAL NAME 'Payroll.employeeJob(int, java.lang.Integer[])'

EXTERNAL PATH '<mydir>'

LANGUAGE JAVA

PARAMETER STYLE JAVA

READS SQL DATA;

CREATE PROCEDURE samdbcat.invent.supplierinfo(INempnum NUMERIC(4),

OUT suppname CHAR(18),

OUT address CHAR(22),

OUT city CHAR(14),

OUT state CHAR(12),

OUT zipcode CHAR(10))

EXTERNAL NAME 'Inventory.supplierInfo'

EXTERNAL PATH '<mydir>'

LANGUAGE JAVA

PARAMETER STYLE JAVA

READS SQL DATA;

CREATE PROCEDURE samdbcat.invent.supplynumbers(OUT avrg INT,

OUT minm INT,

112 Sample SPJs