Neoview Guide to Stored Procedures in Java (R2.3, R2.4)

Calling the Procedure: SUPPLIERINFO..................................................................................103
SUPPLYNUMBERS Procedure......................................................................................................104
Java Method: supplyQuantities().............................................................................................104
Creating the Procedure: SUPPLYNUMBERS...........................................................................104
Calling the Procedure: SUPPLYNUMBERS.............................................................................105
PARTLOCS Procedure...................................................................................................................106
Java Method: partLocations()...................................................................................................106
Creating the Procedure: PARTLOCS........................................................................................106
Calling the Procedure: PARTLOCS..........................................................................................107
B Sample Database......................................................................................................109
PERSNL Schema.................................................................................................................................109
JOB Table........................................................................................................................................109
EMPLOYEE Table..........................................................................................................................109
DEPT Table....................................................................................................................................111
PROJECT Table..............................................................................................................................113
SALES Schema....................................................................................................................................116
CUSTOMER Table.........................................................................................................................116
ORDERS Table...............................................................................................................................117
ODETAIL Table..............................................................................................................................118
PARTS Table...................................................................................................................................120
INVENT Schema.................................................................................................................................121
SUPPLIER Table.............................................................................................................................121
PARTSUPP Table...........................................................................................................................122
PARTLOC Table.............................................................................................................................124
Index...............................................................................................................................127
6 Table of Contents