trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sure...@apache.org
Subject [3/5] incubator-trafodion git commit: Various fixes, details listed below
Date Fri, 12 Aug 2016 15:28:54 GMT
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/52234cd8/core/sql/regress/qat/eqatdml01
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml01 b/core/sql/regress/qat/eqatdml01
index 442b9e2..3920464 100755
--- a/core/sql/regress/qat/eqatdml01
+++ b/core/sql/regress/qat/eqatdml01
@@ -8,13 +8,13 @@
 >>---------------------------------------------------------------------
 >>  SELECT * FROM btempkey ;
 
-*** ERROR[4211] DML operations are not allowed on a non-audited table.  Table: CAT.SCH.BTEMPKEY.
+*** ERROR[4211] DML operations are not allowed on a non-audited table.  Table: TRAFODION.SCH.BTEMPKEY.
 
 *** ERROR[8822] The statement was not prepared.
 
 >>  SELECT * FROM btemprel ;
 
-*** ERROR[4211] DML operations are not allowed on a non-audited table.  Table: CAT.SCH.BTEMPREL.
+*** ERROR[4211] DML operations are not allowed on a non-audited table.  Table: TRAFODION.SCH.BTEMPREL.
 
 *** ERROR[8822] The statement was not prepared.
 
@@ -26,14 +26,14 @@
 CHAR_1  CHAR_10     PIC_X_1  PIC_X_7  PIC_X_LONG                                                                                                                                                                                                VAR_CHAR                                                                                                                                                                                                                                                       BINARY_SIGNED  BINARY_32_U  BINARY_64_S            PIC_COMP_1            PIC_COMP_2  PIC_COMP_3    SMALL_INT  MEDIUM_INT  LARGE_INT             DECIMAL_1  DECIMAL_2_SIGNED  DECIMAL_3_UNSIGNED  PIC_DECIMAL_1  PIC_DECIMAL_2  PIC_DECIMAL_3
 ------  ----------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------
 
+D       michelle    D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                 -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6
+A       steven      C        walter   bob                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         50        50.00                200.000                    50         .12     100.90000         10       10000            1000000000          4               .50                  90            1.1           .100              1
+A       bobby       A        bobby    bop                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         60        60.00               1200.000                    60         .79     100.99000       1000        8000                 -1000          5               .60                 100            2.1           .200              2
 D       melissa     C        7        pop                                                                                                                                                                                                       jimmy                                                                                                                                                                                                                                                                   1000        80.00               1500.000                   500         .20     100.99990         80        9000                   999          5               .80                 120            4.1           .400              4
 E       monica      Q        sue      pat                                                                                                                                                                                                       christopher                                                                                                                                                                                                                                                             2000        90.00               1200.000                  3000         .30     100.99999       2000        8000              -1000000          1               .90                  80            5.1           .500              5
 C       maureen     E        jimmy    rum                                                                                                                                                                                                       marilyn                                                                                                                                                                                                                                                                 3000        80.00               2000.000                   500         .50     100.70000       9000        1000                  2000          8               .97                 150            7.1           .700              7
-A       bobby       A        bobby    bop                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         60        60.00               1200.000                    60         .79     100.99000       1000        8000                 -1000          5               .60                 100            2.1           .200              2
-D       michelle    D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                 -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6
-A       steven      C        walter   bob                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         50        50.00                200.000                    50         .12     100.90000         10       10000            1000000000          4               .50                  90            1.1           .100              1
-D       steven      B        9        bat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                  8000        70.00               2000.000                   500         .10     100.99900         90       10000                  1000          7               .70                 110            3.1           .300              3
 C       marcia      Z        johnny   dum                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                  4000        40.00               2000.000                    50         .60     100.60000       8000        5000                     0          9               .99                 110            8.1           .800              8
+D       steven      B        9        bat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                  8000        70.00               2000.000                   500         .10     100.99900         90       10000                  1000          7               .70                 110            3.1           .300              3
 
 --- 8 row(s) selected.
 >>  SELECT * FROM btsel02 ;
