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

Creating the Procedure: SUPPLYNUMBERS...........................................................................102
Calling the Procedure: SUPPLYNUMBERS.............................................................................103
PARTLOCS Procedure...................................................................................................................104
Java Method: partLocations()...................................................................................................104
Creating the Procedure: PARTLOCS........................................................................................104
Calling the Procedure: PARTLOCS..........................................................................................105
B Sample Database......................................................................................................107
PERSNL Schema.................................................................................................................................107
JOB Table........................................................................................................................................107
EMPLOYEE Table..........................................................................................................................107
DEPT Table....................................................................................................................................109
PROJECT Table..............................................................................................................................111
SALES Schema....................................................................................................................................114
CUSTOMER Table.........................................................................................................................114
ORDERS Table...............................................................................................................................115
ODETAIL Table..............................................................................................................................116
PARTS Table...................................................................................................................................118
INVENT Schema.................................................................................................................................119
SUPPLIER Table.............................................................................................................................119
PARTSUPP Table...........................................................................................................................120
PARTLOC Table.............................................................................................................................122
Index...............................................................................................................................125
6 Table of Contents