>>---------------------------------------------------------------------
>>-- File: SQLQAT15                Formerly $cats.testest.qat012
>>-- Component: NonStop SQL Regression Test Suite
>>-- Description:
>>--     This test unit is a positive local test for the select statement.
>>-- It tests join-form select statements (selects on more than one table)
>>-- with where clauses (SELECT-FROM-WHERE).
>>--     This test unit uses the select global data base (sqldd01d).
>>-- Each test case in this test unit tests a particular feature of select
>>-- statements with where clauses.  For each test case, at least one
>>-- select statement is executed against the following combinations of
>>-- objects:
>>--               bt/bt
>>--               bt/pv
>>--               bt/sv
>>--               pv/pv
>>--               pv/sv
>>--               sv/sv
>>--               bt same
>>--               pv same
>>--               sv same
>>--               bt/bt/bt
>>
>>--     The testcases in this testunit are as follows:
>>--         A0: SELECT WHERE columns are compared
>>--         A1: SELECT WHERE a column or expression is BETWEEN
>>--             other columns or values or expressions.
>>--         A2: SELECT WHERE column or expression is IN an
>>--             expression list
>>--         A3: SELECT WHERE <predicate>, where <predicate> contains
>>--             AND, OR, NOT
>>--         A4: use of SELECT WHERE ... for browse access,for stable access
>>--            , for repeatable access
>>--         A5: SELECT aggregate functions with WHERE predicate
>>
>>-- All testcases are documented further below.
>>
>>-- *******************  End test unit comments  ****************************
>>
>>-- <testunit-summary>
>>-- select #5 pos/loc ufi joins where clause
>>
>>-- <testunit-specs>
>>
>>-- mode-type ufi
>>-- test-type functional
>>-- form-type pos/loc
>>-- select-test
>>
>>-- <testcase A0>
>>
>>--    <detail>
>>--       joins where clause select statement test case - this tests
>>--       the use of a where predicate that compares columns from the
>>--       tables involved in the join.
>>
>>--    <templates>
>>--       US00
>>
>>-- <ufi-input>
>>      select *
+>      from btsel01,btsel03
+>      where  btsel01.pic_x_7 =  btsel03.pic_x_7;

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  PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S
------  ----------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------  -------  -----------  --------  -------  ---------------------

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  michael        50.00  dave           50                1500.00
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  michael        70.00  joan           50                4000.00
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  7               6.00  joe            80                1200.00
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  7               6.00  john           80                2000.00

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel01,pvsel04
+>      where  btsel01.large_int =  pvsel04.medium_int;

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  VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
------  ----------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

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  bob                                                                                                                                                                                                                                                                  999  A                         300
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  bill                                                                                                                                                                                                                                                                2000  B                         500
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  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
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  tom                                                                                                                                                                                                                                                                 1000  7                         200
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  william                                                                                                                                                                                                                                                             1000  black                    2000
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  christopher                                                                                                                                                                                                                                                         1000  white                    1000

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel01,svsel13
+>      where decimal_3_unsigned = new_name_1;

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  NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
------  ----------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

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          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
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          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01,pvsel04
+>      where  pvsel01.medium_int >  pvsel04.medium_int;

BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT  VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------------  --------------------  ----------  -------------  -------  -------  ---------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

        -5000                   200        8000              6  D        michael         90  tom                                                                                                                                                                                                                                                                 1000  7                         200
        -5000                   200        8000              6  D        michael         90  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
        -5000                   200        8000              6  D        michael         90  william                                                                                                                                                                                                                                                             1000  black                    2000
        -5000                   200        8000              6  D        michael         90  christopher                                                                                                                                                                                                                                                         1000  white                    1000
        -5000                   200        8000              6  D        michael         90  bill                                                                                                                                                                                                                                                                2000  B                         500
        -5000                   200        8000              6  D        michael         90  bob                                                                                                                                                                                                                                                                  999  A                         300
           50            1000000000       10000              1  C        walter          10  tom                                                                                                                                                                                                                                                                 1000  7                         200
           50            1000000000       10000              1  C        walter          10  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
           50            1000000000       10000              1  C        walter          10  william                                                                                                                                                                                                                                                             1000  black                    2000
           50            1000000000       10000              1  C        walter          10  christopher                                                                                                                                                                                                                                                         1000  white                    1000
           50            1000000000       10000              1  C        walter          10  bill                                                                                                                                                                                                                                                                2000  B                         500
           50            1000000000       10000              1  C        walter          10  bob                                                                                                                                                                                                                                                                  999  A                         300
           60                 -1000        8000              2  A        bobby         1000  tom                                                                                                                                                                                                                                                                 1000  7                         200
           60                 -1000        8000              2  A        bobby         1000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
           60                 -1000        8000              2  A        bobby         1000  william                                                                                                                                                                                                                                                             1000  black                    2000
           60                 -1000        8000              2  A        bobby         1000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
           60                 -1000        8000              2  A        bobby         1000  bill                                                                                                                                                                                                                                                                2000  B                         500
           60                 -1000        8000              2  A        bobby         1000  bob                                                                                                                                                                                                                                                                  999  A                         300
         1000                   999        9000              4  C        7               80  tom                                                                                                                                                                                                                                                                 1000  7                         200
         1000                   999        9000              4  C        7               80  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
         1000                   999        9000              4  C        7               80  william                                                                                                                                                                                                                                                             1000  black                    2000
         1000                   999        9000              4  C        7               80  christopher                                                                                                                                                                                                                                                         1000  white                    1000
         1000                   999        9000              4  C        7               80  bill                                                                                                                                                                                                                                                                2000  B                         500
         1000                   999        9000              4  C        7               80  bob                                                                                                                                                                                                                                                                  999  A                         300
         2000              -1000000        8000              5  Q        sue           2000  tom                                                                                                                                                                                                                                                                 1000  7                         200
         2000              -1000000        8000              5  Q        sue           2000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
         2000              -1000000        8000              5  Q        sue           2000  william                                                                                                                                                                                                                                                             1000  black                    2000
         2000              -1000000        8000              5  Q        sue           2000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
         2000              -1000000        8000              5  Q        sue           2000  bill                                                                                                                                                                                                                                                                2000  B                         500
         2000              -1000000        8000              5  Q        sue           2000  bob                                                                                                                                                                                                                                                                  999  A                         300
         3000                  2000        1000              7  E        jimmy         9000  bob                                                                                                                                                                                                                                                                  999  A                         300
         4000                     0        5000              8  Z        johnny        8000  tom                                                                                                                                                                                                                                                                 1000  7                         200
         4000                     0        5000              8  Z        johnny        8000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
         4000                     0        5000              8  Z        johnny        8000  william                                                                                                                                                                                                                                                             1000  black                    2000
         4000                     0        5000              8  Z        johnny        8000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
         4000                     0        5000              8  Z        johnny        8000  bill                                                                                                                                                                                                                                                                2000  B                         500
         4000                     0        5000              8  Z        johnny        8000  bob                                                                                                                                                                                                                                                                  999  A                         300
         8000                  1000       10000              3  B        9               90  tom                                                                                                                                                                                                                                                                 1000  7                         200
         8000                  1000       10000              3  B        9               90  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
         8000                  1000       10000              3  B        9               90  william                                                                                                                                                                                                                                                             1000  black                    2000
         8000                  1000       10000              3  B        9               90  christopher                                                                                                                                                                                                                                                         1000  white                    1000
         8000                  1000       10000              3  B        9               90  bill                                                                                                                                                                                                                                                                2000  B                         500
         8000                  1000       10000              3  B        9               90  bob                                                                                                                                                                                                                                                                  999  A                         300

