trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ansha...@apache.org
Subject [03/12] incubator-trafodion git commit: JIRA TRAFODION-2834 Streamline supported xn access modes
Date Wed, 13 Dec 2017 19:02:25 GMT
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/eqatdml08
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml08 b/core/sql/regress/qat/eqatdml08
index a6e9e08..ef51159 100755
--- a/core/sql/regress/qat/eqatdml08
+++ b/core/sql/regress/qat/eqatdml08
@@ -35,8 +35,8 @@
 >>--      testcase A2: quantified comparison operators: >=ANY,=ALL,etc.
 >>--      testcase A3: multiple nested subqueries and multiple subqueries
 >>--                   connected with AND,OR
->>--      testcase A4: subqueries with for browse access, for stable access,
->>--                   for repeatable access
+>>--      testcase A4: subqueries with for read committed access, for read committed access,
+>>--                   for read committed access
 >>--      testcase A5: SELECT aggregate functions with aggregates in
 >>--                   subquery
 >>
@@ -1778,8 +1778,8 @@ AGE
 >>
 >>-- <detail>
 >>--    uncorrelated subquery in where clause test - this tests the use of
->>--    for browse access, for stable access, and
->>--    for repeatable access in uncorrelated subqueries.
+>>--    for read committed access, for read committed access, and
+>>--    for read committed access in uncorrelated subqueries.
 >>
 >>-- <templates>
 >>--     US00
@@ -1793,9 +1793,9 @@ AGE
 +>        (select Y.partnum
 +>         from fromsup Y
 +>         where suppnum = 15
-+>         for browse access
++>         for read committed access
 +>        )
-+>      for repeatable access;
++>      for read committed access;
 
 SUPPNUM
 -------
@@ -1817,7 +1817,7 @@ SUPPNUM
 +>         from odetail,parts
 +>         where  odetail.partnum =  parts.partnum
 +>         and price > 50000
-+>         for repeatable access
++>         for read committed access
 +>        );
 
 SALESMAN  ORDERNUM
@@ -1847,9 +1847,9 @@ SALESMAN  ORDERNUM
 +>        (select Y.state
 +>         from supplier Y
 +>         where suppnum = 1
-+>         for browse access
++>         for read committed access
 +>        )
-+>      for repeatable access;
++>      for read committed access;
 
 SUPPNUM
 -------
@@ -1870,7 +1870,7 @@ SUPPNUM
 +>        (select col_12
 +>         from partsfor
 +>         where col_2 = 'V67'
-+>         for browse access
++>         for read committed access
 +>        );
 
 CUSTNAME          
@@ -1900,7 +1900,7 @@ VEREINIGTE CHEMIE
 +>         where ( orders.ordernum =  odetail.ordernum) and
 +>              ( odetail.partnum =  parts.partnum) and
 +>              (location = 'V67')
-+>         for repeatable access
++>         for read committed access
 +>        );
 
 CUSTNAME          
@@ -1929,13 +1929,13 @@ VEREINIGTE CHEMIE
 +>        (select suppnum
 +>         from fromsup
 +>         where partnum = 4102
-+>         for browse access
++>         for read committed access
 +>        )
 +>      and suppnum =ANY
 +>        (select suppnum
 +>         from fromsup
 +>         where partnum = 5504
-+>         for stable access
++>         for read committed access
 +>        );
 
 SUPPNAME          
@@ -1959,11 +1959,11 @@ DATADRIVE
 +>           (select partnum
 +>            from parts
 +>            where inventory < 0
-+>            for browse access
++>            for read committed access
 +>           )
-+>         for repeatable access
++>         for read committed access
 +>        )
-+>      for stable access;
++>      for read committed access;
 
 SUPPNAME          
 ------------------
@@ -1987,11 +1987,11 @@ TANDEM COMPUTERS
 +>         where Y.age <= ALL
 +>           (select Z.age
 +>            from employee Z
-+>            for repeatable access
++>            for read committed access
 +>           )
-+>         for stable access
++>         for read committed access
 +>        )
-+>      for browse access;
++>      for read committed access;
 
 AGE
 ---
@@ -2018,11 +2018,11 @@ AGE
 +>          (select distinct price
 +>           from parts
 +>           where price = 8000
-+>           for browse access
++>           for read committed access
 +>          )
-+>         for repeatable access
++>         for read committed access
 +>        )
-+>      for stable access;
++>      for read committed access;
 
 SALESMAN
 --------
@@ -2052,11 +2052,11 @@ SALESMAN
 +>           (select regnum
 +>            from region
 +>            where regname = 'Central'
-+>            for stable access
++>            for read committed access
 +>           )
-+>         for repeatable access
++>         for read committed access
 +>        )
-+>      for browse access;
++>      for read committed access;
 
 --- 0 row(s) selected.
 >>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/eqatdml09
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml09 b/core/sql/regress/qat/eqatdml09
index 04c6e71..e24a4e4 100755
--- a/core/sql/regress/qat/eqatdml09
+++ b/core/sql/regress/qat/eqatdml09
@@ -36,8 +36,8 @@
 >>--                    connected with AND,OR, and SELECTs with subqueries
 >>--                    (uncorrelated) in both the WHERE clause and HAVING
 >>--                    clause
->>--       testcase A4: subqueries with for browse access,
->>--                    for stable access, for repeatable access
+>>--       testcase A4: subqueries with for read committed access,
+>>--                    for read committed access, for read committed access
 >>--       testcase A5: SELECT aggregate functions with aggregates in
 >>--                    subquery
 >>
@@ -1905,10 +1905,10 @@ SUPPNUM
 SUPPNUM
 -------
 
-      1
+     15
       3
       6
-     15
+      1
 
 --- 4 row(s) selected.
 >>
@@ -1950,8 +1950,8 @@ AGE
 >>
 >>-- <detail>
 >>--    uncorrelated subquery in having clause test - this tests the use of
->>--    for browse access, for stable access,
->>--    and for repeatable access in uncorrelated subqueries.
+>>--    for read committed access, for read committed access,
+>>--    and for read committed access in uncorrelated subqueries.
 >>
 >>
 >>-- <templates>
@@ -1968,9 +1968,9 @@ AGE
 +>        (select partnum
 +>         from fromsup
 +>         where suppnum = 15
-+>         for browse access
++>         for read committed access
 +>        )
-+>      for repeatable access;
++>      for read committed access;
 
 PARTNUM
 -------
@@ -1996,7 +1996,7 @@ PARTNUM
 +>         from odetail,parts
 +>         where  odetail.partnum =  parts.partnum
 +>         and price > 50000
-+>         for repeatable access
++>         for read committed access
 +>        );
 
 SALESMAN  ORDERNUM
@@ -2026,9 +2026,9 @@ SALESMAN  ORDERNUM
 +>        (select Y.state
 +>         from supplier Y
 +>         where suppnum = 1
-+>         for browse access
++>         for read committed access
 +>        )
-+>      for repeatable access;
++>      for read committed access;
 
 SUPPNUM
 -------
@@ -2050,7 +2050,7 @@ SUPPNUM
 +>        (select col_12
 +>         from partsfor
 +>         where col_2 = 'V67'
-+>         for browse access
++>         for read committed access
 +>        );
 
 CUSTNUM
@@ -2081,7 +2081,7 @@ CUSTNUM
 +>         where ( orders.ordernum =  odetail.ordernum) and
 +>               ( odetail.partnum =  parts.partnum) and
 +>               (location = 'V67')
-+>                for repeatable access
++>                for read committed access
 +>        );
 
 CUSTNUM
@@ -2111,13 +2111,13 @@ CUSTNUM
 +>        (select suppnum
 +>         from fromsup
 +>         where partnum = 4102
-+>         for browse access)
++>         for read committed access)
 +>        )
 +>      and (suppnum =ANY
 +>        (select suppnum
 +>         from fromsup
 +>         where partnum = 5504
-+>         for stable access)
++>         for read committed access)
 +>        );
 
 SUPPNUM
@@ -2143,11 +2143,11 @@ SUPPNUM
 +>           (select partnum
 +>            from parts
 +>            where inventory < 0
-+>            for browse access
++>            for read committed access
 +>           )
-+>         for repeatable access
++>         for read committed access
 +>        )
-+>      for stable access;
++>      for read committed access;
 
 SUPPNUM
 -------
@@ -2173,11 +2173,11 @@ SUPPNUM
 +>         having Y.age <= ALL
 +>           (select Z.age
 +>            from employee Z
-+>            for repeatable access
++>            for read committed access
 +>           )
-+>         for stable access
++>         for read committed access
 +>        )
-+>      for browse access;
++>      for read committed access;
 
 AGE
 ---
@@ -2207,11 +2207,11 @@ AGE
 +>          (select distinct price
 +>           from parts
 +>           where price = 8000
-+>           for browse access
++>           for read committed access
 +>          )
-+>         for repeatable access
++>         for read committed access
 +>        )
-+>      for stable access;
++>      for read committed access;
 
 SALESMAN
 --------
@@ -2242,11 +2242,11 @@ SALESMAN
 +>           (select regnum
 +>            from region
 +>            where regname = 'CENTRAL'
-+>            for stable access
++>            for read committed access
 +>           )
-+>         for repeatable access
++>         for read committed access
 +>        )
-+>      for browse access;
++>      for read committed access;
 
 EMPNAME           
 ------------------

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/eqatdml10
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml10 b/core/sql/regress/qat/eqatdml10
index 8a85e8f..9f0195a 100755
--- a/core/sql/regress/qat/eqatdml10
+++ b/core/sql/regress/qat/eqatdml10
@@ -38,8 +38,8 @@
 >>--               EXISTS/NOT EXISTS
 >>--  testcase A4: multiple nesting,multiple subqueries connected with
 >>--               and/or,mixed correlated/uncorrelated nested subqueries
->>--  testcase A5: use of for browse access,
->>--               for stable access,for repeatable access
+>>--  testcase A5: use of for read committed access,
+>>--               for read committed access,for read committed access
 >>--  testcase A6: SELECT aggregate functions with aggregates in
 >>--               subquery
 >>
@@ -77,12 +77,12 @@
 +>         from fromsup
 +>         where  supplier.suppnum = suppnum);
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
-INFOMATION STORAGE  
-MAGNETICS CORP      
+DATADRIVE         
+INFOMATION STORAGE
+MAGNETICS CORP    
 
 --- 3 row(s) selected.
 >>
@@ -95,12 +95,12 @@ MAGNETICS CORP
 +>         from fromsup
 +>         where  supplier.suppnum =  fromsup.suppnum);
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
-INFOMATION STORAGE  
-MAGNETICS CORP      
+DATADRIVE         
+INFOMATION STORAGE
+MAGNETICS CORP    
 
 --- 3 row(s) selected.
 >>
@@ -113,13 +113,13 @@ MAGNETICS CORP
 +>         from fromsup
 +>         where  supplier.suppnum = suppnum);
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATA TERMINAL CO    
-DISPLAY INC         
-STEELWORK INC       
-TANDEM COMPUTERS    
+DATA TERMINAL CO  
+DISPLAY INC       
+STEELWORK INC     
+TANDEM COMPUTERS  
 
 --- 4 row(s) selected.
 >>
