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

Payroll Class....................................................................................................................109
Inventory Class................................................................................................................110
The createprocs.sql File.........................................................................................................111
Examples of the Sample SPJs..................................................................................................113
LOWERPRICE Stored Procedure.........................................................................................113
DAILYORDERS Stored Procedure........................................................................................115
MONTHLYORDERS Stored Procedure.................................................................................115
TOTALPRICE Stored Procedure...........................................................................................116
ADJUSTSALARY Stored Procedure.......................................................................................117
EMPLOYEEJOB Stored Procedure.......................................................................................118
SUPPLIERINFO Stored Procedure........................................................................................119
SUPPLYNUMBERS Stored Procedure...................................................................................120
ORDERSUMMARY Stored Procedure...................................................................................121
Index.......................................................................................................123
6 Contents