@@ -101,14 +101,14 @@ not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk
 PIC_X_A  PIC_X_B  PIC_X_C  COL_1  COL_2  COL_3  COL_4  COL_5  COL_6  COL_7  COL_8  COL_9  COL_10  COL_21       COL_22       COL_23       COL_24       COL_25       COL_26       COL_27      COL_28      COL_29      COL_30      COL_41       COL_42       COL_43       COL_44       COL_45      COL_46      COL_47      COL_48      COL_61                COL_62                COL_63                COL_64                COL_65                COL_66                COL_67               COL_68               COL_69               COL_70
 -------  -------  -------  -----  -----  -----  -----  -----  -----  -----  -----  -----  ------  -----------  -----------  -----------  -----------  -----------  -----------  ----------  ----------  ----------  ----------  -----------  -----------  -----------  -----------  ----------  ----------  ----------  ----------  --------------------  --------------------  --------------------  --------------------  --------------------  --------------------  -------------------  -------------------  -------------------  -------------------
 
-pam      D        al         900   1000    900   1000   1000     50   1000   1000   1000    1000         1000         1000         1000         1000         1000         1000        1000        1000        1000        1000      1000.00      1000.00      1000.00      1000.00     1000.00     1000.00     1000.00     1000.00                  1000                  1000                  1000                  1000                  1000                  1000                 1000                 1000                 1000                 1000
+joe      A        jo         100   1000    200   1000   1000     50   1000   1000   1000    1000         1000         1000         1000         1000         1000         1000        1000        1000        1000        1000      1000.00      1000.00      1000.00      1000.00     1000.00     1000.00     1000.00     1000.00                  1000                  1000                  1000                  1000                  1000                  1000                 1000                 1000                 1000                 1000
+joe      B        to         300   1000    400   1000   1000     50   1000   1000   1000    1000         1000         1000         1000         1000         1000         1000        1000        1000        1000        1000      1000.00      1000.00      1000.00      1000.00     1000.00     1000.00     1000.00     1000.00                  1000                  1000                  1000                  1000                  1000                  1000                 1000                 1000                 1000                 1000
 joe      C        go         100   1000    200   1000   1000     50   1000   1000   1000    1000         1000         1000         1000         1000         1000         1000        1000        1000        1000        1000      1000.00      1000.00      1000.00      1000.00     1000.00     1000.00     1000.00     1000.00                  1000                  1000                  1000                  1000                  1000                  1000                 1000                 1000                 1000                 1000
 joe      Z        in         100    200    100    200    200    100    100    100     50     100          100          200          100          200          200          100         100         100          50         100       100.00       200.00       100.00       200.00      200.00      100.00      100.00      100.00                   100                   200                   100                   200                   200                   100                  100                  100                   50                  100
-joe      B        to         300   1000    400   1000   1000     50   1000   1000   1000    1000         1000         1000         1000         1000         1000         1000        1000        1000        1000        1000      1000.00      1000.00      1000.00      1000.00     1000.00     1000.00     1000.00     1000.00                  1000                  1000                  1000                  1000                  1000                  1000                 1000                 1000                 1000                 1000
+pam      D        al         900   1000    900   1000   1000     50   1000   1000   1000    1000         1000         1000         1000         1000         1000         1000        1000        1000        1000        1000      1000.00      1000.00      1000.00      1000.00     1000.00     1000.00     1000.00     1000.00                  1000                  1000                  1000                  1000                  1000                  1000                 1000                 1000                 1000                 1000
 sue      C        by         300   1000    500   1000   1000     50   1000   1000   1000    1000         1000         1000         1000         1000         1000         1000        1000        1000        1000        1000      1000.00      1000.00      1000.00      1000.00     1000.00     1000.00     1000.00     1000.00                  1000                  1000                  1000                  1000                  1000                  1000                 1000                 1000                 1000                 1000
-sue      Q        on         200    400    100    100    400    100    100     50    100     200          200          400          100          100          400          100         100          50         100         200       200.00       400.00       100.00       100.00      400.00      100.00      100.00       50.00                   200                   400                   100                   100                   400                   100                  100                   50                  100                  200
-joe      A        jo         100   1000    200   1000   1000     50   1000   1000   1000    1000         1000         1000         1000         1000         1000         1000        1000        1000        1000        1000      1000.00      1000.00      1000.00      1000.00     1000.00     1000.00     1000.00     1000.00                  1000                  1000                  1000                  1000                  1000                  1000                 1000                 1000                 1000                 1000
 sue      D        so         200   1000    300   1000   1000     50   1000   1000   1000    1000         1000         1000         1000         1000         1000         1000        1000        1000        1000        1000      1000.00      1000.00      1000.00      1000.00     1000.00     1000.00     1000.00     1000.00                  1000                  1000                  1000                  1000                  1000                  1000                 1000                 1000                 1000                 1000