@@ -132,12 +132,12 @@ TANDEM COMPUTERS
 +>         from fromsup
 +>         where X.suppnum = suppnum);
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
-INFOMATION STORAGE  
-MAGNETICS CORP      
+DATADRIVE         
+INFOMATION STORAGE
+MAGNETICS CORP    
 
 --- 3 row(s) selected.
 >>
@@ -153,24 +153,24 @@ MAGNETICS CORP
 +>         group by partcost
 +>        );
 
-PARTNAME            
-------------------  
-
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DECIMAL ARITH       
-ENSCRIBE MICRO      
-COBOL MICRO         
-MEM MOD 64K MOS     
-MEM MOD 96K MOS     
-DISC CONT SINGLE    
-DISC CONT DUAL      
-MAG TAPE CONT 8/16  
-LINE PRINTER CONT   
-SYNC CONTROLLER     
-ASYNC CONTROLLER    
-ASYNC EXTENSION     
+PARTNAME          
+------------------
+
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DECIMAL ARITH     
+ENSCRIBE MICRO    
+COBOL MICRO       
+MEM MOD 64K MOS   
+MEM MOD 96K MOS   
+DISC CONT SINGLE  
+DISC CONT DUAL    
+MAG TAPE CONT 8/16
+LINE PRINTER CONT 
+SYNC CONTROLLER   
+ASYNC CONTROLLER  
+ASYNC EXTENSION   
 
 --- 15 row(s) selected.
 >>
@@ -186,24 +186,24 @@ ASYNC EXTENSION
 +>         having partcost <> 20100
 +>        );
 
-PARTNAME            
-------------------  
-
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DECIMAL ARITH       
-ENSCRIBE MICRO      
-COBOL MICRO         
-MEM MOD 64K MOS     
-MEM MOD 96K MOS     
-DISC CONT SINGLE    
-DISC CONT DUAL      
-MAG TAPE CONT 8/16  
-LINE PRINTER CONT   
-SYNC CONTROLLER     
-ASYNC CONTROLLER    
-ASYNC EXTENSION     
+PARTNAME          
+------------------
+
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DECIMAL ARITH     
+ENSCRIBE MICRO    
+COBOL MICRO       
+MEM MOD 64K MOS   
+MEM MOD 96K MOS   
+DISC CONT SINGLE  
+DISC CONT DUAL    
+MAG TAPE CONT 8/16
+LINE PRINTER CONT 
+SYNC CONTROLLER   
+ASYNC CONTROLLER  
+ASYNC EXTENSION   
 
 --- 15 row(s) selected.
 >>
@@ -218,24 +218,24 @@ ASYNC EXTENSION
 +>         where  parts.partnum =  fromsup.partnum
 +>        );
 
-PARTNAME            
-------------------  
-
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DECIMAL ARITH       
-ENSCRIBE MICRO      
-COBOL MICRO         
-MEM MOD 64K MOS     
-MEM MOD 96K MOS     
-DISC CONT SINGLE    
-DISC CONT DUAL      
-MAG TAPE CONT 8/16  
-LINE PRINTER CONT   
-SYNC CONTROLLER     
-ASYNC CONTROLLER    
-ASYNC EXTENSION     
+PARTNAME          
+------------------
+
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DECIMAL ARITH     
+ENSCRIBE MICRO    
+COBOL MICRO       
+MEM MOD 64K MOS   
+MEM MOD 96K MOS   
+DISC CONT SINGLE  
+DISC CONT DUAL    
+MAG TAPE CONT 8/16
+LINE PRINTER CONT 
+SYNC CONTROLLER   
+ASYNC CONTROLLER  
+ASYNC EXTENSION   
 
 --- 15 row(s) selected.
 >>
@@ -249,10 +249,10 @@ ASYNC EXTENSION
 +>         from empone
 +>         where  empone.empnum =  region.manager);
 
-REGNAME       
-------------  
+REGNAME     
+------------
 
-HEADQUARTERS  
+HEADQUARTERS
 
 --- 1 row(s) selected.
 >>
@@ -265,10 +265,10 @@ HEADQUARTERS
 +>         from empone
 +>         where empnum = manager);
 
-REGNAME       
-------------  
+REGNAME     
+------------
 
-HEADQUARTERS  
+HEADQUARTERS
 
 --- 1 row(s) selected.
 >>
@@ -282,17 +282,17 @@ HEADQUARTERS
 +>          where Y.suppnum <> X.suppnum
 +>         );
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -307,17 +307,17 @@ PARTNUM
 +>          where Y.suppnum <> X.suppnum
 +>         );
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -332,17 +332,17 @@ PARTNUM
 +>          group by Y.partnum
 +>         );
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -358,17 +358,17 @@ PARTNUM
 +>         )
 +>      group by X.partnum;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -384,17 +384,17 @@ PARTNUM
 +>         )
 +>      group by X.partnum;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -412,16 +412,16 @@ PARTNUM
 +>         )
 +>      group by X.partnum;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 7 row(s) selected.
 >>
@@ -438,16 +438,16 @@ PARTNUM
 +>      group by X.partnum
 +>      having X.partnum <> 4101;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 7 row(s) selected.
 >>
@@ -465,16 +465,16 @@ PARTNUM
 +>      group by X.partnum
 +>      having X.partnum <> 4101;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 7 row(s) selected.
 >>
@@ -489,17 +489,17 @@ PARTNUM
 +>        where ( odetail.partnum =  parts.partnum)
 +>        and ( orders.ordernum =  odetail.ordernum) );
 
-SALESMAN  ORDERNUM  
---------  --------  
+SALESMAN  ORDERNUM
+--------  --------
 
-     222        30  
-     204        32  
-     218        38  
-     207        41  
-     212        45  
-     225        48  
-     205        66  
-     221       122  
+     204        32
+     205        66
+     207        41
+     212        45
+     218        38
+     221       122
+     222        30
+     225        48
 
 --- 8 row(s) selected.
 >>
@@ -513,17 +513,17 @@ SALESMAN  ORDERNUM
 +>        where ( odetail.partnum =  parts.partnum)
 +>        and ( orders.ordernum =  odetail.ordernum) );
 
-SALESMAN  ORDERNUM  
---------  --------  
+SALESMAN  ORDERNUM
+--------  --------
 
-     222        30  
-     204        32  
-     218        38  
-     207        41  
-     212        45  
-     225        48  
-     205        66  
-     221       122  
+     204        32
+     205        66
+     207        41
+     212        45
+     218        38
+     221       122
+     222        30
+     225        48
 
 --- 8 row(s) selected.
 >>
@@ -539,17 +539,17 @@ SALESMAN  ORDERNUM
 +>         and ( orders.ordernum =  odetail.ordernum)
 +>         group by  parts.location );
 
-SALESMAN  ORDERNUM  
---------  --------  
+SALESMAN  ORDERNUM
+--------  --------
 
-     222        30  
-     204        32  
-     218        38  
-     207        41  
-     212        45  
-     225        48  
-     205        66  
-     221       122  
+     204        32
+     205        66
+     207        41
+     212        45
+     218        38
+     221       122
+     222        30
+     225        48
 
 --- 8 row(s) selected.
 >>
@@ -564,17 +564,17 @@ SALESMAN  ORDERNUM
 +>        and ( orders.ordernum =  odetail.ordernum) )
 +>     order by ordernum;
 
-SALESMAN  ORDERNUM  
---------  --------  
+SALESMAN  ORDERNUM
+--------  --------
 
-     222        30  
-     204        32  
-     218        38  
-     207        41  
-     212        45  
-     225        48  
-     205        66  
-     221       122  
+     222        30
+     204        32
+     218        38
+     207        41
+     212        45
+     225        48
+     205        66
+     221       122
 
 --- 8 row(s) selected.
 >>
@@ -590,13 +590,13 @@ SALESMAN  ORDERNUM
 +>        where  parts.partnum =  expfroms.partnum
 +>       );
 
-PARTNAME            
-------------------  
+PARTNAME          
+------------------
 
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DISC CONT DUAL      
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DISC CONT DUAL    
 
 --- 4 row(s) selected.
 >>
@@ -612,11 +612,11 @@ DISC CONT DUAL
 +>        where Y.ordernum < X.ordernum
 +>       );
 
-SALESMAN  
---------  
+SALESMAN
+--------
 
-     212  
-     205  
+     205
+     212
 
 --- 2 row(s) selected.
 >>
@@ -632,28 +632,28 @@ SALESMAN
 +>        group by branchnum
 +>       );
 
-EMPNAME             
-------------------  
-
-THOMAS RUDLOFF      
-KLAUS SAFFERT       
-PETER SMITH         
-DONALD TAYLOR       
-STEVE COOK          
-SHERRIE WONG        
-TONY CRAFT          
-GEORGE FORSTER      
-RICHARD BARTON      
-JIMMY SCHNEIDER     
-WALTER LANCASTER    
-JOHN JONES          
-MARLENE BONNY       
-GEORGE FRENCHMAN    
-DAVID TERRY         
-KARL HELMSTED       
-HEIDI WEIGL         
-XAVER SEDLMEYER     
-DAVE CLARK          
+EMPNAME           
+------------------
+
+THOMAS RUDLOFF    
+KLAUS SAFFERT     
+PETER SMITH       
+DONALD TAYLOR     
+STEVE COOK        
+SHERRIE WONG      
+TONY CRAFT        
+GEORGE FORSTER    
+RICHARD BARTON    
+JIMMY SCHNEIDER   
+WALTER LANCASTER  
+JOHN JONES        
+MARLENE BONNY     
+GEORGE FRENCHMAN  
+DAVID TERRY       
+KARL HELMSTED     
+HEIDI WEIGL       
+XAVER SEDLMEYER   
+DAVE CLARK        
 
 --- 19 row(s) selected.
 >>
@@ -666,28 +666,28 @@ DAVE CLARK
 +>        from branch
 +>        where  employee.branchnum =  branch.branchnum );
 
-EMPNAME             
-------------------  
-
-THOMAS RUDLOFF      
-KLAUS SAFFERT       
-PETER SMITH         
-DONALD TAYLOR       
-STEVE COOK          
-SHERRIE WONG        
-TONY CRAFT          
-GEORGE FORSTER      
-RICHARD BARTON      
-JIMMY SCHNEIDER     
-WALTER LANCASTER    
-JOHN JONES          
-MARLENE BONNY       
-GEORGE FRENCHMAN    
-DAVID TERRY         
-KARL HELMSTED       
-HEIDI WEIGL         
-XAVER SEDLMEYER     
-DAVE CLARK          
+EMPNAME           
+------------------
+
+THOMAS RUDLOFF    
+KLAUS SAFFERT     
+PETER SMITH       
+DONALD TAYLOR     
+STEVE COOK        
+SHERRIE WONG      
+TONY CRAFT        
+GEORGE FORSTER    
+RICHARD BARTON    
+JIMMY SCHNEIDER   
+WALTER LANCASTER  
+JOHN JONES        
+MARLENE BONNY     
+GEORGE FRENCHMAN  
+DAVID TERRY       
+KARL HELMSTED     
+HEIDI WEIGL       
+XAVER SEDLMEYER   
+DAVE CLARK        
 
 --- 19 row(s) selected.
 >>
@@ -703,28 +703,28 @@ DAVE CLARK
 +>        having branchnum =  employee.branchnum
 +>       );
 
