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

( 20,'Macadam''S PC''s' ,'106 River Road'
,'New Orleans' ,'Louisiana' ,'67890' ),
( 25,'Schroeder''s Ltd' ,'212 Strasse Blvd West'
,'Hamburg' ,'Rhode Island','22222' ),
( 30,'O''Donnell''s Drives','729 West Palm Beach '
,'San Antonio' ,'Texas' ,'78344' ),
( 35,'Mac''Murphys PC''s' ,'93323 Alemeda'
,'Menlo Park' ,'California' ,'94025' ),
( 36,'MAC''MURPHYS PCB''s' ,'93323 Alemeda Suite B'
,'Menlo Park' ,'California' ,'94025' ),
( 90,'laser jets inc' ,'284 blue ridge way'
,'levittown' ,'penna.' ,'09520' ),
( 92,'watercolors' ,'84 north grand avenue'
,'menlo park' ,'california' ,'94025' ),
( 95,'application do''ers' ,'2846 yellowwood drive'
,'wayland' ,'mass' ,'02158' ),
( 99,'terminals, inc.' ,'2 longfellow way'
,'heightstown' ,'nj' ,'08520' ),
( 186,'186 Disk Makers' ,'186 Dis Way'
,'Dat Way' ,'Wisconsin' ,'00186' );
UPDATE STATISTICS FOR TABLE invent.supplier ON EVERY COLUMN;
PARTSUPP Table
CREATE TABLE invent.partsupp (
partnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,suppnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,partcost NUMERIC (8, 2)
NO DEFAULT
NOT NULL
,qty_received NUMERIC (5) UNSIGNED
DEFAULT 0
NOT NULL
,PRIMARY KEY (partnum,suppnum)
);
CREATE INDEX XSUPORD
ON partsupp (
suppnum
);
CREATE VIEW invent.view207 (
partnumber
,partdescrpt
,suppnumber
,supplrname
122 Sample Database