+sue      Q        on         200    400    100    100    400    100    100     50    100     200          200          400          100          100          400          100         100          50         100         200       200.00       400.00       100.00       100.00      400.00      100.00      100.00       50.00                   200                   400                   100                   100                   400                   100                  100                   50                  100                  200
 
 --- 8 row(s) selected.
 >>  SELECT * FROM btsel07 ;
@@ -116,16 +116,16 @@ sue      D        so         200   1000    300   1000   1000     50   1000   100
 PIC_X_A  PIC_X_B  PIC_X_C
 -------  -------  -------
 
-al       F        al     
-jo       C        ek     
-JO       D        em     
+P        P        P      
  al      F        al     
+al       F        al     
 al       Q        al     
-P        P        P      
 al       E        bo     
  al      F        di     
-jo       Z        jo     
 B        A        ed     
+jo       C        ek     
+JO       D        em     
+jo       Z        jo     
 
 --- 10 row(s) selected.
 >>  SELECT * FROM btsel08 ;
@@ -134,13 +134,13 @@ LARGE_INT             PIC_252
 --------------------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----
 
                 4000  valley                                                                                                                                                                                                                                                        D    
-                2000  alexander                                                                                                                                                                                                                                                     B    
-                 400  joseph                                                                                                                                                                                                                                                        X    
                 3000  george                                                                                                                                                                                                                                                        D    
+                2000  alexander                                                                                                                                                                                                                                                     B    
                 1000  harveys                                                                                                                                                                                                                                                       B    
+                 400  joseph                                                                                                                                                                                                                                                        X    
                  300  Q                                                                                                                                                                                                                                                             X    
-                 100  carltons                                                                                                                                                                                                                                                      E    
                  200  squaw                                                                                                                                                                                                                                                         X    
+                 100  carltons                                                                                                                                                                                                                                                      E    
 
 --- 8 row(s) selected.
 >>  SELECT * FROM btsel09 ;
@@ -148,17 +148,17 @@ LARGE_INT             PIC_252
 PIC_X_A  PIC_X_2  PIC_X_3  PIC_X_4  PIC_X_5  PIC_X_6  PIC_X_7
 -------  -------  -------  -------  -------  -------  -------
 
-not      time     P        diane          7       20       40
-sue      mary     Z        MARY           3       10       20
-joe      over     W        maria          7       90      100
-\ts      t_go     j        to%go          0        0        0
 why      gone     R        billy          7       15       30
-_t%      junk     j        _%             0        0        0
-\t_      junk     j        \%             0        0        0
+sue      mary     Z        MARY           3       10       20
 red      long     S        tommy          5       15       70
+not      time     P        diane          7       20       40
+joe      over     W        maria          7       90      100
 deb      bill     Y        BILL           4       10       30
 can      come     X        TED            7       77       77
 box      here     R        debby          5       11       50
+_t%      junk     j        _%             0        0        0
+\ts      t_go     j        to%go          0        0        0
+\t_      junk     j        \%             0        0        0
 %t_      junk     j        %_             0        0        0
 
 --- 12 row(s) selected.
@@ -167,13 +167,13 @@ box      here     R        debby          5       11       50
 PIC_X_A  PIC_X_7  PIC_9_7  CHAR_10     DECIMAL_10   BINARY_UNSIGNED  BINARY_32_SIGNED
 -------  -------  -------  ----------  -----------  ---------------  ----------------
 
-jon      does        1000  offsides          50000              500               100
+sue      sue            1  ebedafiih           110               80               100
+bob      bobby          2  ebediih              90              100             -1000
 rob      bobby          2  ebediih              90              100             -1000
 tom      tom            3  abadefih            100              100              -100
-bob      bobby          2  ebediih              90              100             -1000
-rod      for          400  inside               25               60                 0
-sue      sue            1  ebedafiih           110               80               100
 don      who           50  outside           10000              100              -100
+rod      for          400  inside               25               60                 0
+jon      does        1000  offsides          50000              500               100
 ron      they        2000  onsides           10000              100              -100
 
 --- 8 row(s) selected.
@@ -182,14 +182,14 @@ ron      they        2000  onsides           10000              100
 PIC_X_A  PIC_X_7  PIC_9_7  CHAR_10     DECIMAL_10   BINARY_UNSIGNED  BINARY_32_SIGNED
 -------  -------  -------  ----------  -----------  ---------------  ----------------
 
-boe      tommy        200  ebedafiih           200               50                50
-tar      what         500  none                100             8888                 0
 bar      where        300  gone                200             9999              -100