--- 43 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01,svsel13
+>      where small_int <> new_name_1;

BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT  NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------------  --------------------  ----------  -------------  -------  -------  ---------  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

         4000                     0        5000              8  Z        johnny        8000          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
         3000                  2000        1000              7  E        jimmy         9000          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
         2000              -1000000        8000              5  Q        sue           2000          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
         1000                   999        9000              4  C        7               80          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
           60                 -1000        8000              2  A        bobby         1000          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
           50            1000000000       10000              1  C        walter          10          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
        -5000                   200        8000              6  D        michael         90          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
         8000                  1000       10000              3  B        9               90          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
         4000                     0        5000              8  Z        johnny        8000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
         3000                  2000        1000              7  E        jimmy         9000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
         2000              -1000000        8000              5  Q        sue           2000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
           60                 -1000        8000              2  A        bobby         1000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
           50            1000000000       10000              1  C        walter          10          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        -5000                   200        8000              6  D        michael         90          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
         8000                  1000       10000              3  B        9               90          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
         4000                     0        5000              8  Z        johnny        8000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
         3000                  2000        1000              7  E        jimmy         9000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
         2000              -1000000        8000              5  Q        sue           2000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
           60                 -1000        8000              2  A        bobby         1000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
           50            1000000000       10000              1  C        walter          10          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        -5000                   200        8000              6  D        michael         90          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
         8000                  1000       10000              3  B        9               90          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
         4000                     0        5000              8  Z        johnny        8000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
         3000                  2000        1000              7  E        jimmy         9000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
         2000              -1000000        8000              5  Q        sue           2000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
           60                 -1000        8000              2  A        bobby         1000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
           50            1000000000       10000              1  C        walter          10          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 27 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13,svsel11
+>      where new_name_3 = col_8;

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            COL_1   COL_2                 COL_3       COL_4  COL_5  COL_6    COL_7   COL_8
----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------  ------  --------------------  ----------  -----  -----  -------  ------  -------

        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300      50            1000000000       10000      1  C      walter       10  A      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  7      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  7      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    2000              -1000000        8000      5  Q      sue        2000  7      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    2000              -1000000        8000      5  Q      sue        2000  7      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    3000                  2000        1000      7  E      jimmy      9000  7      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    3000                  2000        1000      7  E      jimmy      9000  7      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200   -5000                   200        8000      6  D      michael      90  7      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200   -5000                   200        8000      6  D      michael      90  7      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    4000                     0        5000      8  Z      johnny     8000  7      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    4000                     0        5000      8  Z      johnny     8000  7      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    8000                  1000       10000      3  B      9            90  7      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    8000                  1000       10000      3  B      9            90  7      

--- 13 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel01 firstt, btsel01 secondd
+>      where firstt.small_int = secondd.small_int;

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

--- 10 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01 firstt, pvsel01 secondd
+>      where firstt.small_int = secondd.large_int;

BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT  BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT
-------------  --------------------  ----------  -------------  -------  -------  ---------  -------------  --------------------  ----------  -------------  -------  -------  ---------

           60                 -1000        8000              2  A        bobby         1000           8000                  1000       10000              3  B        9               90
         2000              -1000000        8000              5  Q        sue           2000           3000                  2000        1000              7  E        jimmy         9000

--- 2 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13 firstt, svsel13 secondd
+>      where firstt.new_name_3 <> secondd.new_name_3;

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            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             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300

--- 10 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel01,btsel03,btsel04
+>      where small_int =  btsel04.medium_int;

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  PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_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  A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
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  michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
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  B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
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  7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
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  michael        50.00  dave           50                1500.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
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  5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
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  8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
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  7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
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  A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
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  michael        70.00  joan           50                4000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
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  B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
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  7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
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  michael        50.00  dave           50                1500.00  william                                                                                                                                                                                                                                                             1000  black                    2000
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  5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
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  8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
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  7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
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  A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
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  michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
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  B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
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  7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
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  michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
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  5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
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  8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
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  7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
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  A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
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  michael        70.00  joan           50                4000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
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  B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
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  7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
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  michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
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  5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
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  8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
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  7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
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  A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
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  michael        70.00  joan           50                4000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
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  B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
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  7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
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  michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
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  5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
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  8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
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  7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000

--- 40 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel01 X,btsel03 Y
+>      where X.binary_64_s = Y.binary_64_s;

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  PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S
------  ----------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------  -------  -----------  --------  -------  ---------------------

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  7               6.00  john           80                2000.00
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               5.00  make           90                 200.00
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  7               6.00  joe            80                1200.00
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  8               6.00  joe            80                1200.00
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  michael        50.00  dave           50                1500.00
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  7               6.00  joe            80                1200.00
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  8               6.00  joe            80                1200.00
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  7               6.00  john           80                2000.00
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  7               6.00  john           80                2000.00
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  7               6.00  john           80                2000.00

--- 10 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel02,pvsel03,pvsel04
+>      where pic_x_1 = new_name_3;

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

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

--- 18 row(s) selected.
>>-- <end-input>
>>
>>
>>
>>-- <testcase A1>
>>
>>-- <detail>
>>--    select joins where clause test case - this tests the use of a
>>--    BETWEEN predicate in a where clause.
>>
>>-- <templates>
>>--    US00
>>
>>-- <ufi-input>
>>      select *
+>      from btsel01,btsel03
+>      where  btsel01.binary_32_u between pic_comp_1 and
+>             btsel03.binary_32_u;

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  PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S
------  ----------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------  -------  -----------  --------  -------  ---------------------

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  michael        70.00  joan           50                4000.00
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  michael        50.00  dave           50                1500.00
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  5            1000.00  5             100                1000.00
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  michael        70.00  joan           50                4000.00
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  5            1000.00  5             100                1000.00

