SQL/MX 3.2 Guide to Stored Procedures in Java (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Guide to Stored Procedures in Java—691166-001
v
A. Sample SPJs
A. Sample SPJs
Using Sample SPJs A-1
Installing the SampleSPJs.jar File A-1
Installing the SQL/MX Sample Database A-1
Class Files and Java Methods A-3
Sales Class A-3
Payroll Class A-7
Inventory Class A-9
The createprocs.sql File A-11
Examples of the Sample SPJs
A-13
LOWERPRICE Stored Procedure
A-13
DAILYORDERS Stored Procedure A-15
MONTHLYORDERS Stored Procedure A-16
TOTALPRICE Stored Procedure A-17
ADJUSTSALARY Stored Procedure A-18
EMPLOYEEJOB Stored Procedure A-19
SUPPLIERINFO Stored Procedure A-20
SUPPLYNUMBERS Stored Procedure A-21
Index
Examples
Example A-1. Sales.java—The Sales Class A-4
Example A-2. Payroll.java—The Payroll Class A-7
Example A-3.
Inventory.java—The Inventory Class A-9
Example A-4.
createprocs.sql—An OBEY Command File A-11
Figures
Figure 1-1. Different Applications Calling the Same SPJ 1-4
Figure 1-2. Registering an SPJ 1-6
Figure 1-3.
Invoking an SPJ 1-8
Figure 1-4.
SPJ Environment in NonStop SQL/MX 1-11
Figure 1-5. Initialization of SQL/MX UDR Server Processes 1-13
Figure 1-6. SPJ Class Loaders in an SQL/MX UDR Server Process 1-15
Figure 1-7. Java Classes That an SPJ Can Access 1-16
Figure 1-8. Copies of Java Classes in SPJ Class Loaders 1-18
Figure 6-1. Copying Java Classes to the Remote Node 6-19
Figure 6-2. Specifying the Node in the External Path 6-21
Figure A-1. Steps for Using Sample SPJs A-2