+boe      tommy        200  ebedafiih           200               50                50
+bob      bob          100  abadefih            160              200               200
 car      who          400  done                160              500               500
 jar      how          600  inside              160              500               500
 dan      sue          100  ebediih             100              100                60
+tar      what         500  none                100             8888                 0
 mar      why           50  house                50             7777                 0
-bob      bob          100  abadefih            160              200               200
 
 --- 8 row(s) selected.
 >>  SELECT * FROM btsel12 ;
@@ -197,14 +197,14 @@ bob      bob          100  abadefih            160              200
 DATA_X3  DATA_93
 -------  -------
 
+bob          200
+fun          500
 gun          600
-tom          100
+nun          700
 pun          800
 run          300
 sun          400
-bob          200
-fun          500
-nun          700
+tom          100
 
 --- 8 row(s) selected.
 >>  SELECT * FROM btsel13 ;
@@ -212,14 +212,14 @@ nun          700
 DATA_93
 -------
 
-    200
-    450
-    550
     100
+    200
     250
     350
-    750
+    450
+    550
     650
+    750
 
 --- 8 row(s) selected.
 >>  SELECT * FROM btsel14 ;
@@ -227,14 +227,14 @@ DATA_93
 DATA_93
 -------
 
+    100
+    125
     150
+    175
     200
-    100
     225
     275
     325
-    125
-    175
 
 --- 8 row(s) selected.
 >>  SELECT * FROM btsel15 ;
@@ -243,13 +243,13 @@ SMALL_INT  DATA_93
 ---------  -------
 
      6666       40
-     1111       90
-     2000      200
      5555       50
-     1000      100
      4444       60
-     2222       80
      3333       70
+     2222       80
+     1111       90
+     1000      100
+     2000      200
 
 --- 8 row(s) selected.
 >>  SELECT * FROM btsel16 ;
@@ -302,13 +302,13 @@ BINARY_SIGNED  SMALL_INT  DATA_93
 BINARY_SIGNED  DATA_93
 -------------  -------
 
-         2011      415
+        -5000      409
          2007      411
          2008      412
          2009      413
-         2012      416
-        -5000      409
          2010      414
+         2011      415
+         2012      416
          8000      410
 
 --- 8 row(s) selected.
@@ -317,13 +317,13 @@ BINARY_SIGNED  DATA_93
 BINARY_SIGNED  DATA_93
 -------------  -------
 
+        -5000      417
          2013      419
          2014      420
          2015      421
-         2017      423
          2016      422
+         2017      423
          2018      424
-        -5000      417
          8000      418
 
 --- 8 row(s) selected.
@@ -332,12 +332,12 @@ BINARY_SIGNED  DATA_93
 PIC_COMP_2  BINARY_SIGNED  DATA_93
 ----------  -------------  -------
 
+      -.25           8000      426
        .01           5000      427
        .02           5001      428
+       .03           5002      429
        .04           5003      430
-      -.25           8000      426
        .05           5004      431
-       .03           5002      429
        .06           5005      432
        .12          -5000      425
 
@@ -347,14 +347,14 @@ PIC_COMP_2  BINARY_SIGNED  DATA_93
 PIC_COMP_2  DATA_93
 ----------  -------
 
-       .09      437
       -.25      434
-       .10      438
        .07      435
        .08      436
-       .92      440
+       .09      437
+       .10      438
        .11      439
        .12      433
+       .92      440
 
 --- 8 row(s) selected.
 >>  SELECT * FROM btsel23 ;
@@ -362,14 +362,14 @@ PIC_COMP_2  DATA_93
 PIC_COMP_2  DATA_93
 ----------  -------
 
-       .12      441
       -.25      442
-       .16      446
+       .12      441
        .13      443
-       .15      445
-       .18      448
        .14      444
+       .15      445
+       .16      446
        .17      447
+       .18      448
 
 --- 8 row(s) selected.
 >>  SELECT * FROM btsel24 ;
@@ -377,14 +377,14 @@ PIC_COMP_2  DATA_93
 PIC_COMP_2  DATA_X3
 ----------  -------
 
-       .79  tom    
+       .19  bob    
        .20  toe    
-       .22  pin    
-       .25  kin    
        .21  woe    
-       .24  win    
-       .19  bob    
+       .22  pin    
        .23  sin    
+       .24  win    
+       .25  kin    
+       .79  tom    
 
 --- 8 row(s) selected.
 >>  SELECT * FROM btsel25 ;
