Filter
Top Products
ISQL and Tools
A-2 FairCom Corporation
oi_itemnum VARCHAR(6) );
CREATE INDEX orderitem ON orderitems (oi_ordernum, oi_seqnumber);
CREATE TABLE itemmast (
im_weight INTEGER,
im_price MONEY,
im_itemnum VARCHAR(6),
im_desc VARCHAR(48) );
CREATE INDEX itemnum ON itemmast (im_itemnum);
CREATE TABLE custmast (
cm_custnum VARCHAR(5),
cm_zip VARCHAR(10),
cm_state VARCHAR(3),
cm_rating VARCHAR(2),
cm_name VARCHAR(48),
cm_address VARCHAR(48),
cm_city VARCHAR(48));
CREATE INDEX custnum ON custmast (cm_custnum);
COMMIT WORK;
DELETE FROM ORDERLIST;
DELETE FROM ORDERITEMS;
DELETE FROM ITEMMAST;
DELETE FROM CUSTMAST;
COMMIT WORK;
INSERT INTO orderlist VALUES ('9/1/2002', '9/5/2002', '1', '1001');
INSERT INTO orderlist VALUES ('9/2/2002', '9/6/2002', '2', '1002');
INSERT INTO orderitems VALUES ('1', 1, 2, '1');
INSERT INTO orderitems VALUES ('1', 2, 1, '2');
INSERT INTO orderitems VALUES ('1', 3, 1, '3');
INSERT INTO orderitems VALUES ('2', 1, 3, '3');
INSERT INTO itemmast VALUES (10, 19.95, '1', 'Hammer');
INSERT INTO itemmast VALUES (3, 9.99, '2', 'Wrench');
INSERT INTO itemmast VALUES (4, 16.59, '3', 'Saw');
INSERT INTO itemmast VALUES (1, 3.98, '4', 'Pliers');
INSERT INTO custmast VALUES ('1000', '92867', 'CA', '1', 'Bryan Williams','2999
Regency', 'Orange');
INSERT INTO custmast VALUES ('1001', '61434', 'CT', '1', 'Michael Jordan', '13
Main', 'Harford');
INSERT INTO custmast VALUES ('1002', '73677', 'GA', '1', 'Joshua Brown', '4356
Cambridge', 'Atlanta');
INSERT INTO custmast VALUES ('1003', '10034', 'MO', '1', 'Keyon Dooling','19771
Park Avenue', 'Columbia');
COMMIT WORK;
COLUMN cm_name FORMAT "A15" heading "NAME"