>>---------------------------------------------------------------------
>>-- Component: NonStop SQL Regression Test Suite
>>-- Description: SELECT * against populated database to check that
>>--              correct values were stored.  The contents of the
>>--              tables are those needed for SELECT tests.
>>---------------------------------------------------------------------
>>
>>---------------------------------------------------------------------
>>  SELECT * FROM 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: TRAFODION.SCH.BTEMPREL.

*** ERROR[8822] The statement was not prepared.

>>  SELECT * FROM btempent ;

--- 0 row(s) selected.
>>  SELECT * FROM btsel01 ;

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

PIC_X_1
-------

B      
C      
B      
Q      
B      
C      
Q      
Q      

--- 8 row(s) selected.
>>  SELECT * FROM btsel03 ;

PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S          
-------  -----------  --------  -------  ---------------------

A               5.00  make           90                 200.00
7               6.00  joe            80                1200.00
8               6.00  joe            80                1200.00
5            1000.00  5             100                1000.00
michael        50.00  dave           50                1500.00
7               6.00  john           80                2000.00
B               6.00  mark           80                3000.00
michael        70.00  joan           50                4000.00

--- 8 row(s) selected.
>>  SELECT * FROM btsel04 ;

VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

tom                                                                                                                                                                                                                                                                 1000  7                         200
bob                                                                                                                                                                                                                                                                  999  A                         300
sue                                                                                                                                                                                                                                                                  200  sue                       100
bobby                                                                                                                                                                                                                                                                200  sue                       100
bill                                                                                                                                                                                                                                                                2000  B                         500
christopher                                                                                                                                                                                                                                                         1000  white                    1000
william                                                                                                                                                                                                                                                             1000  black                    2000
marilyn                                                                                                                                                                                                                                                             2000  green                    3000

--- 8 row(s) selected.
>>  SELECT * FROM btsel05 ;

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

joe      A        al       pablo  david  amy    amy    steve  steve  walt   mojo   joe    percy 
sue      A        in       peggy  diane  zora   cathy  mary   mary   rhoda  debra  sue    madge 
deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk  
can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk  
box      C        to       howie  debra  snow   debbi  junk   junk   junk   junk   junk   junk  
red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk  

--- 8 row(s) selected.
>>  SELECT * FROM btsel06 ;

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

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

PIC_X_A  PIC_X_B  PIC_X_C
-------  -------  -------

P        P        P      
 al      F        al     
al       F        al     
al       Q        al     
al       E        bo     
 al      F        di     
B        A        ed     
jo       C        ek     
JO       D        em     
jo       Z        jo     

--- 10 row(s) selected.
>>  SELECT * FROM btsel08 ;

LARGE_INT             PIC_252                                                                                                                                                                                                                                                       PIC_1
--------------------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----

                4000  valley                                                                                                                                                                                                                                                        D    
                3000  george                                                                                                                                                                                                                                                        D    
                2000  alexander                                                                                                                                                                                                                                                     B    
                1000  harveys                                                                                                                                                                                                                                                       B    
                 400  joseph                                                                                                                                                                                                                                                        X    
                 300  Q                                                                                                                                                                                                                                                             X    
                 200  squaw                                                                                                                                                                                                                                                         X    
                 100  carltons                                                                                                                                                                                                                                                      E    

--- 8 row(s) selected.
>>  SELECT * FROM btsel09 ;

PIC_X_A  PIC_X_2  PIC_X_3  PIC_X_4  PIC_X_5  PIC_X_6  PIC_X_7
-------  -------  -------  -------  -------  -------  -------

why      gone     R        billy          7       15       30
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.
>>  SELECT * FROM btsel10 ;

PIC_X_A  PIC_X_7  PIC_9_7  CHAR_10     DECIMAL_10   BINARY_UNSIGNED  BINARY_32_SIGNED
-------  -------  -------  ----------  -----------  ---------------  ----------------

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
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.
>>  SELECT * FROM btsel11 ;

PIC_X_A  PIC_X_7  PIC_9_7  CHAR_10     DECIMAL_10   BINARY_UNSIGNED  BINARY_32_SIGNED
-------  -------  -------  ----------  -----------  ---------------  ----------------

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

--- 8 row(s) selected.
>>  SELECT * FROM btsel12 ;

DATA_X3  DATA_93
-------  -------

bob          200
fun          500
gun          600
nun          700
pun          800
run          300
sun          400
tom          100

--- 8 row(s) selected.
>>  SELECT * FROM btsel13 ;

DATA_93
-------

    100
    200
    250
    350
    450
    550
    650
    750

--- 8 row(s) selected.
>>  SELECT * FROM btsel14 ;

DATA_93
-------

    100
    125
    150
    175
    200
    225
    275
    325