-EMPNAME             
-------------------  
-
-THOMAS RUDLOFF      
-KLAUS SAFFERT       
-PETER SMITH         
-DONALD TAYLOR       
-STEVE COOK          
-SHERRIE WONG        
-TONY CRAFT          
-GEORGE FORSTER      
-RICHARD BARTON      
-JIMMY SCHNEIDER     
-WALTER LANCASTER    
-JOHN JONES          
-MARLENE BONNY       
-GEORGE FRENCHMAN    
-DAVID TERRY         
-KARL HELMSTED       
-HEIDI WEIGL         
-XAVER SEDLMEYER     
-DAVE CLARK          
+EMPNAME           
+------------------
+
+THOMAS RUDLOFF    
+KLAUS SAFFERT     
+PETER SMITH       
+DONALD TAYLOR     
+STEVE COOK        
+SHERRIE WONG      
+TONY CRAFT        
+GEORGE FORSTER    
+RICHARD BARTON    
+JIMMY SCHNEIDER   
+WALTER LANCASTER  
+JOHN JONES        
+MARLENE BONNY     
+GEORGE FRENCHMAN  
+DAVID TERRY       
+KARL HELMSTED     
+HEIDI WEIGL       
+XAVER SEDLMEYER   
+DAVE CLARK        
 
 --- 19 row(s) selected.
 >>
@@ -739,13 +739,13 @@ DAVE CLARK
 +>        where Y.partnum = X.partnum
 +>       );
 
-SUPPNUM  
--------  
+SUPPNUM
+-------
 
-      2  
-      6  
-      8  
-     15  
+      6
+     15
+      8
+      2
 
 --- 4 row(s) selected.
 >>
@@ -760,13 +760,13 @@ SUPPNUM
 +>        where Y.state = X.state
 +>       );
 
-SUPPNUM  
--------  
+SUPPNUM
+-------
 
-      1  
-      2  
-      3  
-     10  
+      1
+      2
+      3
+     10
 
 --- 4 row(s) selected.
 >>
@@ -781,20 +781,20 @@ SUPPNUM
 +>         where custnum = col_12
 +>        );
 
-CUSTNAME            
-------------------  
+CUSTNAME          
+------------------
 
-BROWN MEDICAL CO    
-CENTRAL UNIVERSITY  
-DATASPEED           
-DEUTSCHE STAHL      
-FRESNO STATE BANK   
-METALL-AG.          
-MOTOR DISTRIBUTING  
-PREMIER INSURANCE   
-SLEEPWELL HOTELS    
-STEVENS SUPPLY      
-VEREINIGTE CHEMIE   
+BROWN MEDICAL CO  
+CENTRAL UNIVERSITY
+DATASPEED         
+DEUTSCHE STAHL    
+FRESNO STATE BANK 
+METALL-AG.        
+MOTOR DISTRIBUTING
+PREMIER INSURANCE 
+SLEEPWELL HOTELS  
+STEVENS SUPPLY    
+VEREINIGTE CHEMIE 
 
 --- 11 row(s) selected.
 >>
@@ -823,10 +823,10 @@ VEREINIGTE CHEMIE
 +>         from region
 +>         where manager = empnum);
 
-EMPNAME             
-------------------  
+EMPNAME           
+------------------
 
-JACK RAYMOND        
+JACK RAYMOND      
 
 --- 1 row(s) selected.
 >>
@@ -840,10 +840,10 @@ JACK RAYMOND
 +>         from region
 +>         where  region.manager =   employee.empnum);
 
-EMPNAME             
-------------------  
+EMPNAME           
+------------------
 
-JACK RAYMOND        
+JACK RAYMOND      
 
 --- 1 row(s) selected.
 >>
@@ -857,19 +857,19 @@ JACK RAYMOND
 +>         where  customer.custnum =  partsfor.col_12
 +>        );
 
-CUSTNAME            
-------------------  
+CUSTNAME          
+------------------
 
-BESTFOOD MARKETS    
-BROWN MEDICAL CO    
-CENTRAL UNIVERSITY  
-DATASPEED           
-DEUTSCHE STAHL      
-FRESNO STATE BANK   
-METALL-AG.          
-MOTOR DISTRIBUTING  
-STEVENS SUPPLY      
-VEREINIGTE CHEMIE   
+BESTFOOD MARKETS  
+BROWN MEDICAL CO  
+CENTRAL UNIVERSITY
+DATASPEED         
+DEUTSCHE STAHL    
+FRESNO STATE BANK 
+METALL-AG.        
+MOTOR DISTRIBUTING
+STEVENS SUPPLY    
+VEREINIGTE CHEMIE 
 
 --- 10 row(s) selected.
 >>
@@ -884,19 +884,19 @@ VEREINIGTE CHEMIE
 +>               ( odetail.partnum =  parts.partnum) and
 +>               ( customer.custnum =  orders.custnum) );
 
-CUSTNAME            
-------------------  
+CUSTNAME          
+------------------
 
-BESTFOOD MARKETS    
-BROWN MEDICAL CO    
-CENTRAL UNIVERSITY  
-DATASPEED           
-DEUTSCHE STAHL      
-FRESNO STATE BANK   
-METALL-AG.          
-MOTOR DISTRIBUTING  
-STEVENS SUPPLY      
-VEREINIGTE CHEMIE   
+BESTFOOD MARKETS  
+BROWN MEDICAL CO  
+CENTRAL UNIVERSITY
+DATASPEED         
+DEUTSCHE STAHL    
+FRESNO STATE BANK 
+METALL-AG.        
+MOTOR DISTRIBUTING
+STEVENS SUPPLY    
+VEREINIGTE CHEMIE 
 
 --- 10 row(s) selected.
 >>
@@ -912,30 +912,30 @@ VEREINIGTE CHEMIE
 +>         group by partcost
 +>        );
 
-PARTNAME            
-------------------  
-
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DECIMAL ARITH       
-ENSCRIBE MICRO      
-COBOL MICRO         
-MEM MOD 64K MOS     
-MEM MOD 96K MOS     
-DISC CONT SINGLE    
-DISC CONT DUAL      
-MAG TAPE CONT 8/16  
-LINE PRINTER CONT   
-MAG TAPE DR 800BPI  
-MAG TAPE DR 8/16    
-SYNC CONTROLLER     
-ASYNC CONTROLLER    
-ASYNC EXTENSION     
-TERM CRT CHAR       
-TERM CRT PAGE       
-TERM HARD COPY      
-POWER MODULE        
+PARTNAME          
+------------------
+
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DECIMAL ARITH     
+ENSCRIBE MICRO    
+COBOL MICRO       
+MEM MOD 64K MOS   
+MEM MOD 96K MOS   
+DISC CONT SINGLE  
+DISC CONT DUAL    
+MAG TAPE CONT 8/16
+LINE PRINTER CONT 
+MAG TAPE DR 800BPI
+MAG TAPE DR 8/16  
+SYNC CONTROLLER   
+ASYNC CONTROLLER  
+ASYNC EXTENSION   
+TERM CRT CHAR     
+TERM CRT PAGE     
+TERM HARD COPY    
+POWER MODULE      
 
 --- 21 row(s) selected.
 >>
@@ -950,36 +950,36 @@ POWER MODULE
 +>         where X.col_1 <> Y.col_1
 +>        );
 
-COL_1               
-------------------  
-
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-MAG TAPE CONT 8/16  
-DISC 10MB           
-DISC 10MB           
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-TERM CRT CHAR       
-TERM CRT PAGE       
-TERM CRT PAGE       
-TERM CRT PAGE       
-TERM CRT PAGE       
+COL_1             
+------------------
+
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+MAG TAPE CONT 8/16
+DISC 10MB         
+DISC 10MB         
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+TERM CRT CHAR     
+TERM CRT PAGE     
+TERM CRT PAGE     
+TERM CRT PAGE     
+TERM CRT PAGE     
 
 --- 27 row(s) selected.
 >>
@@ -998,21 +998,21 @@ TERM CRT PAGE
 +>         and X.partnum = Y.partnum
 +>        );
 
-SUPPNUM  PARTNUM  
--------  -------  
+SUPPNUM  PARTNUM
+-------  -------
 
-      6     4101  
-     15     4101  
-      6     4102  
-     15     4102  
-      8     4103  
-     15     4103  
-      8     5101  
-      8     5103  
-      2     5504  
-      6     5504  
-      3     6401  
-      2     6402  
+      6     4101
+     15     4101
+      6     4102
+     15     4102
+      8     4103
+     15     4103
+      8     5101
+      8     5103
+      2     5504
+      6     5504
+      3     6401
+      2     6402
 
 --- 12 row(s) selected.
 >>
@@ -1027,21 +1027,21 @@ SUPPNUM  PARTNUM
 +>         and X.partnum = Y.partnum
 +>        );
 
-SUPPNUM  PARTNUM  
--------  -------  
+SUPPNUM  PARTNUM
+-------  -------
 
-      6     4101  
-     15     4101  
-      6     4102  
-     15     4102  
-      8     4103  
-     15     4103  
-      8     5101  
-      8     5103  
-      2     5504  
-      6     5504  
-      3     6401  
-      2     6402  
+      6     4101
+     15     4101
+      6     4102
+     15     4102
+      8     4103
+     15     4103
+      8     5101
+      8     5103
+      2     5504
+      6     5504
+      3     6401
+      2     6402
 
 --- 12 row(s) selected.
 >>
@@ -1056,36 +1056,36 @@ SUPPNUM  PARTNUM
 +>         and X.partnum = Y.partnum
 +>        );
 
-SUPPNUM  PARTNUM  
--------  -------  
-
-      1      212  
-      1      244  
-      1     1403  
-      1     2001  
-      1     2002  
-      1     2003  
-      1     2402  
-      1     2403  
-      1     3102  
-      1     3103  
-      1     3201  
-      1     3302  
-      6     4102  
-      8     4103  
-      8     5101  
-      8     5103  
-      2     5502  
-      6     5504  
-     15     5505  
-      1     6201  
-      1     6301  
-      1     6302  
-      3     6401  
-      2     6402  
-      2     6603  
-     10     7102  
-      1     7301  
+SUPPNUM  PARTNUM
+-------  -------
+
+      1      212
+      1      244
+      1     1403
+      1     2001
+      1     2002
+      1     2003
+      1     2402
+      1     2403
+      1     3102
+      1     3103
+      1     3201
+      1     3302
+      6     4102
+      8     4103
+      8     5101
+      8     5103
+      2     5502
+      6     5504
+     15     5505
+      1     6201
+      1     6301
+      1     6302
+      3     6401
+      2     6402
+      2     6603
+     10     7102
+      1     7301
 
 --- 27 row(s) selected.
 >>
@@ -1102,12 +1102,12 @@ SUPPNUM  PARTNUM
 +>         and (Y.suppnum = 15)
 +>        );
 
-SUPPNUM  
--------  
+SUPPNUM
+-------
 
-      2  
-      6  
-      8  
+      6
+      8
+      2
 
 --- 3 row(s) selected.
 >>
@@ -1121,13 +1121,13 @@ SUPPNUM
 +>         where X.state = Y.state
 +>        );
 
-SUPPNUM  
--------  
+SUPPNUM
+-------
 