--- 5 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel01,pvsel01
+>      where  btsel01.small_int between  btsel01.medium_int
+>            and  pvsel01.large_int;

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  BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT
------  ----------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------  -------------  --------------------  ----------  -------------  -------  -------  ---------

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             50            1000000000       10000              1  C        walter          10
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             50            1000000000       10000              1  C        walter          10

--- 2 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel01,svsel13
+>      where  svsel13.pic_comp_1 between  svsel13.new_name_1
+>            and  btsel01.small_int;

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  NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_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          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
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          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
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          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
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          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
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          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
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          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
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          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
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          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300

--- 16 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01,pvsel04
+>      where  pvsel04.pic_comp_1 between 100 and
+>             pvsel01.small_int;

BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT  VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------------  --------------------  ----------  -------------  -------  -------  ---------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

           60                 -1000        8000              2  A        bobby         1000  tom                                                                                                                                                                                                                                                                 1000  7                         200
           60                 -1000        8000              2  A        bobby         1000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
           60                 -1000        8000              2  A        bobby         1000  bill                                                                                                                                                                                                                                                                2000  B                         500
           60                 -1000        8000              2  A        bobby         1000  bob                                                                                                                                                                                                                                                                  999  A                         300
         2000              -1000000        8000              5  Q        sue           2000  tom                                                                                                                                                                                                                                                                 1000  7                         200
         2000              -1000000        8000              5  Q        sue           2000  william                                                                                                                                                                                                                                                             1000  black                    2000
         2000              -1000000        8000              5  Q        sue           2000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
         2000              -1000000        8000              5  Q        sue           2000  bill                                                                                                                                                                                                                                                                2000  B                         500
         2000              -1000000        8000              5  Q        sue           2000  bob                                                                                                                                                                                                                                                                  999  A                         300
         3000                  2000        1000              7  E        jimmy         9000  tom                                                                                                                                                                                                                                                                 1000  7                         200
         3000                  2000        1000              7  E        jimmy         9000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
         3000                  2000        1000              7  E        jimmy         9000  william                                                                                                                                                                                                                                                             1000  black                    2000
         3000                  2000        1000              7  E        jimmy         9000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
         3000                  2000        1000              7  E        jimmy         9000  bill                                                                                                                                                                                                                                                                2000  B                         500
         3000                  2000        1000              7  E        jimmy         9000  bob                                                                                                                                                                                                                                                                  999  A                         300
         4000                     0        5000              8  Z        johnny        8000  tom                                                                                                                                                                                                                                                                 1000  7                         200
         4000                     0        5000              8  Z        johnny        8000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
         4000                     0        5000              8  Z        johnny        8000  william                                                                                                                                                                                                                                                             1000  black                    2000
         4000                     0        5000              8  Z        johnny        8000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
         4000                     0        5000              8  Z        johnny        8000  bill                                                                                                                                                                                                                                                                2000  B                         500
         4000                     0        5000              8  Z        johnny        8000  bob                                                                                                                                                                                                                                                                  999  A                         300

--- 21 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01,svsel13
+>      where  pvsel01.small_int between new_name_1 and
+>            pic_comp_1;

BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT  NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------------  --------------------  ----------  -------------  -------  -------  ---------  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

        -5000                   200        8000              6  D        michael         90          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        -5000                   200        8000              6  D        michael         90          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        -5000                   200        8000              6  D        michael         90          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
        -5000                   200        8000              6  D        michael         90          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
         1000                   999        9000              4  C        7               80          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
         1000                   999        9000              4  C        7               80          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
         1000                   999        9000              4  C        7               80          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
         8000                  1000       10000              3  B        9               90          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
         8000                  1000       10000              3  B        9               90          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
         8000                  1000       10000              3  B        9               90          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
         8000                  1000       10000              3  B        9               90          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300

--- 11 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from  svsel13,svsel11
+>      where medium_int between col_7
+>            and 1000;

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            COL_1   COL_2                 COL_3       COL_4  COL_5  COL_6    COL_7   COL_8
----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------  ------  --------------------  ----------  -----  -----  -------  ------  -------

        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200   -5000                   200        8000      6  D      michael      90  7      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200   -5000                   200        8000      6  D      michael      90  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300   -5000                   200        8000      6  D      michael      90  7      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200      50            1000000000       10000      1  C      walter       10  A      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200      50            1000000000       10000      1  C      walter       10  A      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300      50            1000000000       10000      1  C      walter       10  A      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  7      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  7      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  8      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  8      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    1000                   999        9000      4  C      7            80  michael
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    1000                   999        9000      4  C      7            80  michael
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    1000                   999        9000      4  C      7            80  michael
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    8000                  1000       10000      3  B      9            90  7      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    8000                  1000       10000      3  B      9            90  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    8000                  1000       10000      3  B      9            90  7      

--- 16 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03 firstt,btsel03 secondd
+>      where firstt.binary_64_s between secondd.pic_9_7
+>            and 1201;

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

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

--- 32 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel03 firstt, pvsel03 secondd
+>      where firstt.new_name_1 between secondd.new_name_2
+>            and 100;

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

        90         5.00  A             216172782159534337          90         5.00  A             216172782159534337
        90         5.00  A             216172782159534337          80         6.00  B             216172782159534343
        90         5.00  A             216172782159534337          80         6.00  7             216172782159534342
        90         5.00  A             216172782159534337          80         6.00  7             216172782159534338
        80         6.00  7             216172782159534338          90         5.00  A             216172782159534337
        80         6.00  7             216172782159534338          80         6.00  B             216172782159534343
        80         6.00  7             216172782159534338          80         6.00  7             216172782159534342
        80         6.00  7             216172782159534338          80         6.00  7             216172782159534338
        80         6.00  7             216172782159534342          90         5.00  A             216172782159534337
        80         6.00  7             216172782159534342          80         6.00  B             216172782159534343
        80         6.00  7             216172782159534342          80         6.00  7             216172782159534342
        80         6.00  7             216172782159534342          80         6.00  7             216172782159534338
        80         6.00  B             216172782159534343          90         5.00  A             216172782159534337
        80         6.00  B             216172782159534343          80         6.00  B             216172782159534343
        80         6.00  B             216172782159534343          80         6.00  7             216172782159534342
        80         6.00  B             216172782159534343          80         6.00  7             216172782159534338

--- 16 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13 firstt,svsel13 secondd
+>      where firstt.medium_int between secondd.pic_comp_1
+>            and 1000;

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            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             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300

--- 12 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03 X,btsel04 Y
+>      where Y.medium_int between X.binary_64_s and pic_comp_1;

PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------  -----------  --------  -------  ---------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000