--- 8 row(s) selected.
>>  SELECT * FROM btsel15 ;

SMALL_INT  DATA_93
---------  -------

     6666       40
     5555       50
     4444       60
     3333       70
     2222       80
     1111       90
     1000      100
     2000      200

--- 8 row(s) selected.
>>  SELECT * FROM btsel16 ;

SMALL_INT  DATA_93
---------  -------

     1000      167
     2000      168
     8500      169
     8501      170
     8502      171
     8503      172
     8504      173
     8505      174

--- 8 row(s) selected.
>>  SELECT * FROM btsel17 ;

SMALL_INT  DATA_93
---------  -------

     1000      248
     2000      249
     7500      250
     7501      251
     7502      252
     7503      253
     7504      254
     7505      255

--- 8 row(s) selected.
>>  SELECT * FROM btsel18 ;

BINARY_SIGNED  SMALL_INT  DATA_93
-------------  ---------  -------

        -5000       1000      401
         8000       2000      402
         2001       6001      403
         2002       6002      404
         2003       6003      405
         2004       6004      406
         2005       6005      407
         2006       6006      408

--- 8 row(s) selected.
>>  SELECT * FROM btsel19 ;

BINARY_SIGNED  DATA_93
-------------  -------

        -5000      409
         2007      411
         2008      412
         2009      413
         2010      414
         2011      415
         2012      416
         8000      410

--- 8 row(s) selected.
>>  SELECT * FROM btsel20 ;

BINARY_SIGNED  DATA_93
-------------  -------

        -5000      417
         2013      419
         2014      420
         2015      421
         2016      422
         2017      423
         2018      424
         8000      418

--- 8 row(s) selected.
>>  SELECT * FROM btsel21 ;

PIC_COMP_2  BINARY_SIGNED  DATA_93
----------  -------------  -------

      -.25           8000      426
       .01           5000      427
       .02           5001      428
       .03           5002      429
       .04           5003      430
       .05           5004      431
       .06           5005      432
       .12          -5000      425

--- 8 row(s) selected.
>>  SELECT * FROM btsel22 ;

PIC_COMP_2  DATA_93
----------  -------

      -.25      434
       .07      435
       .08      436
       .09      437
       .10      438
       .11      439
       .12      433
       .92      440

--- 8 row(s) selected.
>>  SELECT * FROM btsel23 ;

PIC_COMP_2  DATA_93
----------  -------

      -.25      442
       .12      441
       .13      443
       .14      444
       .15      445
       .16      446
       .17      447
       .18      448

--- 8 row(s) selected.
>>  SELECT * FROM btsel24 ;

PIC_COMP_2  DATA_X3
----------  -------

       .19  bob    
       .20  toe    
       .21  woe    
       .22  pin    
       .23  sin    
       .24  win    
       .25  kin    
       .79  tom    

--- 8 row(s) selected.
>>  SELECT * FROM btsel25 ;

PIC_X_1  PIC_X_3
-------  -------

B        joe    
C        why    
D        not    
E         al    
Q        al     
B        bar    
C        car    
D               
E        joe    
Q        sue    
         sue    

--- 11 row(s) selected.
>>  SELECT * FROM btsel26 ;

SELECTOR  LARGE_BIN_1           LARGE_BIN_2           LARGE_DEC_1          LARGE_DEC_2          SMALL_BIN_1            SMALL_BIN_2            SMALL_DEC_1           SMALL_DEC_2           SEMI_LARGE_BIN_1      SEMI_LARGE_BIN_2      EIGHT_ONE_BIN  ONE_NINE_BIN           NINE_ONE_BIN           ONE_EIGHT_BIN  NINE_ZERO_BIN_U  ZERO_NINE_BIN_U  NINE_ZERO_DEC_U  ZERO_NINE_DEC_U  ZERO_ONE_BIN
--------  --------------------  --------------------  -------------------  -------------------  ---------------------  ---------------------  --------------------  --------------------  --------------------  --------------------  -------------  ---------------------  ---------------------  -------------  ---------------  ---------------  ---------------  ---------------  ------------