-      1  
-      2  
-      3  
-     10  
+      1
+      2
+      3
+     10
 
 --- 4 row(s) selected.
 >>
@@ -1140,12 +1140,12 @@ SUPPNUM
 +>         from fromsup
 +>         where  supplier.suppnum = suppnum);
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
-INFOMATION STORAGE  
-MAGNETICS CORP      
+DATADRIVE         
+INFOMATION STORAGE
+MAGNETICS CORP    
 
 --- 3 row(s) selected.
 >>
@@ -1158,12 +1158,12 @@ MAGNETICS CORP
 +>         from fromsup
 +>         where  supplier.suppnum =  fromsup.suppnum);
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
-INFOMATION STORAGE  
-MAGNETICS CORP      
+DATADRIVE         
+INFOMATION STORAGE
+MAGNETICS CORP    
 
 --- 3 row(s) selected.
 >>
@@ -1176,16 +1176,16 @@ MAGNETICS CORP
 +>         from fromsup
 +>         where  supplier.suppnum = suppnum);
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATA TERMINAL CO    
-DATADRIVE           
-DISPLAY INC         
-INFOMATION STORAGE  
-MAGNETICS CORP      
-STEELWORK INC       
-TANDEM COMPUTERS    
+DATA TERMINAL CO  
+DATADRIVE         
+DISPLAY INC       
+INFOMATION STORAGE
+MAGNETICS CORP    
+STEELWORK INC     
+TANDEM COMPUTERS  
 
 --- 7 row(s) selected.
 >>
@@ -1198,12 +1198,12 @@ TANDEM COMPUTERS
 +>         from fromsup
 +>         where X.suppnum = suppnum);
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
-INFOMATION STORAGE  
-MAGNETICS CORP      
+DATADRIVE         
+INFOMATION STORAGE
+MAGNETICS CORP    
 
 --- 3 row(s) selected.
 >>
@@ -1219,24 +1219,24 @@ MAGNETICS CORP
 +>         group by partcost
 +>        );
 
-PARTNAME            
-------------------  
-
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DECIMAL ARITH       
-ENSCRIBE MICRO      
-COBOL MICRO         
-MEM MOD 64K MOS     
-MEM MOD 96K MOS     
-DISC CONT SINGLE    
-DISC CONT DUAL      
-MAG TAPE CONT 8/16  
-LINE PRINTER CONT   
-SYNC CONTROLLER     
-ASYNC CONTROLLER    
-ASYNC EXTENSION     
+PARTNAME          
+------------------
+
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DECIMAL ARITH     
+ENSCRIBE MICRO    
+COBOL MICRO       
+MEM MOD 64K MOS   
+MEM MOD 96K MOS   
+DISC CONT SINGLE  
+DISC CONT DUAL    
+MAG TAPE CONT 8/16
+LINE PRINTER CONT 
+SYNC CONTROLLER   
+ASYNC CONTROLLER  
+ASYNC EXTENSION   
 
 --- 15 row(s) selected.
 >>
@@ -1252,24 +1252,24 @@ ASYNC EXTENSION
 +>         having partcost <> 20100
 +>        );
 
-PARTNAME            
-------------------  
-
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DECIMAL ARITH       
-ENSCRIBE MICRO      
-COBOL MICRO         
-MEM MOD 64K MOS     
-MEM MOD 96K MOS     
-DISC CONT SINGLE    
-DISC CONT DUAL      
-MAG TAPE CONT 8/16  
-LINE PRINTER CONT   
-SYNC CONTROLLER     
-ASYNC CONTROLLER    
-ASYNC EXTENSION     
+PARTNAME          
+------------------
+
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DECIMAL ARITH     
+ENSCRIBE MICRO    
+COBOL MICRO       
+MEM MOD 64K MOS   
+MEM MOD 96K MOS   
+DISC CONT SINGLE  
+DISC CONT DUAL    
+MAG TAPE CONT 8/16
+LINE PRINTER CONT 
+SYNC CONTROLLER   
+ASYNC CONTROLLER  
+ASYNC EXTENSION   
 
 --- 15 row(s) selected.
 >>
@@ -1284,24 +1284,24 @@ ASYNC EXTENSION
 +>         where  parts.partnum =  fromsup.partnum
 +>        );
 
-PARTNAME            
-------------------  
-
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DECIMAL ARITH       
-ENSCRIBE MICRO      
-COBOL MICRO         
-MEM MOD 64K MOS     
-MEM MOD 96K MOS     
-DISC CONT SINGLE    
-DISC CONT DUAL      
-MAG TAPE CONT 8/16  
-LINE PRINTER CONT   
-SYNC CONTROLLER     
-ASYNC CONTROLLER    
-ASYNC EXTENSION     
+PARTNAME          
+------------------
+
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DECIMAL ARITH     
+ENSCRIBE MICRO    
+COBOL MICRO       
+MEM MOD 64K MOS   
+MEM MOD 96K MOS   
+DISC CONT SINGLE  
+DISC CONT DUAL    
+MAG TAPE CONT 8/16
+LINE PRINTER CONT 
+SYNC CONTROLLER   
+ASYNC CONTROLLER  
+ASYNC EXTENSION   
 
 --- 15 row(s) selected.
 >>
@@ -1315,10 +1315,10 @@ ASYNC EXTENSION
 +>         from empone
 +>         where  empone.empnum =  region.manager);
 
-REGNAME       
-------------  
+REGNAME     
+------------
 
-HEADQUARTERS  
+HEADQUARTERS
 
 --- 1 row(s) selected.
 >>
@@ -1331,10 +1331,10 @@ HEADQUARTERS
 +>         from empone
 +>         where empnum = manager);
 
-REGNAME       
-------------  
+REGNAME     
+------------
 
-HEADQUARTERS  
+HEADQUARTERS
 
 --- 1 row(s) selected.
 >>
@@ -1348,17 +1348,17 @@ HEADQUARTERS
 +>          where Y.suppnum <> X.suppnum
 +>         );
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -1373,17 +1373,17 @@ PARTNUM
 +>          where Y.suppnum <> X.suppnum
 +>         );
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -1398,17 +1398,17 @@ PARTNUM
 +>          group by Y.partnum
 +>         );
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -1424,17 +1424,17 @@ PARTNUM
 +>         )
 +>      group by X.partnum;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -1450,17 +1450,17 @@ PARTNUM
 +>         )
 +>      group by X.partnum;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -1478,16 +1478,16 @@ PARTNUM
 +>         )
 +>      group by X.partnum;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 7 row(s) selected.
 >>
@@ -1504,16 +1504,16 @@ PARTNUM
 +>      group by X.partnum
 +>      having X.partnum <> 4101;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 7 row(s) selected.
 >>
@@ -1531,16 +1531,16 @@ PARTNUM
 +>      group by X.partnum
 +>      having X.partnum <> 4101;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 7 row(s) selected.
 >>
@@ -1555,17 +1555,17 @@ PARTNUM
 +>        where ( odetail.partnum =  parts.partnum)
 +>        and ( orders.ordernum =  odetail.ordernum) );
 
-SALESMAN  ORDERNUM  
---------  --------  
+SALESMAN  ORDERNUM
+--------  --------
 
-     222        30  
-     204        32  
-     218        38  
-     207        41  
-     212        45  
-     225        48  
-     205        66  
-     221       122  
+     204        32
+     205        66
+     207        41
+     212        45
+     218        38
+     221       122
+     222        30
+     225        48
 
 --- 8 row(s) selected.
 >>
@@ -1579,17 +1579,17 @@ SALESMAN  ORDERNUM
 +>        where ( odetail.partnum =  parts.partnum)
 +>        and ( orders.ordernum =  odetail.ordernum) );
 
-SALESMAN  ORDERNUM  
---------  --------  
+SALESMAN  ORDERNUM
+--------  --------
 
-     222        30  
-     204        32  
-     218        38  
-     207        41  
-     212        45  
-     225        48  
-     205        66  
-     221       122  
+     204        32
+     205        66
+     207        41
+     212        45
+     218        38
+     221       122
+     222        30
+     225        48
 
 --- 8 row(s) selected.
 >>
@@ -1605,17 +1605,17 @@ SALESMAN  ORDERNUM
 +>         and ( orders.ordernum =  odetail.ordernum)
 +>         group by  parts.location );
 
-SALESMAN  ORDERNUM  
---------  --------  
+SALESMAN  ORDERNUM
+--------  --------
 
-     222        30  
-     204        32  
-     218        38  
-     207        41  
-     212        45  
-     225        48  
-     205        66  
-     221       122  
+     204        32
+     205        66
+     207        41
+     212        45
+     218        38
+     221       122
+     222        30
+     225        48
 
 --- 8 row(s) selected.
 >>
@@ -1630,17 +1630,17 @@ SALESMAN  ORDERNUM
 +>        and ( orders.ordernum =  odetail.ordernum) )
 +>     order by  ordernum;
 
-SALESMAN  ORDERNUM  
---------  --------  
+SALESMAN  ORDERNUM
+--------  --------
 
-     222        30  
-     204        32  
-     218        38  
-     207        41  
-     212        45  
-     225        48  
-     205        66  
-     221       122  
+     222        30
+     204        32
+     218        38
+     207        41
+     212        45
+     225        48
+     205        66
+     221       122
 
 --- 8 row(s) selected.
 >>
@@ -1656,13 +1656,13 @@ SALESMAN  ORDERNUM
 +>        where  parts.partnum =  expfroms.partnum
 +>       );
 
-PARTNAME            
-------------------  
+PARTNAME          
+------------------
 
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DISC CONT DUAL      
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DISC CONT DUAL    
 
 --- 4 row(s) selected.
 >>
@@ -1678,11 +1678,11 @@ DISC CONT DUAL
 +>        where Y.ordernum < X.ordernum
 +>       );
 
-SALESMAN  
---------  
+SALESMAN
+--------
 
-     212  
-     205  
+     205
+     212
 
 --- 2 row(s) selected.
 >>
@@ -1698,28 +1698,28 @@ SALESMAN
 +>        group by branchnum
 +>       );
 
-EMPNAME             
-------------------  
-
-THOMAS RUDLOFF      
-KLAUS SAFFERT       
-PETER SMITH         
-DONALD TAYLOR       
-STEVE COOK          
-SHERRIE WONG        
-TONY CRAFT          
-GEORGE FORSTER      
-RICHARD BARTON      
-JIMMY SCHNEIDER     
-WALTER LANCASTER    
-JOHN JONES          
-MARLENE BONNY       
-GEORGE FRENCHMAN    
-DAVID TERRY         
-KARL HELMSTED       
-HEIDI WEIGL         
-XAVER SEDLMEYER     
-DAVE CLARK          
+EMPNAME           
+------------------
+
+THOMAS RUDLOFF    
+KLAUS SAFFERT     
+PETER SMITH       
+DONALD TAYLOR     
+STEVE COOK        
+SHERRIE WONG      
+TONY CRAFT        
+GEORGE FORSTER    
+RICHARD BARTON    
+JIMMY SCHNEIDER   
+WALTER LANCASTER  
+JOHN JONES        
+MARLENE BONNY     
+GEORGE FRENCHMAN  
+DAVID TERRY       
+KARL HELMSTED     
+HEIDI WEIGL       
+XAVER SEDLMEYER   
+DAVE CLARK        
 
 --- 19 row(s) selected.
 >>