--- 10 row(s) selected.
>>-- <ufi-input>
>>      select * from btsel02,btsel03,btsel04
+>      where pic_x_1 between  btsel03.pic_x_7 and 'B';

PIC_X_1  PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------  -------  -----------  --------  -------  ---------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

B        A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        A               5.00  make           90                 200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        A               5.00  make           90                 200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        A               5.00  make           90                 200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        A               5.00  make           90                 200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        A               5.00  make           90                 200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        A               5.00  make           90                 200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        5            1000.00  5             100                1000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        5            1000.00  5             100                1000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        5            1000.00  5             100                1000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        5            1000.00  5             100                1000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        5            1000.00  5             100                1000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        5            1000.00  5             100                1000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300

--- 144 row(s) selected.
>>-- <end-input>
>>
>>
>>
>>-- <testcase A2>
>>
>>-- <detail>
>>--    select joins where clause test case - this tests the use
>>--    of an IN predicate in the where clause.
>>
>>-- <templates>
>>--    US00
>>
>>-- <ufi-input>
>>      select *
+>      from btsel03,btsel04
+>      where pic_comp_1 in (medium_int,binary_64_s);

PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------  -----------  --------  -------  ---------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000

--- 11 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03,pvsel01
+>      where binary_64_s in (small_int,medium_int,large_int);

PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT
-------  -----------  --------  -------  ---------------------  -------------  --------------------  ----------  -------------  -------  -------  ---------

A               5.00  make           90                 200.00          -5000                   200        8000              6  D        michael         90
5            1000.00  5             100                1000.00             60                 -1000        8000              2  A        bobby         1000
7               6.00  john           80                2000.00           2000              -1000000        8000              5  Q        sue           2000
7               6.00  john           80                2000.00           3000                  2000        1000              7  E        jimmy         9000
5            1000.00  5             100                1000.00           3000                  2000        1000              7  E        jimmy         9000
5            1000.00  5             100                1000.00           8000                  1000       10000              3  B        9               90

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel08,svsel13
+>      where medium_int in (large_int,pic_comp_1);

LARGE_INT             PIC_252                                                                                                                                                                                                                                                       PIC_1  NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
--------------------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

                1000  harveys                                                                                                                                                                                                                                                       B              80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
                1000  harveys                                                                                                                                                                                                                                                       B              80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
                2000  alexander                                                                                                                                                                                                                                                     B              80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01,pvsel04
+>      where  pvsel04.medium_int in ( pvsel01.medium_int,
+>            large_int, pvsel01.small_int);

BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT  VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------------  --------------------  ----------  -------------  -------  -------  ---------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

           60                 -1000        8000              2  A        bobby         1000  tom                                                                                                                                                                                                                                                                 1000  7                         200
           60                 -1000        8000              2  A        bobby         1000  william                                                                                                                                                                                                                                                             1000  black                    2000
           60                 -1000        8000              2  A        bobby         1000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
         1000                   999        9000              4  C        7               80  bob                                                                                                                                                                                                                                                                  999  A                         300
         2000              -1000000        8000              5  Q        sue           2000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
         2000              -1000000        8000              5  Q        sue           2000  bill                                                                                                                                                                                                                                                                2000  B                         500
         3000                  2000        1000              7  E        jimmy         9000  tom                                                                                                                                                                                                                                                                 1000  7                         200
         3000                  2000        1000              7  E        jimmy         9000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
         3000                  2000        1000              7  E        jimmy         9000  william                                                                                                                                                                                                                                                             1000  black                    2000
         3000                  2000        1000              7  E        jimmy         9000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
         3000                  2000        1000              7  E        jimmy         9000  bill                                                                                                                                                                                                                                                                2000  B                         500
         8000                  1000       10000              3  B        9               90  tom                                                                                                                                                                                                                                                                 1000  7                         200
         8000                  1000       10000              3  B        9               90  william                                                                                                                                                                                                                                                             1000  black                    2000
         8000                  1000       10000              3  B        9               90  christopher                                                                                                                                                                                                                                                         1000  white                    1000

--- 14 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel04,svsel13
+>      where  svsel13.medium_int in ( pvsel04.medium_int,
+>             pvsel04.pic_comp_1,80);

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

tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
bob                                                                                                                                                                                                                                                                  999  A                         300          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
bill                                                                                                                                                                                                                                                                2000  B                         500          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
christopher                                                                                                                                                                                                                                                         1000  white                    1000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
christopher                                                                                                                                                                                                                                                         1000  white                    1000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
william                                                                                                                                                                                                                                                             1000  black                    2000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
william                                                                                                                                                                                                                                                             1000  black                    2000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
william                                                                                                                                                                                                                                                             1000  black                    2000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
marilyn                                                                                                                                                                                                                                                             2000  green                    3000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 10 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13,svsel11
+>      where medium_int in (col_1,col_3);

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            COL_1   COL_2                 COL_3       COL_4  COL_5  COL_6    COL_7   COL_8
----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------  ------  --------------------  ----------  -----  -----  -------  ------  -------

        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    1000                   999        9000      4  C      7            80  michael
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    1000                   999        9000      4  C      7            80  michael
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    2000              -1000000        8000      5  Q      sue        2000  7      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    2000              -1000000        8000      5  Q      sue        2000  8      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    3000                  2000        1000      7  E      jimmy      9000  7      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    3000                  2000        1000      7  E      jimmy      9000  7      

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel05 firstt,btsel05 secondd
+>      where firstt.col_2 in (secondd.col_5,secondd.col_6,
+>                            secondd.col_4);

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

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

--- 5 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel04 firstt,pvsel04 secondd
+>      where firstt.medium_int in (secondd.pic_comp_1,
+>                                 secondd.pic_comp_1);

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

tom                                                                                                                                                                                                                                                                 1000  7                         200  christopher                                                                                                                                                                                                                                                         1000  white                    1000
bill                                                                                                                                                                                                                                                                2000  B                         500  william                                                                                                                                                                                                                                                             1000  black                    2000
christopher                                                                                                                                                                                                                                                         1000  white                    1000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
william                                                                                                                                                                                                                                                             1000  black                    2000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
marilyn                                                                                                                                                                                                                                                             2000  green                    3000  william                                                                                                                                                                                                                                                             1000  black                    2000

--- 5 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13 firstt,svsel13 secondd
+>      where firstt.medium_int in (secondd.new_name_1,
+>            secondd.pic_comp_1);

--- 0 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel07 X,btsel08 Y
+>      where X.pic_x_b in (Y.pic_1,pic_252);

PIC_X_A  PIC_X_B  PIC_X_C  LARGE_INT             PIC_252                                                                                                                                                                                                                                                       PIC_1
-------  -------  -------  --------------------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----

