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-12
The createprocs.sql File
Before executing the OBEY command file, createprocs.sql, change the external
paths from <dir> to the OSS directories that contain the SPJ class files.
The catalog and schemas of stored procedures must exist before you issue CREATE
PROCEDURE statements. The CREATE PROCEDURE statements in
createprocs.sql use the SAMDBCAT catalog and the SALES, PERSNL, and
INVENT schemas, which are part of the SQL/MX sample database. To install the
sample database, see the SQL/MX Quick Start.
To execute the CREATE PROCEDURE statements in createprocs.sql, you must
be either the schema owner (which you are if you install the sample database yourself)
or the super ID.
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(IN empnum 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,
OUT maxm INT)
EXTERNAL NAME 'Inventory.supplyQuantities'
EXTERNAL PATH '
<mydir>'
LANGUAGE JAVA
PARAMETER STYLE JAVA
READS SQL DATA;
Example A-4. createprocs.sql—An OBEY Command File (page 2 of 2)