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

,PRIMARY KEY (loc_code,partnum)
);
INSERT INTO invent.partloc
VALUES ('A10',2001, 800 ),
('A21', 255, 21 ),
('A34',6201, 0 ),
('A35',6301, 0 ),
('A36',6400, 34 ),
('A66',6603, 300 ),
('A67',6401, 454 ),
('A78', 244, 43 ),
('A78',5505, 100 ),
('A87', 212, 18 ),
('A88',2403, 735 ),
('A88',5504, 30 ),
('A94',3205, 200 ),
('A98',5110, 510 ),
('G11',2002, 20 ),
('G34',6201, 106 ),
('G35',6301, 331 ),
('G36',6400, 1034 ),
('G43',5100, 77 ),
('G45',4102, 69 ),
('G65',3201, 36 ),
('G68',6500, 1132 ),
('G76',2405, 42 ),
('G76',7301, 32 ),
('G78',5505, 0 ),
('G87', 212, 20 ),
('G87',3103, 0 ),
('G87',3210, 44 ),
('G87',2402, 0 ),
('G88',2403, 32 ),
('G88',5504, 0 ),
('G89',5101, 86 ),
('G94',3205, 59 ),
('G98',5103, 28 ),
('G98',5110, 136 ),
('P10',2001, 0 ),
('P12',2002, 200 ),
('P12',2003, 0 ),
('P15',2003, 200 ),
('P66',6603, 40 ),
('P67',6401, 54 ),
('P68',6500, 0 ),
('P76',7102, 200 ),
('P78', 244, 23 ),
('P87',3103, 300 );
UPDATE STATISTICS FOR TABLE invent.partloc ON EVERY COLUMN;
INVENT Schema 125