JO       D        em                       4000  valley                                                                                                                                                                                                                                                        D    
JO       D        em                       3000  george                                                                                                                                                                                                                                                        D    
al       Q        al                        300  Q                                                                                                                                                                                                                                                             X    
al       E        bo                        100  carltons                                                                                                                                                                                                                                                      E    

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel02,btsel03,btsel04
+>      where pic_x_1 in ( btsel03.pic_x_7, btsel04.pic_x_7);

PIC_X_1  PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------  -------  -----------  --------  -------  ---------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

B        A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        michael        70.00  joan           50                4000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        michael        70.00  joan           50                4000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        michael        70.00  joan           50                4000.00  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 45 row(s) selected.
>>-- <end-input>
>>
>>
>>
>>-- <testcase A3>
>>
>>-- <detail>
>>--    select joins where clause test case - this tests the use of AND,
>>--    OR, NOT in the where clause predicate.
>>
>>-- <templates>
>>--    US00
>>
>>-- <ufi-input>
>>      select *
+>      from btsel04,btsel06
+>      where ( btsel04.var_char like 'b_%') or
+>            ( btsel06.pic_x_a like '__e');

VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            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
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------  -------  -------  -------  -----  -----  -----  -----  -----  -----  -----  -----  -----  ------  -----------  -----------  -----------  -----------  -----------  -----------  ----------  ----------  ----------  ----------  -----------  -----------  -----------  -----------  ----------  ----------  ----------  ----------  --------------------  --------------------  --------------------  --------------------  --------------------  --------------------  -------------------  -------------------  -------------------  -------------------

tom                                                                                                                                                                                                                                                                 1000  7                         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
tom                                                                                                                                                                                                                                                                 1000  7                         200  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
tom                                                                                                                                                                                                                                                                 1000  7                         200  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
tom                                                                                                                                                                                                                                                                 1000  7                         200  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
tom                                                                                                                                                                                                                                                                 1000  7                         200  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
tom                                                                                                                                                                                                                                                                 1000  7                         200  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
tom                                                                                                                                                                                                                                                                 1000  7                         200  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
bob                                                                                                                                                                                                                                                                  999  A                         300  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
bob                                                                                                                                                                                                                                                                  999  A                         300  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
bob                                                                                                                                                                                                                                                                  999  A                         300  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
bob                                                                                                                                                                                                                                                                  999  A                         300  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
bob                                                                                                                                                                                                                                                                  999  A                         300  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
bob                                                                                                                                                                                                                                                                  999  A                         300  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
bob                                                                                                                                                                                                                                                                  999  A                         300  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
bob                                                                                                                                                                                                                                                                  999  A                         300  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                                                                                                                                                                                                                                                                  200  sue                       100  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                                                                                                                                                                                                                                                                  200  sue                       100  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
sue                                                                                                                                                                                                                                                                  200  sue                       100  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                                                                                                                                                                                                                                                                  200  sue                       100  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                                                                                                                                                                                                                                                                  200  sue                       100  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
sue                                                                                                                                                                                                                                                                  200  sue                       100  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
sue                                                                                                                                                                                                                                                                  200  sue                       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
bobby                                                                                                                                                                                                                                                                200  sue                       100  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
bobby                                                                                                                                                                                                                                                                200  sue                       100  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
bobby                                                                                                                                                                                                                                                                200  sue                       100  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
bobby                                                                                                                                                                                                                                                                200  sue                       100  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
bobby                                                                                                                                                                                                                                                                200  sue                       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
bobby                                                                                                                                                                                                                                                                200  sue                       100  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
bobby                                                                                                                                                                                                                                                                200  sue                       100  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
bobby                                                                                                                                                                                                                                                                200  sue                       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
bill                                                                                                                                                                                                                                                                2000  B                         500  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
bill                                                                                                                                                                                                                                                                2000  B                         500  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
bill                                                                                                                                                                                                                                                                2000  B                         500  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
bill                                                                                                                                                                                                                                                                2000  B                         500  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
bill                                                                                                                                                                                                                                                                2000  B                         500  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
bill                                                                                                                                                                                                                                                                2000  B                         500  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
bill                                                                                                                                                                                                                                                                2000  B                         500  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
bill                                                                                                                                                                                                                                                                2000  B                         500  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
christopher                                                                                                                                                                                                                                                         1000  white                    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
christopher                                                                                                                                                                                                                                                         1000  white                    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
christopher                                                                                                                                                                                                                                                         1000  white                    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
christopher                                                                                                                                                                                                                                                         1000  white                    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
christopher                                                                                                                                                                                                                                                         1000  white                    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
christopher                                                                                                                                                                                                                                                         1000  white                    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
christopher                                                                                                                                                                                                                                                         1000  white                    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
william                                                                                                                                                                                                                                                             1000  black                    2000  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
william                                                                                                                                                                                                                                                             1000  black                    2000  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
william                                                                                                                                                                                                                                                             1000  black                    2000  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
william                                                                                                                                                                                                                                                             1000  black                    2000  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
william                                                                                                                                                                                                                                                             1000  black                    2000  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
william                                                                                                                                                                                                                                                             1000  black                    2000  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
william                                                                                                                                                                                                                                                             1000  black                    2000  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
marilyn                                                                                                                                                                                                                                                             2000  green                    3000  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
marilyn                                                                                                                                                                                                                                                             2000  green                    3000  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
marilyn                                                                                                                                                                                                                                                             2000  green                    3000  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
marilyn                                                                                                                                                                                                                                                             2000  green                    3000  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
marilyn                                                                                                                                                                                                                                                             2000  green                    3000  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
marilyn                                                                                                                                                                                                                                                             2000  green                    3000  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
marilyn                                                                                                                                                                                                                                                             2000  green                    3000  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

--- 59 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel04,pvsel01
+>      where ( btsel04.medium_int =  pvsel01.small_int)
+>            and ( btsel04.pic_comp_1 > 500);

VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------  -------------  --------------------  ----------  -------------  -------  -------  ---------

christopher                                                                                                                                                                                                                                                         1000  white                    1000             60                 -1000        8000              2  A        bobby         1000
william                                                                                                                                                                                                                                                             1000  black                    2000             60                 -1000        8000              2  A        bobby         1000
marilyn                                                                                                                                                                                                                                                             2000  green                    3000           2000              -1000000        8000              5  Q        sue           2000

--- 3 row(s) selected.
>>
>>
>>
>>
>>-- <ufi-input>
>>      select *
+>      from btsel04,svsel13
+>      where ( btsel04.medium_int =  svsel13.medium_int)
+>            and not ( btsel04.pic_x_7 like 'sue');

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

tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
william                                                                                                                                                                                                                                                             1000  black                    2000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
william                                                                                                                                                                                                                                                             1000  black                    2000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
christopher                                                                                                                                                                                                                                                         1000  white                    1000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
christopher                                                                                                                                                                                                                                                         1000  white                    1000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
bob                                                                                                                                                                                                                                                                  999  A                         300          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
bill                                                                                                                                                                                                                                                                2000  B                         500          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
marilyn                                                                                                                                                                                                                                                             2000  green                    3000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 9 row(s) selected.
>>
>>-- <ufi-input>
>>      select *
+>      from pvsel01,pvsel04
+>      where ( pvsel01.large_int =  pvsel04.medium_int)
+>            or ( pvsel01.pic_x_7 =  pvsel04.pic_x_7);

BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT  VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------------  --------------------  ----------  -------------  -------  -------  ---------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

         1000                   999        9000              4  C        7               80  tom                                                                                                                                                                                                                                                                 1000  7                         200
         1000                   999        9000              4  C        7               80  bob                                                                                                                                                                                                                                                                  999  A                         300
         3000                  2000        1000              7  E        jimmy         9000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
         3000                  2000        1000              7  E        jimmy         9000  bill                                                                                                                                                                                                                                                                2000  B                         500
         8000                  1000       10000              3  B        9               90  tom                                                                                                                                                                                                                                                                 1000  7                         200
         8000                  1000       10000              3  B        9               90  william                                                                                                                                                                                                                                                             1000  black                    2000
         8000                  1000       10000              3  B        9               90  christopher                                                                                                                                                                                                                                                         1000  white                    1000

--- 7 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01,svsel13
+>      where large_int < 0 and
+>            new_name_1 = 80;

BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT  NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------------  --------------------  ----------  -------------  -------  -------  ---------  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

           60                 -1000        8000              2  A        bobby         1000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
         2000              -1000000        8000              5  Q        sue           2000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
           60                 -1000        8000              2  A        bobby         1000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
         2000              -1000000        8000              5  Q        sue           2000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
           60                 -1000        8000              2  A        bobby         1000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
         2000              -1000000        8000              5  Q        sue           2000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13,svsel11
+>      where (new_name_1 = 80) and
+>            (new_name_3 = '7') and
+>            ((col_6 = 'bobby') or
+>             (col_6 = 'michael'));

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            COL_1   COL_2                 COL_3       COL_4  COL_5  COL_6    COL_7   COL_8
----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------  ------  --------------------  ----------  -----  -----  -------  ------  -------

        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200   -5000                   200        8000      6  D      michael      90  7      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  8      
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  7      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200   -5000                   200        8000      6  D      michael      90  7      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  8      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  7      

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03 firstt,btsel03 secondd
+>      where (firstt.binary_32_u <> secondd.binary_32_u) and
+>            firstt.pic_x4_a like 'jo%';

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

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

--- 19 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel03 firstt,pvsel03 secondd
+>      where (firstt.new_name_1 = secondd.new_name_1) and
+>            ((firstt.new_name_2 * 15) < secondd.new_name_1);

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

        90         5.00  A             216172782159534337          90         5.00  A             216172782159534337

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13 firstt,svsel13 secondd
+>      where (firstt.new_name_1 = secondd.new_name_1) and
+>            ((firstt.new_name_2 * 15) < secondd.new_name_1);

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            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             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03 X,btsel04 Y
+>      where (X.binary_64_s = Y.pic_comp_1) or
+>            (X.pic_x_7 = Y.pic_x_7);

PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------  -----------  --------  -------  ---------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000

--- 8 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel02,btsel03,btsel04
+>      where (pic_x_1 = 'c') and
+>            (pic_9_7 = 50) and
+>            (var_char = 'christopher');

--- 0 row(s) selected.
>>-- <end-input>
>>
>>
>>
>>-- <testcase A4>
>>
>>-- <detail>
>>--    select joins where clause test case - this tests the use
>>--    of the for browse access, for stable access , and for repeatable access
>>--    clauses.  Only syntax is checked here.
>>
>>-- <templates>
>>--    US00
>>
>>-- <ufi-input>
>>      select *
+>      from btsel02,btsel03
+>      where pic_x_1 = 'c'
+>      for browse access;

--- 0 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel02,btsel03
+>      where pic_x_1 = 'c'
+>      for stable access;

--- 0 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel02,btsel03
+>      where pic_x_1 = 'c'
+>      for repeatable access;

--- 0 row(s) selected.
>>
>>-- <comment> **** audited table, non-audited table ****
>>-- <comment> **** must specify for browse access for this test ****
>>-- <ufi-input>
>>      select *
+>      from btsel03,btsel05
+>      where pic_x4_a = pic_x_a
+>      for browse access;

PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            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
-------  -----------  --------  -------  ---------------------  -------  -------  -------  -----  -----  -----  -----  -----  -----  -----  -----  -----  ------

7               6.00  joe            80                1200.00  joe      A        al       pablo  david  amy    amy    steve  steve  walt   mojo   joe    percy 
8               6.00  joe            80                1200.00  joe      A        al       pablo  david  amy    amy    steve  steve  walt   mojo   joe    percy 

--- 2 row(s) selected.
>>
>>-- <ufi-input>
>>      select *
+>      from btsel03,pvsel01
+>      where  pvsel01.small_int =  btsel03.binary_64_s
+>      for browse access;

PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT
-------  -----------  --------  -------  ---------------------  -------------  --------------------  ----------  -------------  -------  -------  ---------

5            1000.00  5             100                1000.00             60                 -1000        8000              2  A        bobby         1000
7               6.00  john           80                2000.00           2000              -1000000        8000              5  Q        sue           2000

--- 2 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03,pvsel01
+>      where  pvsel01.small_int =  btsel03.binary_64_s
+>      for stable access;

PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT
-------  -----------  --------  -------  ---------------------  -------------  --------------------  ----------  -------------  -------  -------  ---------

5            1000.00  5             100                1000.00             60                 -1000        8000              2  A        bobby         1000
7               6.00  john           80                2000.00           2000              -1000000        8000              5  Q        sue           2000

--- 2 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03,pvsel01
+>      where  pvsel01.small_int =  btsel03.binary_64_s
+>      for repeatable access;

PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT
-------  -----------  --------  -------  ---------------------  -------------  --------------------  ----------  -------------  -------  -------  ---------

5            1000.00  5             100                1000.00             60                 -1000        8000              2  A        bobby         1000
7               6.00  john           80                2000.00           2000              -1000000        8000              5  Q        sue           2000

--- 2 row(s) selected.
>>
>>-- <ufi-input>
>>      select *
+>      from btsel03,svsel13
+>      where binary_64_s = medium_int
+>      for browse access;

PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------  -----------  --------  -------  ---------------------  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