@@ -1732,28 +1732,28 @@ DAVE CLARK
 +>        from branch
 +>        where  employee.branchnum =  branch.branchnum );
 
-EMPNAME             
-------------------  
-
-THOMAS RUDLOFF      
-KLAUS SAFFERT       
-PETER SMITH         
-DONALD TAYLOR       
-STEVE COOK          
-SHERRIE WONG        
-TONY CRAFT          
-GEORGE FORSTER      
-RICHARD BARTON      
-JIMMY SCHNEIDER     
-WALTER LANCASTER    
-JOHN JONES          
-MARLENE BONNY       
-GEORGE FRENCHMAN    
-DAVID TERRY         
-KARL HELMSTED       
-HEIDI WEIGL         
-XAVER SEDLMEYER     
-DAVE CLARK          
+EMPNAME           
+------------------
+
+THOMAS RUDLOFF    
+KLAUS SAFFERT     
+PETER SMITH       
+DONALD TAYLOR     
+STEVE COOK        
+SHERRIE WONG      
+TONY CRAFT        
+GEORGE FORSTER    
+RICHARD BARTON    
+JIMMY SCHNEIDER   
+WALTER LANCASTER  
+JOHN JONES        
+MARLENE BONNY     
+GEORGE FRENCHMAN  
+DAVID TERRY       
+KARL HELMSTED     
+HEIDI WEIGL       
+XAVER SEDLMEYER   
+DAVE CLARK        
 
 --- 19 row(s) selected.
 >>
@@ -1769,28 +1769,28 @@ DAVE CLARK
 +>        having branchnum =  employee.branchnum
 +>       );
 
-EMPNAME             
-------------------  
-
-THOMAS RUDLOFF      
-KLAUS SAFFERT       
-PETER SMITH         
-DONALD TAYLOR       
-STEVE COOK          
-SHERRIE WONG        
-TONY CRAFT          
-GEORGE FORSTER      
-RICHARD BARTON      
-JIMMY SCHNEIDER     
-WALTER LANCASTER    
-JOHN JONES          
-MARLENE BONNY       
-GEORGE FRENCHMAN    
-DAVID TERRY         
-KARL HELMSTED       
-HEIDI WEIGL         
-XAVER SEDLMEYER     
-DAVE CLARK          
+EMPNAME           
+------------------
+
+THOMAS RUDLOFF    
+KLAUS SAFFERT     
+PETER SMITH       
+DONALD TAYLOR     
+STEVE COOK        
+SHERRIE WONG      
+TONY CRAFT        
+GEORGE FORSTER    
+RICHARD BARTON    
+JIMMY SCHNEIDER   
+WALTER LANCASTER  
+JOHN JONES        
+MARLENE BONNY     
+GEORGE FRENCHMAN  
+DAVID TERRY       
+KARL HELMSTED     
+HEIDI WEIGL       
+XAVER SEDLMEYER   
+DAVE CLARK        
 
 --- 19 row(s) selected.
 >>
@@ -1805,14 +1805,14 @@ DAVE CLARK
 +>        where  empone.empnum =  region.manager
 +>       );
 
-REGNAME       
-------------  
+REGNAME     
+------------
 
-EAST          
-WEST          
-GERMANY       
-ENGLAND       
-HEADQUARTERS  
+EAST        
+WEST        
+GERMANY     
+ENGLAND     
+HEADQUARTERS
 
 --- 5 row(s) selected.
 >>
@@ -1827,21 +1827,21 @@ HEADQUARTERS
 +>         where custnum = col_12
 +>        );
 
-CUSTNAME            
-------------------  
+CUSTNAME          
+------------------
 
-BESTFOOD MARKETS    
-BROWN MEDICAL CO    
-CENTRAL UNIVERSITY  
-DATASPEED           
-DEUTSCHE STAHL      
-FRESNO STATE BANK   
-METALL-AG.          
-MOTOR DISTRIBUTING  
-PREMIER INSURANCE   
-SLEEPWELL HOTELS    
-STEVENS SUPPLY      
-VEREINIGTE CHEMIE   
+BESTFOOD MARKETS  
+BROWN MEDICAL CO  
+CENTRAL UNIVERSITY
+DATASPEED         
+DEUTSCHE STAHL    
+FRESNO STATE BANK 
+METALL-AG.        
+MOTOR DISTRIBUTING
+PREMIER INSURANCE 
+SLEEPWELL HOTELS  
+STEVENS SUPPLY    
+VEREINIGTE CHEMIE 
 
 --- 12 row(s) selected.
 >>
@@ -1870,12 +1870,12 @@ VEREINIGTE CHEMIE
 +>          and partnum = 4102
 +>         );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
-INFOMATION STORAGE  
-MAGNETICS CORP      
+DATADRIVE         
+INFOMATION STORAGE
+MAGNETICS CORP    
 
 --- 3 row(s) selected.
 >>
@@ -1890,12 +1890,12 @@ MAGNETICS CORP
 +>          and partnum = 4102
 +>         );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
-INFOMATION STORAGE  
-MAGNETICS CORP      
+DATADRIVE         
+INFOMATION STORAGE
+MAGNETICS CORP    
 
 --- 3 row(s) selected.
 >>
@@ -1910,13 +1910,13 @@ MAGNETICS CORP
 +>          and partnum = 4102
 +>         );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATA TERMINAL CO    
-DISPLAY INC         
-STEELWORK INC       
-TANDEM COMPUTERS    
+DATA TERMINAL CO  
+DISPLAY INC       
+STEELWORK INC     
+TANDEM COMPUTERS  
 
 --- 4 row(s) selected.
 >>
@@ -1932,10 +1932,10 @@ TANDEM COMPUTERS
 +>         and empnum = 1
 +>        );
 
-REGNAME       
-------------  
+REGNAME     
+------------
 
-HEADQUARTERS  
+HEADQUARTERS
 
 --- 1 row(s) selected.
 >>
@@ -1951,17 +1951,17 @@ HEADQUARTERS
 +>         and X.partnum = Y.partnum
 +>        );
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -1977,17 +1977,17 @@ PARTNUM
 +>         and ( orders.ordernum =  odetail.ordernum) and
 +>        ( parts.location = 'H76') );
 
-SALESMAN  ORDERNUM  
---------  --------  
+SALESMAN  ORDERNUM
+--------  --------
 
-     222        30  
-     204        32  
-     218        38  
-     207        41  
-     212        45  
-     225        48  
-     205        66  
-     221       122  
+     204        32
+     205        66
+     207        41
+     212        45
+     218        38
+     221       122
+     222        30
+     225        48
 
 --- 8 row(s) selected.
 >>
@@ -2003,13 +2003,13 @@ SALESMAN  ORDERNUM
 +>         and (price = partcost)
 +>        );
 
-PARTNAME            
-------------------  
+PARTNAME          
+------------------
 
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DISC CONT DUAL      
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DISC CONT DUAL    
 
 --- 4 row(s) selected.
 >>
@@ -2025,11 +2025,11 @@ DISC CONT DUAL
 +>         and (X.salesman = Y.salesman)
 +>        );
 
-SALESMAN  
---------  
+SALESMAN
+--------
 
-     212  
-     205  
+     205
+     212
 
 --- 2 row(s) selected.
 >>
@@ -2046,28 +2046,28 @@ SALESMAN
 +>         group by branchnum
 +>        );
 
-EMPNAME
+EMPNAME           
 ------------------
 
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PETER SMITH
-DONALD TAYLOR
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-GEORGE FORSTER
-RICHARD BARTON
-JIMMY SCHNEIDER
-WALTER LANCASTER
-JOHN JONES
-MARLENE BONNY
-GEORGE FRENCHMAN
-DAVID TERRY
-KARL HELMSTED
-HEIDI WEIGL
-XAVER SEDLMEYER
-DAVE CLARK
+THOMAS RUDLOFF    
+KLAUS SAFFERT     
+PETER SMITH       
+DONALD TAYLOR     
+STEVE COOK        
+SHERRIE WONG      
+TONY CRAFT        
+GEORGE FORSTER    
+RICHARD BARTON    
+JIMMY SCHNEIDER   
+WALTER LANCASTER  
+JOHN JONES        
+MARLENE BONNY     
+GEORGE FRENCHMAN  
+DAVID TERRY       
+KARL HELMSTED     
+HEIDI WEIGL       
+XAVER SEDLMEYER   
+DAVE CLARK        
 
 --- 19 row(s) selected.
 >>
@@ -2084,28 +2084,28 @@ DAVE CLARK
 +>         having branchnum = 1
 +>        );
 
-EMPNAME
+EMPNAME           
 ------------------
 
-THOMAS RUDLOFF
-KLAUS SAFFERT
-PETER SMITH
-DONALD TAYLOR
-STEVE COOK
-SHERRIE WONG
-TONY CRAFT
-GEORGE FORSTER
-RICHARD BARTON
-JIMMY SCHNEIDER
-WALTER LANCASTER
-JOHN JONES
-MARLENE BONNY
-GEORGE FRENCHMAN
-DAVID TERRY
-KARL HELMSTED
-HEIDI WEIGL
-XAVER SEDLMEYER
-DAVE CLARK
+THOMAS RUDLOFF    
+KLAUS SAFFERT     
+PETER SMITH       
+DONALD TAYLOR     
+STEVE COOK        
+SHERRIE WONG      
+TONY CRAFT        
+GEORGE FORSTER    
+RICHARD BARTON    
+JIMMY SCHNEIDER   
+WALTER LANCASTER  
+JOHN JONES        
+MARLENE BONNY     
+GEORGE FRENCHMAN  
+DAVID TERRY       
+KARL HELMSTED     
+HEIDI WEIGL       
+XAVER SEDLMEYER   
+DAVE CLARK        
 
 --- 19 row(s) selected.
 >>
@@ -2121,13 +2121,13 @@ DAVE CLARK
 +>         and (suppnum = 15)
 +>        );
 
-SUPPNUM  
--------  
+SUPPNUM
+-------
 
-      2  
-      6  
-      8  
-     15  
+      6
+     15
+      8
+      2
 
 --- 4 row(s) selected.
 >>
@@ -2143,13 +2143,13 @@ SUPPNUM
 +>         and (suppnum = 1)
 +>        );
 
-SUPPNUM  
--------  
+SUPPNUM
+-------
 
-      1  
-      2  
-      3  
-     10  
+      1
+      2
+      3
+     10
 
 --- 4 row(s) selected.
 >>
@@ -2165,20 +2165,20 @@ SUPPNUM
 +>         and (col_2 = 'V67')
 +>        );
 
-CUSTNAME            
-------------------  
+CUSTNAME          
+------------------
 
-BROWN MEDICAL CO    
-CENTRAL UNIVERSITY  
-DATASPEED           
-DEUTSCHE STAHL      
-FRESNO STATE BANK   
-METALL-AG.          
-MOTOR DISTRIBUTING  
-PREMIER INSURANCE   
-SLEEPWELL HOTELS    
-STEVENS SUPPLY      
-VEREINIGTE CHEMIE   
+BROWN MEDICAL CO  
+CENTRAL UNIVERSITY
+DATASPEED         
+DEUTSCHE STAHL    
+FRESNO STATE BANK 
+METALL-AG.        
+MOTOR DISTRIBUTING
+PREMIER INSURANCE 
+SLEEPWELL HOTELS  
+STEVENS SUPPLY    
+VEREINIGTE CHEMIE 
 
 --- 11 row(s) selected.
 >>