@@ -446,14 +446,14 @@ C                .0001          9.9
 BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT
 -------------  --------------------  ----------  -------------  -------  -------  ---------
 
+        -5000                   200        8000              6  D        michael         90
+           50            1000000000       10000              1  C        walter          10
+           60                 -1000        8000              2  A        bobby         1000
          1000                   999        9000              4  C        7               80
          2000              -1000000        8000              5  Q        sue           2000
          3000                  2000        1000              7  E        jimmy         9000
-           60                 -1000        8000              2  A        bobby         1000
-        -5000                   200        8000              6  D        michael         90
-           50            1000000000       10000              1  C        walter          10
-         8000                  1000       10000              3  B        9               90
          4000                     0        5000              8  Z        johnny        8000
+         8000                  1000       10000              3  B        9               90
 
 --- 8 row(s) selected.
 >>  SELECT * FROM pvsel02 ;
@@ -476,10 +476,10 @@ Q
 NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4          
 ----------  -----------  ----------  --------------------
 
-        90         5.00  A             216172782348417025
-        80         6.00  7             216172782348417026
-        80         6.00  7             216172782348417030
-        80         6.00  B             216172782348417031
+        90         5.00  A            2747301277680917390
+        80         6.00  7            2747301277680952308
+        80         6.00  7            2747301277680982850
+        80         6.00  B            2747301277680987579
 
 --- 4 row(s) selected.
 >>  SELECT * FROM pvsel04 ;
@@ -504,13 +504,13 @@ marilyn
 PIC_X_A  PIC_X_7  PIC_9_7  CHAR_10     DECIMAL_10   BINARY_UNSIGNED  BINARY_32_SIGNED
 -------  -------  -------  ----------  -----------  ---------------  ----------------
 
-jon      does        1000  offsides          50000              500               100
+sue      sue            1  ebedafiih           110               80               100
+bob      bobby          2  ebediih              90              100             -1000
 rob      bobby          2  ebediih              90              100             -1000
 tom      tom            3  abadefih            100              100              -100
-bob      bobby          2  ebediih              90              100             -1000
-rod      for          400  inside               25               60                 0
-sue      sue            1  ebedafiih           110               80               100
 don      who           50  outside           10000              100              -100
+rod      for          400  inside               25               60                 0
+jon      does        1000  offsides          50000              500               100
 ron      they        2000  onsides           10000              100              -100
 
 --- 8 row(s) selected.
@@ -519,13 +519,13 @@ ron      they        2000  onsides           10000              100
 BINARY_UNSIGNED  PIC_X_A  PIC_X_7  DECIMAL_10 
 ---------------  -------  -------  -----------
 
-            500  jon      does           50000
+             80  sue      sue              110
+            100  bob      bobby             90
             100  rob      bobby             90
             100  tom      tom              100
-            100  bob      bobby             90
-             60  rod      for               25
-             80  sue      sue              110
             100  don      who            10000
+             60  rod      for               25
+            500  jon      does           50000
             100  ron      they           10000
 
 --- 8 row(s) selected.
@@ -534,9 +534,9 @@ BINARY_UNSIGNED  PIC_X_A  PIC_X_7  DECIMAL_10
 PIC_X_A  PIC_X_7  PIC_9_7  CHAR_10     DECIMAL_10   BINARY_UNSIGNED  BINARY_32_SIGNED
 -------  -------  -------  ----------  -----------  ---------------  ----------------
 
-jon      does        1000  offsides          50000              500               100
 sue      sue            1  ebedafiih           110               80               100
 don      who           50  outside           10000              100              -100
+jon      does        1000  offsides          50000              500               100
 ron      they        2000  onsides           10000              100              -100
 
 --- 4 row(s) selected.
@@ -545,10 +545,10 @@ ron      they        2000  onsides           10000              100
 NEW_NAME_1  NEW_NAME_2  NEW_NAME_3
 ----------  ----------  ----------
 
-jon         does        offsides  
-rob         bobby       ebediih   
-bob         bobby       ebediih   
 sue         sue         ebedafiih 
+bob         bobby       ebediih   
+rob         bobby       ebediih   
+jon         does        offsides  
 
 --- 4 row(s) selected.
 >>  SELECT new_name_ks_s, new_name_ks_x, new_name_es_x FROM svsel05   BROWSE ACCESS ;
@@ -556,94 +556,94 @@ sue         sue         ebedafiih
 NEW_NAME_KS_S         NEW_NAME_KS_X  NEW_NAME_ES_X
 --------------------  -------------  -------------
 
