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

Contents

HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004

7. Performance and Troubleshooting

Troubleshooting SPJ Problems 7-1

Performance Tips 7-2

Displaying an Execution Plan for a CALL Statement 7-3

Using the DISPLAY_EXPLAIN Command 7-3

Using the EXPLAIN Function 7-3

Displaying the Shape of a CALL Statement 7-4

CALL Statements Without a Shape 7-4

CALL Statements With a Shape 7-4

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