@@ -2212,10 +2212,10 @@ VEREINIGTE CHEMIE
 +>           ) 
 +>        );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
+DATADRIVE         
 
 --- 1 row(s) selected.
 >>
@@ -2236,10 +2236,10 @@ DATADRIVE
 +>           )
 +>        );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
+DATADRIVE         
 
 --- 1 row(s) selected.
 >>
@@ -2260,10 +2260,10 @@ DATADRIVE
 +>           )
 +>        );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
+DATADRIVE         
 
 --- 1 row(s) selected.
 >>
@@ -2284,11 +2284,11 @@ DATADRIVE
 +>           )
 +>        );
 
-SUPPNUM  
--------  
+SUPPNUM
+-------
 
-      6  
-     15  
+      6
+     15
 
 --- 2 row(s) selected.
 >>
@@ -2311,11 +2311,11 @@ SUPPNUM
 +>        )
 +>      group by suppnum;
 
-SUPPNUM  
--------  
+SUPPNUM
+-------
 
-      6  
-     15  
+      6
+     15
 
 --- 2 row(s) selected.
 >>
@@ -2343,21 +2343,21 @@ SUPPNUM
 +>           )
 +>        );
 
-CUSTNUM  
--------  
+CUSTNUM
+-------
 
-   1234  
-   7777  
-    926  
-     21  
-    543  
-    123  
-   7654  
-    324  
-   3333  
-    143  
-   3210  
-   5635  
+     21
+    123
+    143
+    324
+    543
+    926
+   1234
+   3210
+   3333
+   5635
+   7654
+   7777
 
 --- 12 row(s) selected.
 >>
@@ -2384,21 +2384,21 @@ CUSTNUM
 +>           )
 +>        );
 
-CUSTNUM  
--------  
+CUSTNUM
+-------
 
-   1234  
-   7777  
-    926  
-     21  
-    543  
-    123  
-   7654  
-    324  
-   3333  
-    143  
-   3210  
-   5635  
+     21
+    123
+    143
+    324
+    543
+    926
+   1234
+   3210
+   3333
+   5635
+   7654
+   7777
 
 --- 12 row(s) selected.
 >>
@@ -2420,38 +2420,38 @@ CUSTNUM
 +>           )
 +>        );
 
-PARTNUM  
--------  
-
-    244  
-   2001  
-   2403  
-   4103  
-   5103  
-   6301  
-   6402  
-   2002  
-   2003  
-   3102  
-   4101  
-   6302  
-   2402  
-   3202  
-   3302  
-   4102  
-   5504  
-   6201  
-   3103  
-   5503  
-   5502  
-   1403  
-   7301  
-    212  
-   7102  
-   5505  
-   5101  
-   6401  
-   3201  
+PARTNUM
+-------
+
+    244
+   2001
+   2403
+   4103
+   5103
+   6301
+   6402
+   2002
+   2003
+   3102
+   4101
+   6302
+   2402
+   3202
+   3302
+   4102
+   5504
+   6201
+   3103
+   5503
+   5502
+   1403
+   7301
+    212
+   7102
+   5505
+   5101
+   6401
+   3201
 
 --- 29 row(s) selected.
 >>
@@ -2475,38 +2475,38 @@ PARTNUM
 +>           )
 +>        );
 
-PARTNUM  
--------  
-
-    244  
-   2001  
-   2403  
-   4103  
-   5103  
-   6301  
-   6402  
-   2002  
-   2003  
-   3102  
-   4101  
-   6302  
-   2402  
-   3202  
-   3302  
-   4102  
-   5504  
-   6201  
-   3103  
-   5503  
-   5502  
-   1403  
-   7301  
-    212  
-   7102  
-   5505  
-   5101  
-   6401  
-   3201  
+PARTNUM
+-------
+
+    244
+   2001
+   2403
+   4103
+   5103
+   6301
+   6402
+   2002
+   2003
+   3102
+   4101
+   6302
+   2402
+   3202
+   3302
+   4102
+   5504
+   6201
+   3103
+   5503
+   5502
+   1403
+   7301
+    212
+   7102
+   5505
+   5101
+   6401
+   3201
 
 --- 29 row(s) selected.
 >>
@@ -2526,10 +2526,10 @@ PARTNUM
 +>            and  orders.ordernum =  odetail.ordernum )
 +>        );
 
-CUSTNUM  
--------  
+CUSTNUM
+-------
 
-   3210  
+   3210
 
 --- 1 row(s) selected.
 >>
@@ -2553,10 +2553,10 @@ CUSTNUM
 +>            and  orders.ordernum =  odetail.ordernum )
 +>        );
 
-CUSTNUM  
--------  
+CUSTNUM
+-------
 
-   3210  
+   3210
 
 --- 1 row(s) selected.
 >>
@@ -2582,10 +2582,10 @@ CUSTNUM
 +>           )
 +>        );
 
-CUSTNUM  
--------  
+CUSTNUM
+-------
 
-   3210  
+   3210
 
 --- 1 row(s) selected.
 >>
@@ -2607,13 +2607,13 @@ CUSTNUM
 +>           )
 +>        );
 
-CUSTNUM  
--------  
+CUSTNUM
+-------
 
-   1234  
-    926  
-   7654  
-    324  
+    324
+    926
+   1234
+   7654
 
 --- 4 row(s) selected.
 >>
@@ -2634,11 +2634,11 @@ CUSTNUM
 +>           )
 +>        );
 
-CUSTNUM  
--------  
+CUSTNUM
+-------
 
-    143  
-   3210  
+    143
+   3210
 
 --- 2 row(s) selected.
 >>
@@ -2662,11 +2662,11 @@ CUSTNUM
 +>           )
 +>        );
 
-CUSTNUM  
--------  
+CUSTNUM
+-------
 
-    143  
-   3210  
+   3210
+    143
 
 --- 2 row(s) selected.
 >>
@@ -2706,32 +2706,32 @@ CUSTNUM
 +>           )
 +>        );
 
-SUPPNUM  
--------  
-
-      1  
-      1  
-      1  
-      1  
-      1  
-      1  
-      1  
-      1  
-      1  
-      1  
-      1  
-      1  
-     15  
-     15  
-     15  
-     15  
-     15  
-     15  
-     15  
-      1  
-      1  
-      1  
-      1  
+SUPPNUM
+-------
+
+      1
+      1
+      1
+      1
+     15
+     15
+     15
+     15
+      1
+      1
+      1
+      1
+      1
+     15
+      1
+      1
+      1
+      1
+      1
+      1
+     15
+     15
+      1
 
 --- 23 row(s) selected.
 >>
@@ -2765,11 +2765,11 @@ SUPPNUM
 +>         where  fromsup.suppnum =  supplier.suppnum
 +>        );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
-INFOMATION STORAGE  
+INFOMATION STORAGE
+DATADRIVE         
 
 --- 2 row(s) selected.
 >>
@@ -2788,11 +2788,11 @@ INFOMATION STORAGE
 +>         where partnum = 5504
 +>        );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
-INFOMATION STORAGE  
+INFOMATION STORAGE
+DATADRIVE         
 
 --- 2 row(s) selected.
 >>
@@ -2812,13 +2812,13 @@ INFOMATION STORAGE
 +>         where  fromsup.suppnum =  supplier.suppnum
 +>        );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATA TERMINAL CO    
-DATADRIVE           
-INFOMATION STORAGE  
-MAGNETICS CORP      
+DATADRIVE         
+MAGNETICS CORP    
+DATA TERMINAL CO  
+INFOMATION STORAGE
 
 --- 4 row(s) selected.
 >>
@@ -2837,13 +2837,13 @@ MAGNETICS CORP
 +>         where partnum = 5504
 +>        );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATA TERMINAL CO    
-DATADRIVE           
-INFOMATION STORAGE  
-MAGNETICS CORP      
+DATADRIVE         
+DATA TERMINAL CO  
+MAGNETICS CORP    
+INFOMATION STORAGE
 
 --- 4 row(s) selected.
 >>
@@ -2863,12 +2863,12 @@ MAGNETICS CORP
 +>         where partnum = 5504
 +>        ));
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DISPLAY INC         
-STEELWORK INC       
-TANDEM COMPUTERS    
+DISPLAY INC       
+STEELWORK INC     
+TANDEM COMPUTERS  
 
 --- 3 row(s) selected.
 >>
@@ -2893,10 +2893,10 @@ TANDEM COMPUTERS
 +>         where partnum = 5505
 +>        );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
+DATADRIVE         
 
 --- 1 row(s) selected.
 >>
@@ -2915,14 +2915,14 @@ DATADRIVE
 +>          )
 +>       );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATA TERMINAL CO    
-DATADRIVE           
-DISPLAY INC         
-INFOMATION STORAGE  
-TANDEM COMPUTERS    
+DATA TERMINAL CO  
+DATADRIVE         
+DISPLAY INC       
+INFOMATION STORAGE
+TANDEM COMPUTERS  
 
 --- 5 row(s) selected.
 >>
@@ -2959,28 +2959,28 @@ TANDEM COMPUTERS
 +>           )
 +>        );
 
-EMPNAME             JOB           
-------------------  ------------  
-
-THOMAS RUDLOFF      MANAGER       
-KLAUS SAFFERT       MANAGER       
-PETER SMITH         MANAGER       
-DONALD TAYLOR       MANAGER       
-STEVE COOK          MANAGER       
-SHERRIE WONG        MANAGER       
-TONY CRAFT          MANAGER       
-GEORGE FORSTER      SALESMAN      
-RICHARD BARTON      SALESMAN      
-JIMMY SCHNEIDER     SYS.-ANAL.    
-WALTER LANCASTER    SALESMAN      
-JOHN JONES          SYS.-ANAL.    
-MARLENE BONNY       SYS.-ANAL.    
-GEORGE FRENCHMAN    SALESMAN      
-DAVID TERRY         PROGRAMMER    
-KARL HELMSTED       SALESMAN      
-HEIDI WEIGL         SECRETARY     
-XAVER SEDLMEYER     SYST.-ANAL    
-DAVE CLARK          MANAGER       
+EMPNAME             JOB         
+------------------  ------------
+
+THOMAS RUDLOFF      MANAGER     
+KLAUS SAFFERT       MANAGER     
+PETER SMITH         MANAGER     
+DONALD TAYLOR       MANAGER     
+STEVE COOK          MANAGER     
+SHERRIE WONG        MANAGER     
+TONY CRAFT          MANAGER     
+GEORGE FORSTER      SALESMAN    
+RICHARD BARTON      SALESMAN    
+JIMMY SCHNEIDER     SYS.-ANAL.  
+WALTER LANCASTER    SALESMAN    
+JOHN JONES          SYS.-ANAL.  
+MARLENE BONNY       SYS.-ANAL.  
+GEORGE FRENCHMAN    SALESMAN    
+DAVID TERRY         PROGRAMMER  
+KARL HELMSTED       SALESMAN    
+HEIDI WEIGL         SECRETARY   
+XAVER SEDLMEYER     SYST.-ANAL  
+DAVE CLARK          MANAGER     
 
 --- 19 row(s) selected.
 >>
