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

(7102,'SMART MODEM, 1200' , 275.00, 2200 ),
(7301,'SMART MODEM, 2400' , 425.00, 2332 );
UPDATE STATISTICS FOR TABLE sales.parts ON EVERY COLUMN;
INVENT Schema
The INVENT schema stored inventory data.
SUPPLIER Table
CREATE TABLE invent.supplier (
suppnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,suppname CHARACTER (18)
NO DEFAULT
NOT NULL
,street CHARACTER (22)
NO DEFAULT
NOT NULL
,city CHARACTER (14)
NO DEFAULT
NOT NULL
,state CHARACTER (12)
NO DEFAULT
NOT NULL
,postcode CHARACTER (10)
NO DEFAULT
NOT NULL
,PRIMARY KEY (suppnum)
);
CREATE INDEX xsuppnam
ON supplier (
suppname
);
INSERT INTO invent.supplier
VALUES ( 1,'NEW COMPUTERS INC' ,'1800 KING ST.'
,'SAN FRANCISCO','CALIFORNIA' ,'94112' ),
( 2,'DATA TERMINAL INC' ,'2000 BAKER STREET'
,'LAS VEGAS' ,'NEVADA' ,'66134' ),
( 3,'HIGH DENSITY INC' ,'7600 EMERSON'
,'NEW YORK' ,'NEW YORK' ,'10230' ),
( 6,'MAGNETICS INC' ,'1000 INDUSTRY DRIVE'
,'LEXINGTON' ,'MASS' ,'02159' ),
( 8,'ATTRACTIVE CORP' ,'7777 FOUNTAIN WAY'
,'CHICAGO' ,'ILLINOIS' ,'60610' ),
( 10,'LEVERAGE INC' ,'6000 LINCOLN LANE'
,'DENVER' ,'COLORADO' ,'80712' ),
( 15,'DATADRIVE CORP' ,'100 MAC ARTHUR'
,'DALLAS' ,'TEXAS' ,'75244' ),
INVENT Schema 119