-  216172782348505345  A              B            
-  216172782348505345  A              C            
-  216172782348505345  A              D            
-  216172782348505345  A              E            
-  216172782348505345  A              Q            
-  216172782348505345  A              B            
-  216172782348505345  A              C            
-  216172782348505345  A              D            
-  216172782348505345  A              E            
-  216172782348505345  A              Q            
-  216172782348505345  A                           
-  216172782348505348  D              B            
-  216172782348505348  D              C            
-  216172782348505348  D              D            
-  216172782348505348  D              E            
-  216172782348505348  D              Q            
-  216172782348505348  D              B            
-  216172782348505348  D              C            
-  216172782348505348  D              D            
-  216172782348505348  D              E            
-  216172782348505348  D              Q            
-  216172782348505348  D                           
-  216172782348505350  B              B            
-  216172782348505350  B              C            
-  216172782348505350  B              D            
-  216172782348505350  B              E            
-  216172782348505350  B              Q            
-  216172782348505350  B              B            
-  216172782348505350  B              C            
-  216172782348505350  B              D            
-  216172782348505350  B              E            
-  216172782348505350  B              Q            
-  216172782348505350  B                           
-  216172782348505346  A              B            
-  216172782348505346  A              C            
-  216172782348505346  A              D            
-  216172782348505346  A              E            
-  216172782348505346  A              Q            
-  216172782348505346  A              B            
-  216172782348505346  A              C            
-  216172782348505346  A              D            
-  216172782348505346  A              E            
-  216172782348505346  A              Q            
-  216172782348505346  A                           
-  216172782348505347  D              B            
-  216172782348505347  D              C            
-  216172782348505347  D              D            
-  216172782348505347  D              E            
-  216172782348505347  D              Q            
-  216172782348505347  D              B            
-  216172782348505347  D              C            
-  216172782348505347  D              D            
-  216172782348505347  D              E            
-  216172782348505347  D              Q            
-  216172782348505347  D                           
-  216172782348505352  B              B            
-  216172782348505352  B              C            
-  216172782348505352  B              D            
-  216172782348505352  B              E            
-  216172782348505352  B              Q            
-  216172782348505352  B              B            
-  216172782348505352  B              C            
-  216172782348505352  B              D            
-  216172782348505352  B              E            
-  216172782348505352  B              Q            
-  216172782348505352  B                           
-  216172782348505351  B              B            
-  216172782348505351  B              C            
-  216172782348505351  B              D            
-  216172782348505351  B              E            
-  216172782348505351  B              Q            
-  216172782348505351  B              B            
-  216172782348505351  B              C            
-  216172782348505351  B              D            
-  216172782348505351  B              E            
-  216172782348505351  B              Q            
-  216172782348505351  B                           
-  216172782348505349  C              B            
-  216172782348505349  C              C            
-  216172782348505349  C              D            
-  216172782348505349  C              E            
-  216172782348505349  C              Q            
-  216172782348505349  C              B            
-  216172782348505349  C              C            
-  216172782348505349  C              D            
-  216172782348505349  C              E            
-  216172782348505349  C              Q            
-  216172782348505349  C                           
+ 2747301277683606776  A              B            
+ 2747301277683606776  A              C            
+ 2747301277683606776  A              D            
+ 2747301277683606776  A              E            
+ 2747301277683606776  A              Q            
+ 2747301277683606776  A              B            
+ 2747301277683606776  A              C            
+ 2747301277683606776  A              D            
+ 2747301277683606776  A              E            
+ 2747301277683606776  A              Q            
+ 2747301277683606776  A                           
+ 2747301277683670564  D              B            
+ 2747301277683670564  D              C            
+ 2747301277683670564  D              D            
+ 2747301277683670564  D              E            
+ 2747301277683670564  D              Q            
+ 2747301277683670564  D              B            
+ 2747301277683670564  D              C            
+ 2747301277683670564  D              D            
+ 2747301277683670564  D              E            
+ 2747301277683670564  D              Q            
+ 2747301277683670564  D                           
+ 2747301277683703260  B              B            
+ 2747301277683703260  B              C            
+ 2747301277683703260  B              D            
+ 2747301277683703260  B              E            
+ 2747301277683703260  B              Q            
+ 2747301277683703260  B              B            
+ 2747301277683703260  B              C            
+ 2747301277683703260  B              D            
+ 2747301277683703260  B              E            
+ 2747301277683703260  B              Q            
+ 2747301277683703260  B                           
+ 2747301277683634568  A              B            
+ 2747301277683634568  A              C            
+ 2747301277683634568  A              D            
+ 2747301277683634568  A              E            
+ 2747301277683634568  A              Q            
+ 2747301277683634568  A              B            
+ 2747301277683634568  A              C            
+ 2747301277683634568  A              D            
+ 2747301277683634568  A              E            
+ 2747301277683634568  A              Q            
+ 2747301277683634568  A                           
+ 2747301277683654904  D              B            
+ 2747301277683654904  D              C            
+ 2747301277683654904  D              D            
+ 2747301277683654904  D              E            
+ 2747301277683654904  D              Q            
+ 2747301277683654904  D              B            
+ 2747301277683654904  D              C            
+ 2747301277683654904  D              D            
+ 2747301277683654904  D              E            
+ 2747301277683654904  D              Q            
+ 2747301277683654904  D                           
+ 2747301277683728890  B              B            
+ 2747301277683728890  B              C            
+ 2747301277683728890  B              D            
+ 2747301277683728890  B              E            
+ 2747301277683728890  B              Q            
+ 2747301277683728890  B              B            
+ 2747301277683728890  B              C            
+ 2747301277683728890  B              D            
+ 2747301277683728890  B              E            
+ 2747301277683728890  B              Q            
+ 2747301277683728890  B                           
+ 2747301277683716105  B              B            
+ 2747301277683716105  B              C            
+ 2747301277683716105  B              D            
+ 2747301277683716105  B              E            
+ 2747301277683716105  B              Q            
+ 2747301277683716105  B              B            
+ 2747301277683716105  B              C            
+ 2747301277683716105  B              D            
+ 2747301277683716105  B              E            
+ 2747301277683716105  B              Q            
+ 2747301277683716105  B                           
+ 2747301277683686323  C              B            
+ 2747301277683686323  C              C            
+ 2747301277683686323  C              D            
+ 2747301277683686323  C              E            
+ 2747301277683686323  C              Q            
+ 2747301277683686323  C              B            
+ 2747301277683686323  C              C            
+ 2747301277683686323  C              D            
+ 2747301277683686323  C              E            
+ 2747301277683686323  C              Q            
+ 2747301277683686323  C                           
 
 --- 88 row(s) selected.
 >>  SELECT * FROM svsel06   BROWSE ACCESS ;