@@ -3001,12 +3001,12 @@ DAVE CLARK          MANAGER
 +>           )
 +>        );
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4102  
-   4103  
-   5504  
+   4102
+   4103
+   5504
 
 --- 3 row(s) selected.
 >>
@@ -3026,10 +3026,10 @@ PARTNUM
 +>           )
 +>        );
 
-COL_1  
------  
+COL_1
+-----
 
- 4103  
+ 4103
 
 --- 1 row(s) selected.
 >>
@@ -3050,10 +3050,10 @@ COL_1
 +>           )
 +>        );
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4103  
+   4103
 
 --- 1 row(s) selected.
 >>
@@ -3076,14 +3076,14 @@ PARTNUM
 +>           )
 +>        );
 
-SALESMAN  ORDERNUM  
---------  --------  
+SALESMAN  ORDERNUM
+--------  --------
 
-     207        41  
-     212        45  
-     225        48  
-     205        66  
-     221       122  
+     205        66
+     207        41
+     212        45
+     221       122
+     225        48
 
 --- 5 row(s) selected.
 >>
@@ -3106,14 +3106,14 @@ SALESMAN  ORDERNUM
 +>           )
 +>        );
 
-SALESMAN  ORDERNUM  
---------  --------  
+SALESMAN  ORDERNUM
+--------  --------
 
-     207        41  
-     212        45  
-     225        48  
-     205        66  
-     221       122  
+     205        66
+     207        41
+     212        45
+     221       122
+     225        48
 
 --- 5 row(s) selected.
 >>-- <comment> subquery
@@ -3135,14 +3135,14 @@ SALESMAN  ORDERNUM
 +>           )
 +>        );
 
-SALESMAN  ORDERNUM  
---------  --------  
+SALESMAN  ORDERNUM
+--------  --------
 
-     207        41  
-     212        45  
-     225        48  
-     205        66  
-     221       122  
+     205        66
+     207        41
+     212        45
+     221       122
+     225        48
 
 --- 5 row(s) selected.
 >>
@@ -3154,8 +3154,8 @@ SALESMAN  ORDERNUM
 >>
 >>-- <detail>
 >>--    correlated subquery in where clause test - this tests the use of
->>--    for browse access, for stable access,
->>--    and for repeatable access inside of subqueries.
+>>--    for read committed access, for read committed access,
+>>--    and for read committed access inside of subqueries.
 >>
 >>-- <templates>
 >>--     US00
@@ -3168,21 +3168,21 @@ SALESMAN  ORDERNUM
 +>         (select distinct Y.partnum
 +>          from fromsup Y
 +>          where Y.suppnum <> X.suppnum
-+>          for browse access
++>          for read committed access
 +>         )
-+>      for stable access;
++>      for read committed access;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -3194,21 +3194,21 @@ PARTNUM
 +>         (select distinct Y.partnum
 +>          from fromsup Y
 +>          where Y.suppnum <> X.suppnum
-+>          for stable access
++>          for read committed access
 +>         )
-+>      for repeatable access;
++>      for read committed access;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -3220,21 +3220,21 @@ PARTNUM
 +>         (select distinct Y.partnum
 +>          from fromsup Y
 +>          where Y.suppnum <> X.suppnum
-+>          for repeatable access
++>          for read committed access
 +>         )
-+>      for repeatable access;
++>      for read committed access;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -3248,16 +3248,16 @@ PARTNUM
 +>       (select partcost
 +>        from expfroms
 +>        where  parts.partnum =  expfroms.partnum
-+>        for repeatable access
++>        for read committed access
 +>       );
 
-PARTNAME            
-------------------  
+PARTNAME          
+------------------
 
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DISC CONT DUAL      
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DISC CONT DUAL    
 
 --- 4 row(s) selected.
 >>
@@ -3271,33 +3271,33 @@ DISC CONT DUAL
 +>         from fromsup
 +>         where  parts.partnum =  fromsup.partnum
 +>         group by partcost
-+>         for browse access
-+>        );
-
-PARTNAME            
-------------------  
-
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DECIMAL ARITH       
-ENSCRIBE MICRO      
-COBOL MICRO         
-MEM MOD 64K MOS     
-MEM MOD 96K MOS     
-DISC CONT SINGLE    
-DISC CONT DUAL      
-MAG TAPE CONT 8/16  
-LINE PRINTER CONT   
-MAG TAPE DR 800BPI  
-MAG TAPE DR 8/16    
-SYNC CONTROLLER     
-ASYNC CONTROLLER    
-ASYNC EXTENSION     
-TERM CRT CHAR       
-TERM CRT PAGE       
-TERM HARD COPY      
-POWER MODULE        
++>         for read committed access
++>        );
+
+PARTNAME          
+------------------
+
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DECIMAL ARITH     
+ENSCRIBE MICRO    
+COBOL MICRO       
+MEM MOD 64K MOS   
+MEM MOD 96K MOS   
+DISC CONT SINGLE  
+DISC CONT DUAL    
+MAG TAPE CONT 8/16
+LINE PRINTER CONT 
+MAG TAPE DR 800BPI
+MAG TAPE DR 8/16  
+SYNC CONTROLLER   
+ASYNC CONTROLLER  
+ASYNC EXTENSION   
+TERM CRT CHAR     
+TERM CRT PAGE     
+TERM HARD COPY    
+POWER MODULE      
 
 --- 21 row(s) selected.
 >>
@@ -3310,40 +3310,40 @@ POWER MODULE
 +>        (select Y.col_3
 +>         from partsfor Y
 +>         where X.col_1 <> Y.col_1
-+>         for browse access
++>         for read committed access
 +>        )
-+>      for browse access;
-
-COL_1               
-------------------  
-
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-MAG TAPE CONT 8/16  
-DISC 10MB           
-DISC 10MB           
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-TERM CRT CHAR       
-TERM CRT PAGE       
-TERM CRT PAGE       
-TERM CRT PAGE       
-TERM CRT PAGE       
++>      for read committed access;
+
+COL_1             
+------------------
+
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+MAG TAPE CONT 8/16
+DISC 10MB         
+DISC 10MB         
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+TERM CRT CHAR     
+TERM CRT PAGE     
+TERM CRT PAGE     
+TERM CRT PAGE     
+TERM CRT PAGE     
 
 --- 27 row(s) selected.
 >>
@@ -3356,40 +3356,40 @@ TERM CRT PAGE
 +>        (select Y.col_3
 +>         from partsfor Y
 +>         where X.col_1 <> Y.col_1
-+>         for stable access
++>         for read committed access
 +>        )
-+>      for stable access;
-
-COL_1               
-------------------  
-
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-MAG TAPE CONT 8/16  
-DISC 10MB           
-DISC 10MB           
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-TERM CRT CHAR       
-TERM CRT PAGE       
-TERM CRT PAGE       
-TERM CRT PAGE       
-TERM CRT PAGE       
++>      for read committed access;
+
+COL_1             
+------------------
+
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+MAG TAPE CONT 8/16
+DISC 10MB         
+DISC 10MB         
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+TERM CRT CHAR     
+TERM CRT PAGE     
+TERM CRT PAGE     
+TERM CRT PAGE     
+TERM CRT PAGE     
 
 --- 27 row(s) selected.
 >>
@@ -3402,40 +3402,40 @@ TERM CRT PAGE
 +>        (select Y.col_3
 +>         from partsfor Y
 +>         where X.col_1 <> Y.col_1
-+>         for repeatable access
++>         for read committed access
 +>        )
-+>      for browse access;
-
-COL_1               
-------------------  
-
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DECIMAL ARITH       
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-DISC CONT SINGLE    
-MAG TAPE CONT 8/16  
-DISC 10MB           
-DISC 10MB           
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-MAG TAPE DR 8/16    
-TERM CRT CHAR       
-TERM CRT PAGE       
-TERM CRT PAGE       
-TERM CRT PAGE       
-TERM CRT PAGE       
++>      for read committed access;
+
+COL_1             
+------------------
+
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DECIMAL ARITH     
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+DISC CONT SINGLE  
+MAG TAPE CONT 8/16
+DISC 10MB         
+DISC 10MB         
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+MAG TAPE DR 8/16  
+TERM CRT CHAR     
+TERM CRT PAGE     
+TERM CRT PAGE     
+TERM CRT PAGE     
+TERM CRT PAGE     
 
 --- 27 row(s) selected.
 >>
@@ -3450,20 +3450,20 @@ TERM CRT PAGE
 +>         from fromsup Y
 +>         where Y.suppnum <> X.suppnum
 +>         and X.partnum = Y.partnum
-+>         for repeatable access
++>         for read committed access
 +>        );
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4101  
-   4102  
-   4103  
-   5101  
-   5103  
-   5504  
-   6401  
-   6402  
+   4101
+   4102
+   4103
+   5101
+   5103
+   5504
+   6401
+   6402
 
 --- 8 row(s) selected.
 >>
@@ -3481,17 +3481,17 @@ PARTNUM
 +>            from fromsup Z
 +>            where X.suppnum = Z.suppnum
 +>            and Z.partnum = Y.partnum
-+>            for browse access
++>            for read committed access
 +>           )
-+>         for stable access
++>         for read committed access
 +>        )
-+>      for repeatable access;
++>      for read committed access;
 
-SUPPNUM  
--------  
+SUPPNUM
+-------
 
-      6  
-     15  
+      6
+     15
 
 --- 2 row(s) selected.
 >>
@@ -3510,44 +3510,44 @@ SUPPNUM
 +>            from odetail Y
 +>            where Y.partnum = X.partnum
 +>            and  orders.ordernum = Y.ordernum
-+>            for browse access
++>            for read committed access
 +>           )
-+>         for repeatable access
++>         for read committed access
 +>        )
-+>      for stable access;
-
-PARTNUM  
--------  
-
-    244  
-   2001  
-   2403  
-   4103  
-   5103  
-   6301  
-   6402  
-   2002  
-   2003  
-   3102  
-   4101  
-   6302  
-   2402  
-   3202  
-   3302  
-   4102  
-   5504  
-   6201  
-   3103  
-   5503  
-   5502  
-   1403  
-   7301  
-    212  
-   7102  
-   5505  
-   5101  
-   6401  
-   3201  
++>      for read committed access;
+
+PARTNUM
+-------
+
+    244
+   2001
+   2403
+   4103
+   5103
+   6301
+   6402
+   2002
+   2003
+   3102
+   4101
+   6302
+   2402
+   3202
+   3302
+   4102
+   5504
+   6201
+   3103
+   5503
+   5502
+   1403
+   7301
+    212
+   7102
+   5505
+   5101
+   6401
+   3201
 
 --- 29 row(s) selected.
 >>
@@ -3560,20 +3560,20 @@ PARTNUM
 +>        (select partnum
 +>         from fromsup
 +>         where  fromsup.suppnum =  supplier.suppnum
-+>         for repeatable access
++>         for read committed access
 +>        )
 +>      and 5504 =ANY
 +>        (select partnum
 +>         from fromsup
 +>         where  fromsup.suppnum =  supplier.suppnum
-+>         for stable access
++>         for read committed access
 +>        );
 
-SUPPNAME            
-------------------  
+SUPPNAME          
+------------------
 
