| >>--------------------------------------------------------------------- |
| >>-- Component: NonStop SQL Regression Test Suite |
| >>-- Description: SELECT * against populated database to check that |
| >>-- correct values were stored. |
| >>--------------------------------------------------------------------- |
| >> |
| >>--------------------------------------------------------------------- |
| >>-- ENFORM class/manuals order-entry/personnel database. |
| >>--------------------------------------------------------------------- |
| >> SELECT * FROM orders ; |
| |
| ORDERNUM OMONTH ODAY OYEAR DMONTH DDAY DYEAR SALESMAN CUSTNUM |
| -------- ------ ---- ----- ------ ---- ----- -------- ------- |
| |
| 21 1 10 78 4 10 78 205 1234 |
| 25 1 23 78 6 15 78 212 7777 |
| 30 2 6 78 7 1 78 222 926 |
| 32 2 17 78 7 20 78 204 21 |
| 35 3 3 78 8 10 78 231 543 |
| 38 3 19 78 8 20 78 218 123 |
| 41 3 27 78 9 1 78 207 7654 |
| 45 4 20 78 9 15 78 212 324 |
| 48 5 12 78 10 10 78 225 3333 |
| 51 6 1 78 10 20 78 210 143 |
| 66 7 9 78 11 1 78 205 3210 |
| 122 7 21 78 12 15 78 221 5635 |
| |
| --- 12 row(s) selected. |
| >> SELECT * FROM customer ; |
| |
| CUSTNUM CUSTNAME ADDRESS CITY STATE |
| ------- ------------------ ---------------------- -------------- ------------ |
| |
| 21 CENTRAL UNIVERSITY UNIVERSITY WAY PHILADELPHIA PENN |
| 123 BROWN MEDICAL CO 100 CALIFORNIA STREET SAN FRANCISCO CALIFORNIA |
| 143 STEVENS SUPPLY 2020 HARRIS STREET DENVER COLORADO |
| 324 PREMIER INSURANCE 3300 WARBASH LUBBOCK TEXAS |
| 543 FRESNO STATE BANK 2300 BROWN BLVD FRESNO CALIFORNIA |
| 926 METALL-AG. 12 WAGNERRING FRANKFURT GERMANY |
| 1234 DATASPEED 300 SAN GABRIEL WAY NEW YORK NEW YORK |
| 3210 BESTFOOD MARKETS 3333 PLELPS STREET LINCOLN NEBRASKA |
| 3333 DEUTSCHE STAHL SIEMENS-STRASSE DUISBURG GERMANY |
| 5635 VEREINIGTE CHEMIE 45 FRANKENSTRASSE MUENCHEN GERMANY |
| 7654 MOTOR DISTRIBUTING 2345 FIRST STREET CHICAGO ILLINOIS |
| 7777 SLEEPWELL HOTELS 9000 PETERS AVENUE DALLAS TEXAS |
| |
| --- 12 row(s) selected. |
| >> SELECT * FROM fromsup ; |
| |
| PARTNUM SUPPNUM PARTCOST |
| ------- ------- ----------- |
| |
| 212 1 92000.00 |
| 244 1 87000.00 |
| 1403 1 22000.00 |
| 2001 1 1500.00 |
| 2002 1 1000.00 |
| 2003 1 500.00 |
| 2402 1 7500.00 |
| 2403 1 9600.00 |
| 3102 1 4800.00 |
| 3103 1 10500.00 |
| 3201 1 4800.00 |
| 3302 1 2800.00 |
| 4101 6 6000.00 |
| 4101 15 6000.00 |
| 4102 6 10000.00 |
| 4102 8 12000.00 |
| 4102 15 11000.00 |
| 4103 6 20100.00 |
| 4103 8 19300.00 |
| 4103 15 19500.00 |
| 5101 8 5800.00 |
| 5101 15 5900.00 |
| 5103 8 6200.00 |
| 5103 15 6250.00 |
| 5502 2 9100.00 |
| 5504 2 1600.00 |
| 5504 6 1580.00 |
| 5504 15 1620.00 |
| 5505 15 33000.00 |
| 6201 1 5800.00 |
| 6301 1 2900.00 |
| 6302 1 4300.00 |
| 6401 2 1200.00 |
| 6401 3 1100.00 |
| 6402 2 1100.00 |
| 6402 3 1200.00 |
| 6603 2 2600.00 |
| 7102 10 6000.00 |
| 7301 1 2400.00 |
| |
| --- 39 row(s) selected. |
| >> SELECT * FROM odetail ; |
| |
| ORDERNUM PARTNUM QUANTITY |
| -------- ------- -------- |
| |
| 21 244 1 |
| 21 2001 2 |
| 21 2403 2 |
| 21 4103 2 |
| 25 244 1 |
| 25 5103 1 |
| 25 6301 2 |
| 25 6402 10 |
| 30 244 1 |
| 30 2001 2 |
| 30 2002 2 |
| 30 2003 2 |
| 30 3102 2 |
| 30 4101 2 |
| 30 6302 1 |
| 32 244 1 |
| 32 2001 2 |
| 32 2402 6 |
| 32 3102 1 |
| 32 3202 1 |
| 32 3302 1 |
| 32 4102 1 |
| 32 5103 1 |
| 32 5504 1 |
| 32 6201 1 |
| 32 6301 1 |
| 32 6302 1 |
| 35 244 1 |
| 35 2001 2 |
| 35 2403 4 |
| 35 3103 2 |
| 35 3302 1 |
| 35 4103 2 |
| 35 5503 1 |
| 35 6301 1 |
| 35 6302 2 |
| 38 244 1 |
| 38 2402 3 |
| 38 3102 1 |
| 38 4102 1 |
| 38 5502 1 |
| 38 6201 1 |
| 38 6302 1 |
| 38 6402 2 |
| 41 244 1 |
| 41 1403 1 |
| 41 2001 3 |
| 41 2002 3 |
| 41 2003 3 |
| 41 2403 10 |
| 41 3103 2 |
| 41 3302 2 |
| 41 4103 4 |
| 41 5504 2 |
| 41 6201 1 |
| 41 6301 4 |
| 41 6302 10 |
| 41 7301 3 |
| 45 212 1 |
| 45 1403 1 |
| 45 2001 2 |
| 45 2002 2 |
| 45 2402 6 |
| 45 2403 2 |
| 45 3102 1 |
| 45 4102 3 |
| 45 6301 1 |
| 45 6302 3 |
| 45 7301 1 |
| 48 244 1 |
| 48 1403 2 |
| 48 2001 2 |
| 48 2002 2 |
| 48 2003 2 |
| 48 2403 6 |
| 48 3103 2 |
| 48 3302 1 |
| 48 4103 3 |
| 48 5103 1 |
| 48 5504 1 |
| 48 6201 1 |
| 48 6302 1 |
| 48 7102 1 |
| 48 7301 2 |
| 51 1403 4 |
| 51 2001 4 |
| 51 2002 4 |
| 51 2003 4 |
| 51 2403 16 |
| 51 3103 5 |
| 51 3202 2 |
| 51 3302 1 |
| 51 4103 11 |
| 51 5103 1 |
| 51 5505 1 |
| 51 6301 2 |
| 51 6302 2 |
| 51 6402 8 |
| 51 7102 1 |
| 66 244 1 |
| 66 1403 3 |
| 66 2001 5 |
| 66 2403 8 |
| 66 3102 3 |
| 66 3202 1 |
| 66 3302 3 |
| 66 4101 1 |
| 66 4102 6 |
| 66 4103 2 |
| 66 5101 1 |
| 66 5502 8 |
| 66 5504 3 |
| 66 6201 1 |
| 66 6301 4 |
| 66 6302 5 |
| 66 6401 6 |
| 66 6402 22 |
| 66 7102 1 |
| 66 7301 2 |
| 122 1403 10 |
| 122 2002 10 |
| 122 2403 30 |
| 122 3103 20 |
| 122 3201 3 |
| 122 4103 40 |
| 122 5103 3 |
| 122 7102 7 |
| 122 7301 8 |
| |
| --- 128 row(s) selected. |
| >> SELECT * FROM parts ; |
| |
| PARTNUM PARTNAME INVENTORY LOCATION PRICE |
| ------- ------------------ --------- -------- ----------- |
| |
| 212 SYSTEM 192KB CORE 7 J87 92000.00 |
| 244 SYSTEM 192KB SEMI 3 B78 87000.00 |
| 1403 PROC 96KB SEMI 21 A21 22000.00 |
| 2001 DECIMAL ARITH -100 X10 1500.00 |
| 2002 ENSCRIBE MICRO 200 X11 1000.00 |
| 2003 COBOL MICRO 200 X12 500.00 |
| 2402 MEM MOD 64K MOS -34 H87 7500.00 |
| 2403 MEM MOD 96K MOS 12 J88 9600.00 |
| 3102 DISC CONT SINGLE 12 H76 4800.00 |
| 3103 DISC CONT DUAL -4 H87 10500.00 |
| 3201 MAG TAPE CONT 8/16 6 J65 4800.00 |
| 3302 LINE PRINTER CONT 9 K94 2800.00 |
| 4101 DISC 10MB 14 K87 8000.00 |
| 4102 DISC 50MB 9 K45 14500.00 |
| 4103 DISK 160MB 7 K43 24500.00 |
| 5101 MAG TAPE DR 800BPI 6 K89 7400.00 |
| 5103 MAG TAPE DR 8/16 8 L98 8000.00 |
| 5502 LP 300 LPM 6 L98 11500.00 |
| 5504 LP 900 LPM -1 L88 21000.00 |
| 5505 LP 1500LPM 0 L78 42000.00 |
| 6201 SYNC CONTROLLER -16 A34 5800.00 |
| 6301 ASYNC CONTROLLER -21 A35 2900.00 |
| 6302 ASYNC EXTENSION 34 A36 4300.00 |
| 6401 TERM CRT CHAR 54 V67 1500.00 |
| 6402 TERM CRT PAGE -32 V68 1500.00 |
| 6603 TERM HARD COPY 40 V66 3200.04 |
| 7102 CABINET LARGE 20 F76 68000.05 |
| 7301 POWER MODULE 32 H76 2400.06 |
| |
| --- 28 row(s) selected. |
| >> SELECT * FROM supplier ; |
| |
| SUPPNUM SUPPNAME ADDRESS CITY STATE |
| ------- ------------------ ---------------------- -------------- ------------ |
| |
| 1 TANDEM COMPUTERS 19333 VALLCO PARKWAY CUPERTINO CALIFORNIA |
| 2 DATA TERMINAL CO 2000 BAKER STREET IRVINE CALIFORNIA |
| 3 DISPLAY INC 7600 EMERSON PALO ALTO CALIFORNIA |
| 6 INFOMATION STORAGE 1000 INDUSTRY DRIVE LEXINGTON MASS |
| 8 MAGNETICS CORP 7777 FOUNTAIN WAY SEATTLE WASHINGTON |
| 10 STEELWORK INC 6000 LINCOLN LANE SUNNYVALE CALIFORNIA |
| 15 DATADRIVE 100 MACARTHUR DALLAS TEXAS |
| |
| --- 7 row(s) selected. |
| >> SELECT * FROM region ; |
| |
| REGNUM REGNAME LOCATION MANAGER |
| ------ ------------ -------------- ------- |
| |
| 1 EAST NEW YORK 29 |
| 2 CENTRAL CHICAGO 104 |
| 3 WEST DALLAS 72 |
| 4 CANADA TORONTO 343 |
| 5 GERMANY FRANKFURT 43 |
| 6 ENGLAND LONDON 87 |
| 99 HEADQUARTERS CUPERTINO 1 |
| |
| --- 7 row(s) selected. |
| >> SELECT * FROM branch ; |
| |
| REGNUM BRANCHNUM BRANCHNAME MANAGER |
| ------ --------- -------------- ------- |
| |
| 1 1 NEW YORK 75 |
| 1 2 NEW JERSEY 129 |
| 2 1 CHICAGO 23 |
| 2 2 HOUSTON 109 |
| 2 3 ST. LOUIS 111 |
| 3 1 DALLAS 321 |
| 3 2 LOS ANGELES 337 |
| 3 3 SAN FRANCISCO 89 |
| 4 1 TORONTO 178 |
| 4 2 VANCOUVER 93 |
| 5 1 FRANKFURT 180 |
| 5 2 DUESSELDORF 39 |
| 5 3 MUENCHEN 32 |
| 6 1 LONDON 65 |
| 99 1 CUPERTINO 88 |
| |
| --- 15 row(s) selected. |
| >> SELECT * FROM employee ; |
| |
| EMPNUM EMPNAME REGNUM BRANCHNUM JOB AGE SALARY VACATION |
| ------ ------------------ ------ --------- ------------ ----- ---------- -------- |
| |
| 1 ROGER GREEN 99 1 MANAGER 37 39500 2 |
| 23 JERRY HOWARD 2 1 MANAGER 34 37000 10 |
| 29 JACK RAYMOND 1 1 MANAGER 39 36000 1 |
| 32 THOMAS RUDLOFF 5 3 MANAGER 43 38000 4 |
| 39 KLAUS SAFFERT 5 2 MANAGER 35 35000 12 |
| 43 PAUL WINTER 5 1 MANAGER 41 40000 5 |
| 65 SUSAN HENDERSON 6 1 MANAGER 45 38000 9 |
| 72 GLENN THOMAS 3 1 MANAGER 48 40000 14 |
| 75 TIM WALKER 1 1 MANAGER 29 32000 7 |
| 87 ERIC BROWN 6 1 MANAGER 31 39000 10 |
| 89 PETER SMITH 3 3 MANAGER 36 37000 4 |
| 93 DONALD TAYLOR 4 2 MANAGER 31 33000 0 |
| 104 DAVID STRAND 2 1 MANAGER 32 39000 2 |
| 109 STEVE COOK 2 2 MANAGER 39 38000 15 |
| 111 SHERRIE WONG 2 3 MANAGER 43 40000 0 |
| 129 TONY CRAFT 1 2 MANAGER 35 37000 5 |
| 178 LINDA JONES 4 1 MANAGER 40 38000 8 |
| 180 MANFRED CONRAD 5 1 MANAGER 30 32000 14 |
| 201 JIM HERMAN 1 1 SALESMAN 27 19000 13 |
| 202 LARRY CLARK 1 1 SYS.-ANAL. 30 25000 7 |
| 203 KATHRYN DAY 1 1 SECRETARY 24 12000 12 |
| 204 TOM HALL 1 1 SALESMAN 35 26000 0 |
| 205 GEORGE FORSTER 1 2 SALESMAN 39 30000 4 |
| 206 DAVE FISHER 2 1 SALESMAN 32 25000 7 |
| 207 MARK FOLEY 2 1 SALESMAN 27 23000 10 |
| 208 SUE CRAMER 2 1 SECRETARY 47 19000 6 |
| 209 SUSAN CHAPMAN 2 1 PROGRAMMER 26 17000 0 |
| 210 RICHARD BARTON 2 2 SALESMAN 39 29000 7 |
| 211 JIMMY SCHNEIDER 2 3 SYS.-ANAL. 34 26000 0 |
| 212 JONATHAN MITCHEL 3 1 SALESMAN 39 32000 15 |
| 213 ROBERT WHITE 3 1 ENGINEER 29 30000 4 |
| 214 JULIA KELLY 3 1 SECRETARY 21 50000 1 |
| 215 WALTER LANCASTER 3 2 SALESMAN 49 33000 15 |
| 216 JOHN JONES 3 2 SYS.-ANAL. 31 30000 7 |
| 217 MARLENE BONNY 3 3 SYS.-ANAL. 25 24000 9 |
| 218 GEORGE FRENCHMAN 3 3 SALESMAN 35 31000 0 |
| 219 DAVID TERRY 3 3 PROGRAMMER 37 27000 12 |
| 220 JOHANN HUBER 5 1 SYS.-ANAL. 35 33000 10 |
| 221 OTTO SCHNABL 5 1 SALESMAN 39 33000 1 |
| 222 MARTIN SCHAEFER 5 1 SALESMAN 32 31000 1 |
| 223 HERBERT KARAJAN 5 1 ENGINEER 33 29000 6 |
| 224 MARIA JOSEF 5 1 SECRETARY 19 18000 10 |
| 225 KARL HELMSTED 5 2 SALESMAN 34 32000 11 |
| 226 HEIDI WEIGL 5 2 SECRETARY 55 22000 14 |
| 227 XAVER SEDLMEYER 5 3 SYST.-ANAL 30 30000 4 |
| 228 PETE WELLINGTON 99 1 SYST.-ANAL 39 32000 2 |
| 229 GEORGE STRICKER 99 1 SYST.-ANAL 36 32222 6 |
| 230 ROCKY LEWIS 99 1 PROGRAMMER 32 24000 0 |
| 231 HERB ALBERT 99 1 SALESMAN 39 33000 2 |
| 232 THOMAS SPINNER 99 1 SALESMAN 33 30000 5 |
| 233 TED MCDONNALDS 99 1 ENGINEER 29 29000 0 |
| 234 MARY MILLER 99 1 SECRETARY 22 16000 9 |
| 235 MIRIAM KING 99 1 SECRETARY 24 18000 11 |
| 321 BILL WINN 3 1 MANAGER 28 32000 0 |
| 337 DAVE CLARK 3 2 MANAGER 36 37000 2 |
| 343 ALAN TERRY 4 1 MANAGER 39 39500 0 |
| |
| --- 56 row(s) selected. |
| >>--------------------------------------------------------------------- |
| >> SELECT * FROM empone ; |
| |
| EMPNUM |
| ------ |
| |
| 343 |
| 321 |
| 337 |
| 206 |
| 104 |
| 219 |
| 93 |
| 87 |
| 205 |
| 218 |
| 229 |
| 72 |
| 226 |
| 231 |
| 223 |
| 29 |
| 23 |
| 201 |
| 211 |
| 220 |
| 216 |
| 212 |
| 214 |
| 225 |
| 203 |
| 39 |
| 202 |
| 178 |
| 180 |
| 224 |
| 207 |
| 217 |
| 222 |
| 234 |
| 235 |
| 221 |
| 43 |
| 228 |
| 89 |
| 210 |
| 213 |
| 230 |
| 1 |
| 111 |
| 109 |
| 208 |
| 209 |
| 65 |
| 233 |
| 32 |
| 232 |
| 75 |
| 204 |
| 129 |
| 215 |
| 227 |
| |
| --- 56 row(s) selected. |
| >> SELECT * FROM emppub ; |
| |
| EMPNUM EMPNAME REGNUM BRANCHNUM JOB VACATION |
| ------ ------------------ ------ --------- ------------ -------- |
| |
| 1 ROGER GREEN 99 1 MANAGER 2 |
| 23 JERRY HOWARD 2 1 MANAGER 10 |
| 29 JACK RAYMOND 1 1 MANAGER 1 |
| 32 THOMAS RUDLOFF 5 3 MANAGER 4 |
| 39 KLAUS SAFFERT 5 2 MANAGER 12 |
| 43 PAUL WINTER 5 1 MANAGER 5 |
| 65 SUSAN HENDERSON 6 1 MANAGER 9 |
| 72 GLENN THOMAS 3 1 MANAGER 14 |
| 75 TIM WALKER 1 1 MANAGER 7 |
| 87 ERIC BROWN 6 1 MANAGER 10 |
| 89 PETER SMITH 3 3 MANAGER 4 |
| 93 DONALD TAYLOR 4 2 MANAGER 0 |
| 104 DAVID STRAND 2 1 MANAGER 2 |
| 109 STEVE COOK 2 2 MANAGER 15 |
| 111 SHERRIE WONG 2 3 MANAGER 0 |
| 129 TONY CRAFT 1 2 MANAGER 5 |
| 178 LINDA JONES 4 1 MANAGER 8 |
| 180 MANFRED CONRAD 5 1 MANAGER 14 |
| 201 JIM HERMAN 1 1 SALESMAN 13 |
| 202 LARRY CLARK 1 1 SYS.-ANAL. 7 |
| 203 KATHRYN DAY 1 1 SECRETARY 12 |
| 204 TOM HALL 1 1 SALESMAN 0 |
| 205 GEORGE FORSTER 1 2 SALESMAN 4 |
| 206 DAVE FISHER 2 1 SALESMAN 7 |
| 207 MARK FOLEY 2 1 SALESMAN 10 |
| 208 SUE CRAMER 2 1 SECRETARY 6 |
| 209 SUSAN CHAPMAN 2 1 PROGRAMMER 0 |
| 210 RICHARD BARTON 2 2 SALESMAN 7 |
| 211 JIMMY SCHNEIDER 2 3 SYS.-ANAL. 0 |
| 212 JONATHAN MITCHEL 3 1 SALESMAN 15 |
| 213 ROBERT WHITE 3 1 ENGINEER 4 |
| 214 JULIA KELLY 3 1 SECRETARY 1 |
| 215 WALTER LANCASTER 3 2 SALESMAN 15 |
| 216 JOHN JONES 3 2 SYS.-ANAL. 7 |
| 217 MARLENE BONNY 3 3 SYS.-ANAL. 9 |
| 218 GEORGE FRENCHMAN 3 3 SALESMAN 0 |
| 219 DAVID TERRY 3 3 PROGRAMMER 12 |
| 220 JOHANN HUBER 5 1 SYS.-ANAL. 10 |
| 221 OTTO SCHNABL 5 1 SALESMAN 1 |
| 222 MARTIN SCHAEFER 5 1 SALESMAN 1 |
| 223 HERBERT KARAJAN 5 1 ENGINEER 6 |
| 224 MARIA JOSEF 5 1 SECRETARY 10 |
| 225 KARL HELMSTED 5 2 SALESMAN 11 |
| 226 HEIDI WEIGL 5 2 SECRETARY 14 |
| 227 XAVER SEDLMEYER 5 3 SYST.-ANAL 4 |
| 228 PETE WELLINGTON 99 1 SYST.-ANAL 2 |
| 229 GEORGE STRICKER 99 1 SYST.-ANAL 6 |
| 230 ROCKY LEWIS 99 1 PROGRAMMER 0 |
| 231 HERB ALBERT 99 1 SALESMAN 2 |
| 232 THOMAS SPINNER 99 1 SALESMAN 5 |
| 233 TED MCDONNALDS 99 1 ENGINEER 0 |
| 234 MARY MILLER 99 1 SECRETARY 9 |
| 235 MIRIAM KING 99 1 SECRETARY 11 |
| 321 BILL WINN 3 1 MANAGER 0 |
| 337 DAVE CLARK 3 2 MANAGER 2 |
| 343 ALAN TERRY 4 1 MANAGER 0 |
| |
| --- 56 row(s) selected. |
| >> SELECT * FROM expfroms ; |
| |
| PARTNUM SUPPNUM PARTCOST |
| ------- ------- ----------- |
| |
| 212 1 92000.00 |
| 244 1 87000.00 |
| 1403 1 22000.00 |
| 3103 1 10500.00 |
| 4102 8 12000.00 |
| 4102 15 11000.00 |
| 4103 6 20100.00 |
| 4103 8 19300.00 |
| 4103 15 19500.00 |
| 5505 15 33000.00 |
| |
| --- 10 row(s) selected. |
| >>--------------------------------------------------------------------- |
| >> SELECT * FROM partsfor ; |
| |
| COL_1 COL_2 COL_3 COL_4 COL_5 COL_6 COL_7 COL_8 COL_9 COL_10 COL_11 COL_12 |
| ------------------ ----- ----------- ----- ----- ----- ----- ----- ----- ------ ------ ------ |
| |
| SYSTEM 192KB SEMI B78 87000.00 21 78 1 10 78 4 10 205 1234 |
| DECIMAL ARITH X10 1500.00 21 78 1 10 78 4 10 205 1234 |
| MEM MOD 96K MOS J88 9600.00 21 78 1 10 78 4 10 205 1234 |
| DISK 160MB K43 24500.00 21 78 1 10 78 4 10 205 1234 |
| SYSTEM 192KB SEMI B78 87000.00 25 78 1 23 78 6 15 212 7777 |
| MAG TAPE DR 8/16 L98 8000.00 25 78 1 23 78 6 15 212 7777 |
| ASYNC CONTROLLER A35 2900.00 25 78 1 23 78 6 15 212 7777 |
| TERM CRT PAGE V68 1500.00 25 78 1 23 78 6 15 212 7777 |
| SYSTEM 192KB SEMI B78 87000.00 30 78 2 6 78 7 1 222 926 |
| DECIMAL ARITH X10 1500.00 30 78 2 6 78 7 1 222 926 |
| ENSCRIBE MICRO X11 1000.00 30 78 2 6 78 7 1 222 926 |
| COBOL MICRO X12 500.00 30 78 2 6 78 7 1 222 926 |
| DISC CONT SINGLE H76 4800.00 30 78 2 6 78 7 1 222 926 |
| DISC 10MB K87 8000.00 30 78 2 6 78 7 1 222 926 |
| ASYNC EXTENSION A36 4300.00 30 78 2 6 78 7 1 222 926 |
| SYSTEM 192KB SEMI B78 87000.00 32 78 2 17 78 7 20 204 21 |
| DECIMAL ARITH X10 1500.00 32 78 2 17 78 7 20 204 21 |
| MEM MOD 64K MOS H87 7500.00 32 78 2 17 78 7 20 204 21 |
| DISC CONT SINGLE H76 4800.00 32 78 2 17 78 7 20 204 21 |
| LINE PRINTER CONT K94 2800.00 32 78 2 17 78 7 20 204 21 |
| DISC 50MB K45 14500.00 32 78 2 17 78 7 20 204 21 |
| MAG TAPE DR 8/16 L98 8000.00 32 78 2 17 78 7 20 204 21 |
| LP 900 LPM L88 21000.00 32 78 2 17 78 7 20 204 21 |
| SYNC CONTROLLER A34 5800.00 32 78 2 17 78 7 20 204 21 |
| ASYNC CONTROLLER A35 2900.00 32 78 2 17 78 7 20 204 21 |
| ASYNC EXTENSION A36 4300.00 32 78 2 17 78 7 20 204 21 |
| SYSTEM 192KB SEMI B78 87000.00 35 78 3 3 78 8 10 231 543 |
| DECIMAL ARITH X10 1500.00 35 78 3 3 78 8 10 231 543 |
| MEM MOD 96K MOS J88 9600.00 35 78 3 3 78 8 10 231 543 |
| DISC CONT DUAL H87 10500.00 35 78 3 3 78 8 10 231 543 |
| LINE PRINTER CONT K94 2800.00 35 78 3 3 78 8 10 231 543 |
| DISK 160MB K43 24500.00 35 78 3 3 78 8 10 231 543 |
| ASYNC CONTROLLER A35 2900.00 35 78 3 3 78 8 10 231 543 |
| ASYNC EXTENSION A36 4300.00 35 78 3 3 78 8 10 231 543 |
| SYSTEM 192KB SEMI B78 87000.00 38 78 3 19 78 8 20 218 123 |
| MEM MOD 64K MOS H87 7500.00 38 78 3 19 78 8 20 218 123 |
| DISC CONT SINGLE H76 4800.00 38 78 3 19 78 8 20 218 123 |
| DISC 50MB K45 14500.00 38 78 3 19 78 8 20 218 123 |
| LP 300 LPM L98 11500.00 38 78 3 19 78 8 20 218 123 |
| SYNC CONTROLLER A34 5800.00 38 78 3 19 78 8 20 218 123 |
| ASYNC EXTENSION A36 4300.00 38 78 3 19 78 8 20 218 123 |
| TERM CRT PAGE V68 1500.00 38 78 3 19 78 8 20 218 123 |
| SYSTEM 192KB SEMI B78 87000.00 41 78 3 27 78 9 1 207 7654 |
| PROC 96KB SEMI A21 22000.00 41 78 3 27 78 9 1 207 7654 |
| DECIMAL ARITH X10 1500.00 41 78 3 27 78 9 1 207 7654 |
| ENSCRIBE MICRO X11 1000.00 41 78 3 27 78 9 1 207 7654 |
| COBOL MICRO X12 500.00 41 78 3 27 78 9 1 207 7654 |
| MEM MOD 96K MOS J88 9600.00 41 78 3 27 78 9 1 207 7654 |
| DISC CONT DUAL H87 10500.00 41 78 3 27 78 9 1 207 7654 |
| LINE PRINTER CONT K94 2800.00 41 78 3 27 78 9 1 207 7654 |
| DISK 160MB K43 24500.00 41 78 3 27 78 9 1 207 7654 |
| LP 900 LPM L88 21000.00 41 78 3 27 78 9 1 207 7654 |
| SYNC CONTROLLER A34 5800.00 41 78 3 27 78 9 1 207 7654 |
| ASYNC CONTROLLER A35 2900.00 41 78 3 27 78 9 1 207 7654 |
| ASYNC EXTENSION A36 4300.00 41 78 3 27 78 9 1 207 7654 |
| POWER MODULE H76 2400.06 41 78 3 27 78 9 1 207 7654 |
| SYSTEM 192KB CORE J87 92000.00 45 78 4 20 78 9 15 212 324 |
| PROC 96KB SEMI A21 22000.00 45 78 4 20 78 9 15 212 324 |
| DECIMAL ARITH X10 1500.00 45 78 4 20 78 9 15 212 324 |
| ENSCRIBE MICRO X11 1000.00 45 78 4 20 78 9 15 212 324 |
| MEM MOD 64K MOS H87 7500.00 45 78 4 20 78 9 15 212 324 |
| MEM MOD 96K MOS J88 9600.00 45 78 4 20 78 9 15 212 324 |
| DISC CONT SINGLE H76 4800.00 45 78 4 20 78 9 15 212 324 |
| DISC 50MB K45 14500.00 45 78 4 20 78 9 15 212 324 |
| ASYNC CONTROLLER A35 2900.00 45 78 4 20 78 9 15 212 324 |
| ASYNC EXTENSION A36 4300.00 45 78 4 20 78 9 15 212 324 |
| POWER MODULE H76 2400.06 45 78 4 20 78 9 15 212 324 |
| SYSTEM 192KB SEMI B78 87000.00 48 78 5 12 78 10 10 225 3333 |
| PROC 96KB SEMI A21 22000.00 48 78 5 12 78 10 10 225 3333 |
| DECIMAL ARITH X10 1500.00 48 78 5 12 78 10 10 225 3333 |
| ENSCRIBE MICRO X11 1000.00 48 78 5 12 78 10 10 225 3333 |
| COBOL MICRO X12 500.00 48 78 5 12 78 10 10 225 3333 |
| MEM MOD 96K MOS J88 9600.00 48 78 5 12 78 10 10 225 3333 |
| DISC CONT DUAL H87 10500.00 48 78 5 12 78 10 10 225 3333 |
| LINE PRINTER CONT K94 2800.00 48 78 5 12 78 10 10 225 3333 |
| DISK 160MB K43 24500.00 48 78 5 12 78 10 10 225 3333 |
| MAG TAPE DR 8/16 L98 8000.00 48 78 5 12 78 10 10 225 3333 |
| LP 900 LPM L88 21000.00 48 78 5 12 78 10 10 225 3333 |
| SYNC CONTROLLER A34 5800.00 48 78 5 12 78 10 10 225 3333 |
| ASYNC EXTENSION A36 4300.00 48 78 5 12 78 10 10 225 3333 |
| CABINET LARGE F76 68000.05 48 78 5 12 78 10 10 225 3333 |
| POWER MODULE H76 2400.06 48 78 5 12 78 10 10 225 3333 |
| PROC 96KB SEMI A21 22000.00 51 78 6 1 78 10 20 210 143 |
| DECIMAL ARITH X10 1500.00 51 78 6 1 78 10 20 210 143 |
| ENSCRIBE MICRO X11 1000.00 51 78 6 1 78 10 20 210 143 |
| COBOL MICRO X12 500.00 51 78 6 1 78 10 20 210 143 |
| MEM MOD 96K MOS J88 9600.00 51 78 6 1 78 10 20 210 143 |
| DISC CONT DUAL H87 10500.00 51 78 6 1 78 10 20 210 143 |
| LINE PRINTER CONT K94 2800.00 51 78 6 1 78 10 20 210 143 |
| DISK 160MB K43 24500.00 51 78 6 1 78 10 20 210 143 |
| MAG TAPE DR 8/16 L98 8000.00 51 78 6 1 78 10 20 210 143 |
| LP 1500LPM L78 42000.00 51 78 6 1 78 10 20 210 143 |
| ASYNC CONTROLLER A35 2900.00 51 78 6 1 78 10 20 210 143 |
| ASYNC EXTENSION A36 4300.00 51 78 6 1 78 10 20 210 143 |
| TERM CRT PAGE V68 1500.00 51 78 6 1 78 10 20 210 143 |
| CABINET LARGE F76 68000.05 51 78 6 1 78 10 20 210 143 |
| SYSTEM 192KB SEMI B78 87000.00 66 78 7 9 78 11 1 205 3210 |
| PROC 96KB SEMI A21 22000.00 66 78 7 9 78 11 1 205 3210 |
| DECIMAL ARITH X10 1500.00 66 78 7 9 78 11 1 205 3210 |
| MEM MOD 96K MOS J88 9600.00 66 78 7 9 78 11 1 205 3210 |
| DISC CONT SINGLE H76 4800.00 66 78 7 9 78 11 1 205 3210 |
| LINE PRINTER CONT K94 2800.00 66 78 7 9 78 11 1 205 3210 |
| DISC 10MB K87 8000.00 66 78 7 9 78 11 1 205 3210 |
| DISC 50MB K45 14500.00 66 78 7 9 78 11 1 205 3210 |
| DISK 160MB K43 24500.00 66 78 7 9 78 11 1 205 3210 |
| MAG TAPE DR 800BPI K89 7400.00 66 78 7 9 78 11 1 205 3210 |
| LP 300 LPM L98 11500.00 66 78 7 9 78 11 1 205 3210 |
| LP 900 LPM L88 21000.00 66 78 7 9 78 11 1 205 3210 |
| SYNC CONTROLLER A34 5800.00 66 78 7 9 78 11 1 205 3210 |
| ASYNC CONTROLLER A35 2900.00 66 78 7 9 78 11 1 205 3210 |
| ASYNC EXTENSION A36 4300.00 66 78 7 9 78 11 1 205 3210 |
| TERM CRT CHAR V67 1500.00 66 78 7 9 78 11 1 205 3210 |
| TERM CRT PAGE V68 1500.00 66 78 7 9 78 11 1 205 3210 |
| CABINET LARGE F76 68000.05 66 78 7 9 78 11 1 205 3210 |
| POWER MODULE H76 2400.06 66 78 7 9 78 11 1 205 3210 |
| PROC 96KB SEMI A21 22000.00 122 78 7 21 78 12 15 221 5635 |
| ENSCRIBE MICRO X11 1000.00 122 78 7 21 78 12 15 221 5635 |
| MEM MOD 96K MOS J88 9600.00 122 78 7 21 78 12 15 221 5635 |
| DISC CONT DUAL H87 10500.00 122 78 7 21 78 12 15 221 5635 |
| MAG TAPE CONT 8/16 J65 4800.00 122 78 7 21 78 12 15 221 5635 |
| DISK 160MB K43 24500.00 122 78 7 21 78 12 15 221 5635 |
| MAG TAPE DR 8/16 L98 8000.00 122 78 7 21 78 12 15 221 5635 |
| CABINET LARGE F76 68000.05 122 78 7 21 78 12 15 221 5635 |
| POWER MODULE H76 2400.06 122 78 7 21 78 12 15 221 5635 |
| |
| --- 124 row(s) selected. |
| >> SELECT * FROM salecust ; |
| |
| EMPNAME REGNUM BRANCHNUM CUSTNAME ADDRESS CITY STATE |
| ------------------ ------ --------- ------------------ ---------------------- -------------- ------------ |
| |
| GEORGE FORSTER 1 2 DATASPEED 300 SAN GABRIEL WAY NEW YORK NEW YORK |
| JONATHAN MITCHEL 3 1 SLEEPWELL HOTELS 9000 PETERS AVENUE DALLAS TEXAS |
| MARTIN SCHAEFER 5 1 METALL-AG. 12 WAGNERRING FRANKFURT GERMANY |
| TOM HALL 1 1 CENTRAL UNIVERSITY UNIVERSITY WAY PHILADELPHIA PENN |
| HERB ALBERT 99 1 FRESNO STATE BANK 2300 BROWN BLVD FRESNO CALIFORNIA |
| GEORGE FRENCHMAN 3 3 BROWN MEDICAL CO 100 CALIFORNIA STREET SAN FRANCISCO CALIFORNIA |
| MARK FOLEY 2 1 MOTOR DISTRIBUTING 2345 FIRST STREET CHICAGO ILLINOIS |
| JONATHAN MITCHEL 3 1 PREMIER INSURANCE 3300 WARBASH LUBBOCK TEXAS |
| KARL HELMSTED 5 2 DEUTSCHE STAHL SIEMENS-STRASSE DUISBURG GERMANY |
| RICHARD BARTON 2 2 STEVENS SUPPLY 2020 HARRIS STREET DENVER COLORADO |
| GEORGE FORSTER 1 2 BESTFOOD MARKETS 3333 PLELPS STREET LINCOLN NEBRASKA |
| OTTO SCHNABL 5 1 VEREINIGTE CHEMIE 45 FRANKENSTRASSE MUENCHEN GERMANY |
| |
| --- 12 row(s) selected. |
| >> SELECT * FROM salecub ; |
| |
| EMPNAME BRANCHNAME CUSTNAME CITY |
| ------------------ -------------- ------------------ -------------- |
| |
| TOM HALL NEW YORK CENTRAL UNIVERSITY PHILADELPHIA |
| GEORGE FORSTER NEW JERSEY BESTFOOD MARKETS LINCOLN |
| GEORGE FORSTER NEW JERSEY DATASPEED NEW YORK |
| MARK FOLEY CHICAGO MOTOR DISTRIBUTING CHICAGO |
| RICHARD BARTON HOUSTON STEVENS SUPPLY DENVER |
| JONATHAN MITCHEL DALLAS PREMIER INSURANCE LUBBOCK |
| JONATHAN MITCHEL DALLAS SLEEPWELL HOTELS DALLAS |
| GEORGE FRENCHMAN SAN FRANCISCO BROWN MEDICAL CO SAN FRANCISCO |
| OTTO SCHNABL FRANKFURT VEREINIGTE CHEMIE MUENCHEN |
| MARTIN SCHAEFER FRANKFURT METALL-AG. FRANKFURT |
| KARL HELMSTED DUESSELDORF DEUTSCHE STAHL DUISBURG |
| HERB ALBERT CUPERTINO FRESNO STATE BANK FRESNO |
| |
| --- 12 row(s) selected. |
| >> SELECT * FROM fsdetail ; |
| |
| COL_1 COL_2 COL_3 COL_4 COL_5 COL_6 |
| ----- ----- ----------- ----- ----- ----- |
| |
| 6402 2 1100.00 66 6402 22 |
| 6402 3 1200.00 66 6402 22 |
| 2403 1 9600.00 122 2403 30 |
| 4103 6 20100.00 122 4103 40 |
| 4103 8 19300.00 122 4103 40 |
| 4103 15 19500.00 122 4103 40 |
| |
| --- 6 row(s) selected. |
| >>--------------------------------------------------------------------- |
| >>LOG; |