A                            2                     2                    2                    2    .900000000000000000    .200000000000000000   .900000000000000000   .200000000000000000     99999999999999999     99999999999999999     99999999.9            1.100000000            999999999.1     9.99999999                2       .200000000                2       .200000000            .0
B           999999999999999999                     1   999999999999999999                    1    .999999999999999999    .000000000000000001   .999999999999999999   .000000000000010000    -99999999999999999     99999999999999999    -99999999.9            1.899999999            999999998.1     9.99999999        999999999       .999999999        999999999       .999999999            .0
C          -999999999999999999                     1  -999999999999999999                    1    .999999999999999999    .000000000000000002   .999999999999999999   .000000000000020000                     0              99999999     99999999.9            9.999999999           -999999999.9     9.99999999                0       .000000000                0       .000000000            .9
D           100000000000000000    899999999999999999   100000000000000000   899999999999999999    .999999999999999999    .100000000000000000   .999999999999999999   .000000000000000002                     0                   100      9999999.9            4.400000000                     .0     8.00000000                0       .000000000                0       .000000000            .1
E           999999999999999999                     3   999999999999999999   100000000000000000    .000000000000000001    .900000000000000000   .999999999999999999   .000000000000000000                    10     99999999999999999             .0            3.000000000                     .0      .00000000                0       .000000000                0       .000000000            .0
F           999999999999999999                     2   999999999999999999  -999999999999999999    .100000000000000000    .000000000000000000   .999999999999999999   .000000000000000000     99999999999999999                     0             .0            2.500000000                     .0      .00000000                0       .000000000                0       .000000000            .0
G            92233720368547758    999999999999999999   999999999999999999                    0    .080000000000000000    .090000000000000000   .999999999999999999   .000000000000000000                     0                     0             .0             .000000000                     .0      .00000000                0       .000000000                0       .000000000            .0
H           999999999999999999    999999999999999999   999999999999999999                    0    .000000000000000000    .000000000000000000   .999999999999999999   .000000000000000000                     0                     0             .0             .000000000                     .0      .00000000                0       .000000000                0       .000000000            .0
I           999999999999999999                     0   999999999999999999                    0    .000000000000000000    .000000000000000000   .999999999999999999   .000000000000000000                     0                     0             .0             .000000000                     .0      .00000000                0       .000000000                0       .000000000            .0
J           999999999999999999                     0   999999999999999999                    0    .000000000000000000    .000000000000000000   .999999999999999999   .000000000000000000                     0                     0             .0             .000000000                     .0      .00000000                0       .000000000                0       .000000000            .0
K           999999999999999999                     0   999999999999999999                    0    .000000000000000000    .000000000000000000   .000000000000000000   .000000000000000000                     0                     0             .0             .000000000                     .0      .00000000                0       .000000000                0       .000000000            .0
L           999999999999999999                     0   999999999999999999                    0    .000000000000000000    .000000000000000000   .000000000000000000   .000000000000000000                     0                     0             .0             .000000000                     .0      .00000000                0       .000000000                0       .000000000            .0
M           999999999999999999                     0   999999999999999999                    0    .000000000000000000    .000000000000000000   .000000000000000000   .000000000000000000                     0                     0             .0             .000000000                     .0      .00000000                0       .000000000                0       .000000000            .0
N           999999999999999999                     0                    0                    0    .000000000000000000    .000000000000000000   .000000000000000000   .000000000000000000                     0                     0             .0             .000000000                     .0      .00000000                0       .000000000                0       .000000000            .0
O          -999999999999999999                     0                    0                    0    .000000000000000000    .000000000000000000   .000000000000000000   .000000000000000000                     0                     0             .0             .000000000                     .0      .00000000                0       .000000000                0       .000000000            .0
P          -999999999999999999                     0                    0                    0    .000000000000000000    .000000000000000000   .000000000000000000   .000000000000000000                     0                     0             .0             .000000000                     .0      .00000000                0       .000000000                0       .000000000            .0

--- 16 row(s) selected.
>>  SELECT * FROM btsel27 ;

SELECTOR  TWO_FOUR_BIN  ONE_ONE_BIN
--------  ------------  -----------

A               1.1001          1.1
B               1.0016           .1
C                .0001          9.9

--- 3 row(s) selected.
>>---------------------------------------------------------------------
>>-- SELECT data base - checking the PROTECTION VIEWs.
>>---------------------------------------------------------------------
>>  SELECT * FROM pvsel01 ;

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
         4000                     0        5000              8  Z        johnny        8000
         8000                  1000       10000              3  B        9               90

--- 8 row(s) selected.
>>  SELECT * FROM pvsel02 ;

PIC_X_1
-------

B      
C      
B      
Q      
B      
C      
Q      
Q      

--- 8 row(s) selected.
>>  SELECT * FROM pvsel03 ;

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4          
----------  -----------  ----------  --------------------

        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 ;

VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

tom                                                                                                                                                                                                                                                                 1000  7                         200
bob                                                                                                                                                                                                                                                                  999  A                         300
bill                                                                                                                                                                                                                                                                2000  B                         500
christopher                                                                                                                                                                                                                                                         1000  white                    1000
william                                                                                                                                                                                                                                                             1000  black                    2000
marilyn                                                                                                                                                                                                                                                             2000  green                    3000