-DATADRIVE           
-INFOMATION STORAGE  
+INFOMATION STORAGE
+DATADRIVE         
 
 --- 2 row(s) selected.
 >>
@@ -3591,18 +3591,18 @@ INFOMATION STORAGE
 +>            from fromsup Z
 +>            where Z.suppnum <> Y.suppnum
 +>            and Z.suppnum <> X.suppnum
-+>            for stable access
++>            for read committed access
 +>           )
-+>         for browse access
++>         for read committed access
 +>        )
-+>      for repeatable access;
++>      for read committed access;
 
-PARTNUM  
--------  
+PARTNUM
+-------
 
-   4102  
-   4103  
-   5504  
+   4102
+   4103
+   5504
 
 --- 3 row(s) selected.
 >>
@@ -3619,16 +3619,16 @@ PARTNUM
 +>            from fsdetail Z
 +>            where Z.col_2 <> Y.col_2
 +>            and Z.col_2 <> X.col_2
-+>            for browse access
++>            for read committed access
 +>           )
-+>         for repeatable access
++>         for read committed access
 +>        )
-+>      for stable access;
++>      for read committed access;
 
-COL_1  
------  
+COL_1
+-----
 
- 4103  
+ 4103
 
 --- 1 row(s) selected.
 >>
@@ -3656,30 +3656,30 @@ COL_1
 +>         where partnum =  parts.partnum
 +>        );
 
-PARTNAME            
-------------------  
-
-SYSTEM 192KB CORE   
-SYSTEM 192KB SEMI   
-PROC     96KB SEMI  
-DECIMAL ARITH       
-ENSCRIBE MICRO      
-COBOL MICRO         
-MEM MOD 64K MOS     
-MEM MOD 96K MOS     
-DISC CONT SINGLE    
-DISC CONT DUAL      
-MAG TAPE CONT 8/16  
-LINE PRINTER CONT   
-MAG TAPE DR 800BPI  
-MAG TAPE DR 8/16    
-SYNC CONTROLLER     
-ASYNC CONTROLLER    
-ASYNC EXTENSION     
-TERM CRT CHAR       
-TERM CRT PAGE       
-TERM HARD COPY      
-POWER MODULE        
+PARTNAME          
+------------------
+
+SYSTEM 192KB CORE 
+SYSTEM 192KB SEMI 
+PROC     96KB SEMI
+DECIMAL ARITH     
+ENSCRIBE MICRO    
+COBOL MICRO       
+MEM MOD 64K MOS   
+MEM MOD 96K MOS   
+DISC CONT SINGLE  
+DISC CONT DUAL    
+MAG TAPE CONT 8/16
+LINE PRINTER CONT 
+MAG TAPE DR 800BPI
+MAG TAPE DR 8/16  
+SYNC CONTROLLER   
+ASYNC CONTROLLER  
+ASYNC EXTENSION   
+TERM CRT CHAR     
+TERM CRT PAGE     
+TERM HARD COPY    
+POWER MODULE      
 
 --- 21 row(s) selected.
 >>
@@ -3697,13 +3697,13 @@ POWER MODULE
 +>         having sum(salary) > 150000
 +>        );
 
-BRANCHNAME      
---------------  
+BRANCHNAME    
+--------------
 
-CHICAGO         
-DALLAS          
-FRANKFURT       
-CUPERTINO       
+CHICAGO       
+DALLAS        
+FRANKFURT     
+CUPERTINO     
 
 --- 4 row(s) selected.
 >>
@@ -3719,38 +3719,38 @@ CUPERTINO
 +>         and Y.regnum = X.regnum
 +>        );
 
-EMPNAME             
-------------------  
-
-ROGER GREEN         
-JERRY HOWARD        
-JACK RAYMOND        
-THOMAS RUDLOFF      
-KLAUS SAFFERT       
-PAUL WINTER         
-GLENN THOMAS        
-TIM WALKER          
-ERIC BROWN          
-PETER SMITH         
-DAVID STRAND        
-STEVE COOK          
-SHERRIE WONG        
-TONY CRAFT          
-MANFRED CONRAD      
-TOM HALL            
-JULIA KELLY         
-GEORGE FRENCHMAN    
-JOHANN HUBER        
-OTTO SCHNABL        
-MARTIN SCHAEFER     
-KARL HELMSTED       
-PETE WELLINGTON     
-GEORGE STRICKER     
-HERB ALBERT         
-THOMAS SPINNER      
-TED MCDONNALDS      
-DAVE CLARK          
-ALAN TERRY          
+EMPNAME           
+------------------
+
+ROGER GREEN       
+JERRY HOWARD      
+JACK RAYMOND      
+THOMAS RUDLOFF    
+KLAUS SAFFERT     
+PAUL WINTER       
+GLENN THOMAS      
+TIM WALKER        
+ERIC BROWN        
+PETER SMITH       
+DAVID STRAND      
+STEVE COOK        
+SHERRIE WONG      
+TONY CRAFT        
+MANFRED CONRAD    
+TOM HALL          
+JULIA KELLY       
+GEORGE FRENCHMAN  
+JOHANN HUBER      
+OTTO SCHNABL      
+MARTIN SCHAEFER   
+KARL HELMSTED     
+PETE WELLINGTON   
+GEORGE STRICKER   
+HERB ALBERT       
+THOMAS SPINNER    
+TED MCDONNALDS    
+DAVE CLARK        
+ALAN TERRY        
 
 --- 29 row(s) selected.
 >>
@@ -3766,38 +3766,38 @@ ALAN TERRY
 +>         and Y.regnum = X.regnum
 +>        );
 
-EMPNAME             
-------------------  
-
-ROGER GREEN         
-JERRY HOWARD        
-JACK RAYMOND        
-THOMAS RUDLOFF      
-KLAUS SAFFERT       
-PAUL WINTER         
-TIM WALKER          
-ERIC BROWN          
-PETER SMITH         
-DAVID STRAND        
-STEVE COOK          
-SHERRIE WONG        
-TONY CRAFT          
-MANFRED CONRAD      
-LARRY CLARK         
-TOM HALL            
-JULIA KELLY         
-GEORGE FRENCHMAN    
-JOHANN HUBER        
-OTTO SCHNABL        
-MARTIN SCHAEFER     
-KARL HELMSTED       
-PETE WELLINGTON     
-GEORGE STRICKER     
-HERB ALBERT         
-THOMAS SPINNER      
-TED MCDONNALDS      
-DAVE CLARK          
-ALAN TERRY          
+EMPNAME           
+------------------
+
+ROGER GREEN       
+JERRY HOWARD      
+JACK RAYMOND      
+THOMAS RUDLOFF    
+KLAUS SAFFERT     
+PAUL WINTER       
+TIM WALKER        
+ERIC BROWN        
+PETER SMITH       
+DAVID STRAND      
+STEVE COOK        
+SHERRIE WONG      
+TONY CRAFT        
+MANFRED CONRAD    
+LARRY CLARK       
+TOM HALL          
+JULIA KELLY       
+GEORGE FRENCHMAN  
+JOHANN HUBER      
+OTTO SCHNABL      
+MARTIN SCHAEFER   
+KARL HELMSTED     
+PETE WELLINGTON   
+GEORGE STRICKER   
+HERB ALBERT       
+THOMAS SPINNER    
+TED MCDONNALDS    
+DAVE CLARK        
+ALAN TERRY        
 
 --- 29 row(s) selected.
 >>
@@ -3820,21 +3820,21 @@ ALAN TERRY
 +>           )
 +>        );
 
-EMPNAME             
-------------------  
+EMPNAME           
+------------------
 
-JACK RAYMOND        
-SUSAN HENDERSON     
-STEVE COOK          
-SHERRIE WONG        
-LINDA JONES         
-GEORGE FORSTER      
-SUE CRAMER          
-RICHARD BARTON      
-WALTER LANCASTER    
-HEIDI WEIGL         
-PETE WELLINGTON     
-HERB ALBERT         
+JACK RAYMOND      
+SUSAN HENDERSON   
+STEVE COOK        
+SHERRIE WONG      
+LINDA JONES       
+GEORGE FORSTER    
+SUE CRAMER        
+RICHARD BARTON    
+WALTER LANCASTER  
+HEIDI WEIGL       
+PETE WELLINGTON   
+HERB ALBERT       
 
 --- 12 row(s) selected.
 >>
@@ -3857,21 +3857,21 @@ HERB ALBERT
 +>           )
 +>        );
 
-EMPNAME             
-------------------  
+EMPNAME           
+------------------
 
-JACK RAYMOND        
-SUSAN HENDERSON     
-STEVE COOK          
-SHERRIE WONG        
-LINDA JONES         
-GEORGE FORSTER      
-SUE CRAMER          
-RICHARD BARTON      
-WALTER LANCASTER    
-HEIDI WEIGL         
-PETE WELLINGTON     
-HERB ALBERT         
+JACK RAYMOND      
+SUSAN HENDERSON   
+STEVE COOK        
+SHERRIE WONG      
+LINDA JONES       
+GEORGE FORSTER    
+SUE CRAMER        
+RICHARD BARTON    
+WALTER LANCASTER  
+HEIDI WEIGL       
+PETE WELLINGTON   
+HERB ALBERT       
 
 --- 12 row(s) selected.
 >>
@@ -3890,39 +3890,39 @@ HERB ALBERT
 +>         and X.branchnum = Y.branchnum
 +>        );
 
-EMPNAME             
-------------------  
-
-ROGER GREEN         
-JERRY HOWARD        
-JACK RAYMOND        
-THOMAS RUDLOFF      
-KLAUS SAFFERT       
-PAUL WINTER         
-GLENN THOMAS        
-TIM WALKER          
-PETER SMITH         
-DAVID STRAND        
-STEVE COOK          
-SHERRIE WONG        
-TONY CRAFT          
-MANFRED CONRAD      
-LARRY CLARK         
-TOM HALL            
-DAVE FISHER         
-JULIA KELLY         
-WALTER LANCASTER    
-GEORGE FRENCHMAN    
-JOHANN HUBER        
-OTTO SCHNABL        
-MARTIN SCHAEFER     
-KARL HELMSTED       
-PETE WELLINGTON     
-GEORGE STRICKER     
-HERB ALBERT         
-THOMAS SPINNER      
-TED MCDONNALDS      
-DAVE CLARK          
+EMPNAME           
+------------------
+
+PAUL WINTER       
+MARTIN SCHAEFER   
+OTTO SCHNABL      
+JOHANN HUBER      
+MANFRED CONRAD    
+TONY CRAFT        
+JACK RAYMOND      
+TOM HALL          
+LARRY CLARK       
+TIM WALKER        
+STEVE COOK        
+SHERRIE WONG      
+WALTER LANCASTER  
+DAVE CLARK        
+PETER SMITH       
+GEORGE FRENCHMAN  
+KLAUS SAFFERT     
+KARL HELMSTED     
+THOMAS RUDLOFF    
+ROGER GREEN       
+TED MCDONNALDS    
+THOMAS SPINNER    
+HERB ALBERT       
+GEORGE STRICKER   
+PETE WELLINGTON   
+GLENN THOMAS      
+JULIA KELLY       
+JERRY HOWARD      
+DAVE FISHER       
+DAVID STRAND      
 
 --- 30 row(s) selected.
 >>


Mime
View raw message