>>---------------------------------------------------------------------
>>-- 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;