--- 6 row(s) selected.
>>
>>---------------------------------------------------------------------
>>-- SELECT data base - checking the SHORTHAND VIEWs.
>>---------------------------------------------------------------------
>>  SELECT * FROM svsel01  BROWSE ACCESS ;

PIC_X_A  PIC_X_7  PIC_9_7  CHAR_10     DECIMAL_10   BINARY_UNSIGNED  BINARY_32_SIGNED
-------  -------  -------  ----------  -----------  ---------------  ----------------

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
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.
>>  SELECT * FROM svsel02  BROWSE ACCESS ;

BINARY_UNSIGNED  PIC_X_A  PIC_X_7  DECIMAL_10 
---------------  -------  -------  -----------

             80  sue      sue              110
            100  bob      bobby             90
            100  rob      bobby             90
            100  tom      tom              100
            100  don      who            10000
             60  rod      for               25
            500  jon      does           50000
            100  ron      they           10000

--- 8 row(s) selected.
>>  SELECT * FROM svsel03  BROWSE ACCESS ;

PIC_X_A  PIC_X_7  PIC_9_7  CHAR_10     DECIMAL_10   BINARY_UNSIGNED  BINARY_32_SIGNED
-------  -------  -------  ----------  -----------  ---------------  ----------------

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.
>>  SELECT * FROM svsel04   BROWSE ACCESS ;

NEW_NAME_1  NEW_NAME_2  NEW_NAME_3
----------  ----------  ----------

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 ;

NEW_NAME_KS_S         NEW_NAME_KS_X  NEW_NAME_ES_X
--------------------  -------------  -------------

 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 ;

NEW_NAME_KS_X  NEW_NAME_ES_X
-------------  -------------

A              B            
A              C            
A              D            
A              E            
A              Q            
A              B            
A              C            
A              D            
A              E            
A              Q            
A                           
D              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            
B              C            
B              D            
B              E            
B              Q            
B                           
A              B            
A              C            
A              D            
A              E            
A              Q            
A              B            
A              C            
A              D            
A              E            
A              Q            
A                           
D              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            
B              C            
B              D            
B              E            
B              Q            
B                           
B              B            
B              C            
B              D            
B              E            
B              Q            
B              B            
B              C            
B              D            
B              E            
B              Q            
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.
>>  SELECT * FROM svsel07  BROWSE ACCESS ;

COUNT_ALL             AVG_DISTINCT           AVG_ALL                MAX_ALL                MIN_ALL                SUM_ALL
--------------------  ---------------------  ---------------------  ---------------------  ---------------------  ---------------------

                   8                 226.20                 143.62                1100.00             -.90000000                 539.00

--- 1 row(s) selected.
>>  SELECT * FROM svsel08  BROWSE ACCESS ;

MAX_DISTINCT
------------

     1000.00

--- 1 row(s) selected.
>>  SELECT * FROM svsel09  BROWSE ACCESS ;

MIN_DISTINCT
------------

        5.00

--- 1 row(s) selected.
>>  SELECT * FROM svsel10  BROWSE ACCESS ;

COUNT_DISTINCT      
--------------------

                   5

--- 1 row(s) selected.
>>  SELECT * FROM svsel11  BROWSE ACCESS ;

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      
  8000                  1000       10000      3  B      9            90  7      

--- 10 row(s) selected.
>>  SELECT * FROM svsel12  BROWSE ACCESS ;

COL_1                 COL_3                 COL_4  COL_5  
--------------------  --------------------  -----  -------

               13060                     5  Z      7      

--- 1 row(s) selected.
>>  SELECT * FROM svsel13  BROWSE ACCESS ;

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

        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.
>>
>>  SELECT * FROM svsel14  BROWSE ACCESS ;

NEW_NAME_1  NEW_NAME_3
----------  ----------

        90  A         
        80  7         
        80  B         

--- 3 row(s) selected.
>>  SELECT * FROM svsel15  BROWSE ACCESS ;

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       A         jo        B         A         ed      
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.
>>
>>control query default optimization_level '0';

--- SQL operation complete.
>>SELECT * FROM svsel16  BROWSE ACCESS ;

DATA_X3  DATA_93  SMALL_INT  BINARY_SIGNED  PIC_COMP_2
-------  -------  ---------  -------------  ----------

bob          200       2000           8000        -.25
tom          100       1000          -5000         .12

--- 2 row(s) selected.
>>SELECT * FROM svsel17  BROWSE ACCESS ;

A    B      C  
---  -----  ---

tom    .12  tom
bob   -.25  bob

--- 2 row(s) selected.
>>control query default optimization_level '3';

--- SQL operation complete.
>>
>>---------------------------------------------------------------------
>>
>>
>>LOG;