5            1000.00  5             100                1000.00          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
5            1000.00  5             100                1000.00          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
7               6.00  john           80                2000.00          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03,svsel13
+>      where binary_64_s = medium_int
+>      for stable access;

PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------  -----------  --------  -------  ---------------------  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

5            1000.00  5             100                1000.00          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
5            1000.00  5             100                1000.00          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
7               6.00  john           80                2000.00          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03,svsel13
+>      where binary_64_s = medium_int
+>      for repeatable access;

PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------  -----------  --------  -------  ---------------------  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

5            1000.00  5             100                1000.00          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
5            1000.00  5             100                1000.00          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
7               6.00  john           80                2000.00          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel03,pvsel04
+>      where new_name_3 = pic_x_7
+>      for 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             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel03,pvsel04
+>      where new_name_3 = pic_x_7
+>      for stable 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             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel03,pvsel04
+>      where new_name_3 = pic_x_7
+>      for repeatable 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             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01,svsel13
+>      where  pvsel01.small_int =  svsel13.medium_int
+>      for browse access;

BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT  NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------------  --------------------  ----------  -------------  -------  -------  ---------  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

           60                 -1000        8000              2  A        bobby         1000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
           60                 -1000        8000              2  A        bobby         1000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
         2000              -1000000        8000              5  Q        sue           2000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01,svsel13
+>      where  pvsel01.small_int =  svsel13.medium_int
+>      for stable access;

BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT  NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------------  --------------------  ----------  -------------  -------  -------  ---------  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

           60                 -1000        8000              2  A        bobby         1000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
           60                 -1000        8000              2  A        bobby         1000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
         2000              -1000000        8000              5  Q        sue           2000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01,svsel13
+>      where  pvsel01.small_int =  svsel13.medium_int
+>      for repeatable access;

BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT  NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------------  --------------------  ----------  -------------  -------  -------  ---------  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

           60                 -1000        8000              2  A        bobby         1000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
           60                 -1000        8000              2  A        bobby         1000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
         2000              -1000000        8000              5  Q        sue           2000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13,svsel11
+>      where new_name_1 = col_7
+>      for browse access;

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            COL_1   COL_2                 COL_3       COL_4  COL_5  COL_6    COL_7   COL_8
----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------  ------  --------------------  ----------  -----  -----  -------  ------  -------

        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    1000                   999        9000      4  C      7            80  michael
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    1000                   999        9000      4  C      7            80  michael
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    1000                   999        9000      4  C      7            80  michael
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300   -5000                   200        8000      6  D      michael      90  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    8000                  1000       10000      3  B      9            90  7      

--- 5 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13,svsel11
+>      where new_name_1 = col_7
+>      for stable access;

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            COL_1   COL_2                 COL_3       COL_4  COL_5  COL_6    COL_7   COL_8
----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------  ------  --------------------  ----------  -----  -----  -------  ------  -------

        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    1000                   999        9000      4  C      7            80  michael
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    1000                   999        9000      4  C      7            80  michael
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    1000                   999        9000      4  C      7            80  michael
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300   -5000                   200        8000      6  D      michael      90  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    8000                  1000       10000      3  B      9            90  7      

--- 5 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13,svsel11
+>      where new_name_1 = col_7
+>      for repeatable access;

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            COL_1   COL_2                 COL_3       COL_4  COL_5  COL_6    COL_7   COL_8
----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------  ------  --------------------  ----------  -----  -----  -------  ------  -------

        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    1000                   999        9000      4  C      7            80  michael
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    1000                   999        9000      4  C      7            80  michael
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    1000                   999        9000      4  C      7            80  michael
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300   -5000                   200        8000      6  D      michael      90  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    8000                  1000       10000      3  B      9            90  7      

--- 5 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03 firstt,btsel03 secondd
+>      where firstt.binary_64_s = secondd.binary_64_s
+>      for browse access;

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

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

--- 10 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03 firstt,btsel03 secondd
+>      where firstt.binary_64_s = secondd.binary_64_s
+>      for stable access;

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

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

--- 10 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03 firstt,btsel03 secondd
+>      where firstt.binary_64_s = secondd.binary_64_s
+>      for repeatable access;

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

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

--- 10 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel03 firstt,pvsel03 secondd
+>      where firstt.new_name_1 = secondd.new_name_1
+>      for browse access;

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

        90         5.00  A             216172782159534337          90         5.00  A             216172782159534337
        80         6.00  7             216172782159534338          80         6.00  7             216172782159534338
        80         6.00  7             216172782159534338          80         6.00  B             216172782159534343
        80         6.00  7             216172782159534338          80         6.00  7             216172782159534342
        80         6.00  7             216172782159534342          80         6.00  7             216172782159534338
        80         6.00  7             216172782159534342          80         6.00  B             216172782159534343
        80         6.00  7             216172782159534342          80         6.00  7             216172782159534342
        80         6.00  B             216172782159534343          80         6.00  7             216172782159534338
        80         6.00  B             216172782159534343          80         6.00  B             216172782159534343
        80         6.00  B             216172782159534343          80         6.00  7             216172782159534342

--- 10 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel03 firstt,pvsel03 secondd
+>      where firstt.new_name_1 = secondd.new_name_1
+>      for stable access;

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

        90         5.00  A             216172782159534337          90         5.00  A             216172782159534337
        80         6.00  7             216172782159534338          80         6.00  7             216172782159534338
        80         6.00  7             216172782159534338          80         6.00  B             216172782159534343
        80         6.00  7             216172782159534338          80         6.00  7             216172782159534342
        80         6.00  7             216172782159534342          80         6.00  7             216172782159534338
        80         6.00  7             216172782159534342          80         6.00  B             216172782159534343
        80         6.00  7             216172782159534342          80         6.00  7             216172782159534342
        80         6.00  B             216172782159534343          80         6.00  7             216172782159534338
        80         6.00  B             216172782159534343          80         6.00  B             216172782159534343
        80         6.00  B             216172782159534343          80         6.00  7             216172782159534342

--- 10 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel03 firstt,pvsel03 secondd
+>      where firstt.new_name_1 = secondd.new_name_1
+>      for repeatable access;

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

        90         5.00  A             216172782159534337          90         5.00  A             216172782159534337
        80         6.00  7             216172782159534338          80         6.00  7             216172782159534338
        80         6.00  7             216172782159534338          80         6.00  B             216172782159534343
        80         6.00  7             216172782159534338          80         6.00  7             216172782159534342
        80         6.00  7             216172782159534342          80         6.00  7             216172782159534338
        80         6.00  7             216172782159534342          80         6.00  B             216172782159534343
        80         6.00  7             216172782159534342          80         6.00  7             216172782159534342
        80         6.00  B             216172782159534343          80         6.00  7             216172782159534338
        80         6.00  B             216172782159534343          80         6.00  B             216172782159534343
        80         6.00  B             216172782159534343          80         6.00  7             216172782159534342