@@ -652,92 +652,92 @@ NEW_NAME_KS_X  NEW_NAME_ES_X
 -------------  -------------
 
 A              B            
-D              B            
-B              B            
-A              B            
-D              B            
-B              B            
-B              B            
-C              B            
 A              C            
-D              C            
-B              C            
-A              C            
-D              C            
-B              C            
-B              C            
-C              C            
-A              D            
-D              D            
-B              D            
 A              D            
-D              D            
-B              D            
-B              D            
-C              D            
 A              E            
-D              E            
-B              E            
-A              E            
-D              E            
-B              E            
-B              E            
-C              E            
-A              Q            
-D              Q            
-B              Q            
 A              Q            
-D              Q            
-B              Q            
-B              Q            
-C              Q            
 A              B            
+A              C            
+A              D            
+A              E            
+A              Q            
+A                           
 D              B            
-B              B            
-A              B            
+D              C            
+D              D            
+D              E            
+D              Q            
 D              B            
+D              C            
+D              D            
+D              E            
+D              Q            
+D                           
 B              B            
+B              C            
+B              D            
+B              E            
+B              Q            
 B              B            
-C              B            
-A              C            
-D              C            
 B              C            
+B              D            
+B              E            
+B              Q            
+B                           
+A              B            
 A              C            
-D              C            
-B              C            
-B              C            
-C              C            
 A              D            
-D              D            
-B              D            
+A              E            
+A              Q            
+A              B            
+A              C            
 A              D            
-D              D            
-B              D            
-B              D            
-C              D            
 A              E            
+A              Q            
+A                           
+D              B            
+D              C            
+D              D            
 D              E            
-B              E            
-A              E            
+D              Q            
+D              B            
+D              C            
+D              D            
 D              E            
+D              Q            
+D                           
+B              B            
+B              C            
+B              D            
 B              E            
+B              Q            
+B              B            
+B              C            
+B              D            
 B              E            
-C              E            
-A              Q            
-D              Q            
 B              Q            
-A              Q            
-D              Q            
+B                           
+B              B            
+B              C            
+B              D            
+B              E            
 B              Q            
+B              B            
+B              C            
+B              D            
+B              E            
 B              Q            
