| CREATE TABLE trafodion.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 trafodion.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' ) |
| , ( 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 trafodion.invent.supplier ON EVERY COLUMN ; |