Neoview Guide to Stored Procedures in Java (R2.5)

Calling the Procedure: PROJECTTEAM....................................................................................89
TOPSALESREPS Procedure............................................................................................................90
Java Method: topSalesReps()......................................................................................................90
Creating the Procedure: TOPSALESREPS.................................................................................90
Calling the Procedure: TOPSALESREPS...................................................................................91
Procedures in the INVENT Schema......................................................................................................92
SUPPLIERINFO Procedure.............................................................................................................94
Java Method: supplierInfo().......................................................................................................94
Creating the Procedure: SUPPLIERINFO..................................................................................94
Calling the Procedure: SUPPLIERINFO....................................................................................96
SUPPLYNUMBERS Procedure........................................................................................................97
Java Method: supplyQuantities()...............................................................................................97
Creating the Procedure: SUPPLYNUMBERS.............................................................................97
Calling the Procedure: SUPPLYNUMBERS...............................................................................98
PARTLOCS Procedure.....................................................................................................................99
Java Method: partLocations().....................................................................................................99
Creating the Procedure: PARTLOCS.........................................................................................99
Calling the Procedure: PARTLOCS..........................................................................................100
B Sample Database......................................................................................................101
PERSNL Schema.................................................................................................................................101
JOB Table........................................................................................................................................101
EMPLOYEE Table..........................................................................................................................101
DEPT Table....................................................................................................................................103
PROJECT Table..............................................................................................................................105
SALES Schema....................................................................................................................................108
CUSTOMER Table.........................................................................................................................108
ORDERS Table...............................................................................................................................109
ODETAIL Table..............................................................................................................................110
PARTS Table...................................................................................................................................112
INVENT Schema.................................................................................................................................113
SUPPLIER Table.............................................................................................................................113
PARTSUPP Table...........................................................................................................................114
PARTLOC Table.............................................................................................................................116
Index...............................................................................................................................119
6 Table of Contents