--- 10 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13 firstt,svsel13 secondd
+>      where firstt.pic_comp_1 = secondd.pic_comp_1
+>      for browse access;

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            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             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13 firstt,svsel13 secondd
+>      where firstt.pic_comp_1 = secondd.pic_comp_1
+>      for stable access;

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            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             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13 firstt,svsel13 secondd
+>      where firstt.pic_comp_1 = secondd.pic_comp_1
+>      for repeatable access;

NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            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             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel05 firstt,btsel05 secondd
+>      where firstt.col_1 = secondd.col_1
+>      for browse access;

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  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   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   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    deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk  
deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk    not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk  
deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk    why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk  
deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk    red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
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  
can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk    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    not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk  
can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk    why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk  
can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk    red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
can      D        by       lowry  steve  slope  debby  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    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    deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk  
red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk    not      B        on       lowry  mary   mogul  pammy  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  
red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk    red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk    can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk  
why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk    deb      D        jo       lowry  mary   sunny  debra  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  
why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk    why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk  
why      B        so       lowry  amy    squaw  tammy  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    can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk    deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk    not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  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    red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk    can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk  

--- 28 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel05 firstt,btsel05 secondd
+>      where firstt.col_1 = secondd.col_1
+>      for stable access;

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  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   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   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    deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk  
deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk    not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk  
deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk    why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk  
deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk    red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
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  
can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk    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    not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk  
can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk    why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk  
can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk    red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
can      D        by       lowry  steve  slope  debby  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    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    deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk  
red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk    not      B        on       lowry  mary   mogul  pammy  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  
red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk    red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk    can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk  
why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk    deb      D        jo       lowry  mary   sunny  debra  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  
why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk    why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk  
why      B        so       lowry  amy    squaw  tammy  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    can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk    deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk    not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  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    red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk    can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk  

--- 28 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel05 firstt,btsel05 secondd
+>      where firstt.col_1 = secondd.col_1
+>      for repeatable access;

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  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   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   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    deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk  
deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk    not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk  
deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk    why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk  
deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk    red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
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  
can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk    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    not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk  
can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk    why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk  
can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk    red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
can      D        by       lowry  steve  slope  debby  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    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    deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk  
red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk    not      B        on       lowry  mary   mogul  pammy  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  
red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk    red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk    can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk  
why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk    deb      D        jo       lowry  mary   sunny  debra  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  
why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk    why      B        so       lowry  amy    squaw  tammy  junk   junk   junk   junk   junk   junk  
why      B        so       lowry  amy    squaw  tammy  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    can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk    deb      D        jo       lowry  mary   sunny  debra  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk    not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  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    red      B        go       lowry  sue    ski    cammy  junk   junk   junk   junk   junk   junk  
not      B        on       lowry  mary   mogul  pammy  junk   junk   junk   junk   junk   junk    can      D        by       lowry  steve  slope  debby  junk   junk   junk   junk   junk   junk  

--- 28 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel02,btsel03,btsel04
+>      where pic_x_1 =  btsel04.pic_x_7
+>      for browse access;

PIC_X_1  PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------  -------  -----------  --------  -------  ---------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

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

--- 24 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel02,btsel03,btsel04
+>      where pic_x_1 =  btsel04.pic_x_7
+>      for stable access;

PIC_X_1  PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------  -------  -----------  --------  -------  ---------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

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

--- 24 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel02,btsel03,btsel04
+>      where pic_x_1 =  btsel04.pic_x_7
+>      for repeatable access;

PIC_X_1  PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
-------  -------  -----------  --------  -------  ---------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

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

--- 24 row(s) selected.
>>-- <end-input>
>>
>>
>>
>>-- <testcase A5>
>>
>>-- <detail>
>>--    select joins where clause select test case - this tests the
>>--    selection of aggregate functions (COUNT, AVG, MAX, MIN, SUM)
>>--    from multiple tables.  Aggregates are tested in the SELECT
>>--    clause in conjunction with WHERE predicates.
>>
>>-- <templates>
>>--    US00
>>
>>-- <ufi-input>
>>      select count(*)
+>      from btsel01 firstt, btsel01 secondd
+>      where firstt.var_char = 'thomas';

(EXPR)              
--------------------

                  24

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select count(*)
+>      from btsel01 firstt, btsel01 secondd
+>      where firstt.small_int = secondd.small_int;

(EXPR)              
--------------------

                  10

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select count(*)
+>      from btsel01,pvsel04
+>      where  btsel01.large_int =  pvsel04.medium_int;

(EXPR)              
--------------------

                   6

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select avg(decimal_1)
+>      from svsel13, btsel01
+>      where decimal_3_unsigned = new_name_1;

(EXPR)              
--------------------

                   1

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select count(distinct firstt.medium_int)
+>      from pvsel01 firstt, pvsel01 secondd 
+>      where firstt.medium_int not in (1000,10000);

(EXPR)              
--------------------

                   3

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select avg(distinct  pvsel04.medium_int)
+>      from pvsel01, pvsel04
+>      where  pvsel01.medium_int >
+>             pvsel04.medium_int;

(EXPR)              
--------------------

                1333

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select max(ALL  svsel13.new_name_1 /  pvsel03.new_name_2)
+>      from svsel13, pvsel03
+>      where (( pvsel03.new_name_1 = 80) or
+>             ( svsel13.new_name_1 = 90)) and
+>            (( pvsel03.new_name_2 = 5) or
+>             ( svsel13.new_name_2 = 6));

(EXPR)               
---------------------

           18.0000000

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select sum(binary_32_u + pic_comp_1)
+>      from btsel03, btsel04
+>      where pic_comp_1 in (medium_int, binary_64_s);

(EXPR)               
---------------------

             14366.00

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select avg(svsel13.pic_comp_1) +
+>             sum( btsel01.pic_comp_1)
+>      from svsel13, btsel01
+>      where  svsel13.pic_comp_1 > 100;

(EXPR)              
--------------------

               20940

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select avg(col_7) * sum(pic_comp_1)
+>      from svsel13, svsel11
+>      where new_name_3 = col_8;

(EXPR)              
--------------------

             8384538

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select max( btsel01.pic_x_7), min( btsel03.pic_x_7)
+>      from btsel01, btsel03
+>      where  btsel01.pic_x_7 =  btsel03.pic_x_7;

(EXPR)   (EXPR) 
-------  -------

michael  7      

--- 1 row(s) selected.
>>-- <end-input>
>>
>>
>>
>>-- <end-test>
>>LOG;
