>>  SELECT * FROM btempkey ;

*** ERROR[4211] DML operations are not allowed on a non-audited table.  Table: CAT.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[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       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

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

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

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

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

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

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

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

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

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

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
red      long     S        tommy          5       15       70
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

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

jon      does        1000  offsides          50000              500               100
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
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
-------  -------  -------  ----------  -----------  ---------------  ----------------

boe      tommy        200  ebedafiih           200               50                50
tar      what         500  none                100             8888                 0
bar      where        300  gone                200             9999              -100
car      who          400  done                160              500               500
jar      how          600  inside              160              500               500
dan      sue          100  ebediih             100              100                60
mar      why           50  house                50             7777                 0
bob      bob          100  abadefih            160              200               200

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

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

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

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

DATA_93
-------

    200
    450
    550
    100
    250
    350
    750
    650

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

DATA_93
-------

    150
    200
    100
    225
    275
    325
    125
    175

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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