-C              Q            
-A                           
-D                           
-B                           
-A                           
-D                           
-B                           
 B                           
+C              B            
+C              C            
+C              D            
+C              E            
+C              Q            
+C              B            
+C              C            
+C              D            
+C              E            
+C              Q            
 C                           
 
 --- 88 row(s) selected.
@@ -778,15 +778,15 @@ COUNT_DISTINCT
 COL_1   COL_2                 COL_3       COL_4  COL_5  COL_6    COL_7   COL_8
 ------  --------------------  ----------  -----  -----  -------  ------  -------
 
+ -5000                   200        8000      6  D      michael      90  7      
+    50            1000000000       10000      1  C      walter       10  A      
+    60                 -1000        8000      2  A      bobby      1000  7      
+    60                 -1000        8000      2  A      bobby      1000  8      
   1000                   999        9000      4  C      7            80  michael
   2000              -1000000        8000      5  Q      sue        2000  7      
   2000              -1000000        8000      5  Q      sue        2000  8      
   3000                  2000        1000      7  E      jimmy      9000  7      
   4000                     0        5000      8  Z      johnny     8000  7      
-    60                 -1000        8000      2  A      bobby      1000  7      
-    60                 -1000        8000      2  A      bobby      1000  8      
- -5000                   200        8000      6  D      michael      90  7      
-    50            1000000000       10000      1  C      walter       10  A      
   8000                  1000       10000      3  B      9            90  7      
 
 --- 10 row(s) selected.
@@ -803,10 +803,10 @@ COL_1                 COL_3                 COL_4  COL_5
 NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
 ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------
 
-        80         6.00  7             216172782348417026  tom                                                                                                                                                                                                                                                                 1000  7                         200
-        80         6.00  7             216172782348417030  tom                                                                                                                                                                                                                                                                 1000  7                         200
-        90         5.00  A             216172782348417025  bob                                                                                                                                                                                                                                                                  999  A                         300
-        80         6.00  B             216172782348417031  bill                                                                                                                                                                                                                                                                2000  B                         500
+        90         5.00  A            2747301277680917390  bob                                                                                                                                                                                                                                                                  999  A                         300
+        80         6.00  7            2747301277680952308  tom                                                                                                                                                                                                                                                                 1000  7                         200
+        80         6.00  7            2747301277680982850  tom                                                                                                                                                                                                                                                                 1000  7                         200
+        80         6.00  B            2747301277680987579  bill                                                                                                                                                                                                                                                                2000  B                         500
 
 --- 4 row(s) selected.
 >>
@@ -825,12 +825,12 @@ NEW_NAME_1  NEW_NAME_3
 MIXED_1  MIXED_2  MIXED_3  MIXED_4  MIXED_5  MIXED_11  MIXED_12  MIXED_13  MIXED_21  MIXED_22  MIXED_23
 -------  -------  -------  -------  -------  --------  --------  --------  --------  --------  --------
 
-joe      A        al       pablo    david    joe       C         go        jo        C         ek      
 joe      A        al       pablo    david    joe       A         jo        B         A         ed      
-joe      A        al       pablo    david    joe       Z         in        jo        Z         jo      
-sue      A        in       peggy    diane    sue       C         by        jo        C         ek      
 sue      A        in       peggy    diane    sue       D         so        JO        D         em      
 sue      A        in       peggy    diane    sue       Q         on        al        Q         al      
+joe      A        al       pablo    david    joe       C         go        jo        C         ek      
+sue      A        in       peggy    diane    sue       C         by        jo        C         ek      
+joe      A        al       pablo    david    joe       Z         in        jo        Z         jo      
 
 --- 6 row(s) selected.
 >>
@@ -842,17 +842,17 @@ sue      A        in       peggy    diane    sue       Q         on        al
 DATA_X3  DATA_93  SMALL_INT  BINARY_SIGNED  PIC_COMP_2
 -------  -------  ---------  -------------  ----------
 
-tom          100       1000          -5000         .12
 bob          200       2000           8000        -.25
+tom          100       1000          -5000         .12
 
 --- 2 row(s) selected.
 >>SELECT * FROM svsel17  BROWSE ACCESS ;
 
-A    B        C  
----  -------  ---
+A    B      C  
+---  -----  ---
 
-tom      .12  tom
-bob     -.25  bob
+tom    .12  tom
+bob   -.25  bob
 
 --- 2 row(s) selected.
 >>control query default optimization_level '3';


Mime
View raw message