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

Contents
HP NonStop SQL/MX Guide to Stored Procedures in Java—540433-003
v
7. Performance and Troubleshooting (continued)
7. Performance and Troubleshooting (continued)
Displaying the Shape of a CALL Statement 7-5
CALL Statements Without a Shape
7-5
CALL Statements With a Shape
7-5
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
ORDERSUMMARY Stored Procedure A-23
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-9
Figure 1-4. SPJ Environment in NonStop SQL/MX 1-12
Figure 1-5. Initialization of SQL/MX UDR Server Processes 1-14
Figure 1-6. SPJ Class Loaders in an SQL/MX UDR Server Process 1-16