>>---------------------------------------------------------------------
>>-- 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 GROUP BY, HAVING, and ORDER BY clauses, and also tests some
>>-- complex queries that use all the clauses together.
>>--    This test unit uses the select global data base (sqldd01d).
>>-- Each test case in this test unit tests a particular feature of complex
>>-- join select statements.  For each test case , the following combinations
>>-- of objects are tested:
>>--           base table - base table
>>--           base table - protection view
>>--           base table - shorthand view
>>--           protection view - protection view
>>--           protection view - shorthand view
>>--           shorthand view - shorthand view
>>--           base table with itself
>>--           protection view with itself
>>--           shorthand view with itself
>>--           3 or more base tables
>>
>>--    The test cases in this test unit are as follows:
>>--       A0: use of the GROUP BY clause
>>--       A1: HAVING
>>--       A2: ORDER BY
>>--       A3: complex queries - combinations of all features
>>--       A4: use of locking clauses (for stable access, for browse access,
>>--           for repeatable access) with above clauses
>>--       A5: SELECT aggregate functions with GROUP BY
>>--       A6: SELECT aggregate functions with aggregates in HAVING clause
>>--           and complex queries with aggregates
>>
>>-- All testcases are documented further below.
>>
>>-- *******************  end test unit comments  *************************
>>
>>-- <testunit-summary>
>>-- select #6 pos/loc ufi joins complex
>>
>>
>>-- <testunit-specs>
>>
>>-- mode-type ufi
>>-- test-type functional
>>-- form-type pos/loc
>>-- select-test
>>
>>-- <testcase A0>
>>
>>--    <detail>
>>--       join select test - this tests the use of a GROUP BY clause
>>--       in a select statement on more than one table.
>>
>>--    <templates>
>>--       US00
>>
>>-- <ufi-input>
>>      select pic_9_7
+>      from btsel03,btsel04
+>      group by pic_9_7;

PIC_9_7
-------

     50
     80
     90
    100

--- 4 row(s) selected.
>>
>>-- <ufi-input>
>>      select medium_int
+>      from btsel03,btsel04
+>      group by medium_int;

MEDIUM_INT 
-----------

        200
        999
       1000
       2000

--- 4 row(s) selected.
>>
>>-- <comment> similar to above, without reference to btsel03
>>-- <comment> (compare output - should be the same)
>>-- <ufi-input>
>>      select medium_int
+>      from btsel04
+>      group by medium_int;

MEDIUM_INT 
-----------

       1000
        999
        200
       2000

--- 4 row(s) selected.
>>
>>-- <ufi-input>
>>      select pic_9_7, btsel03.pic_x_7
+>      from btsel03,btsel04
+>      group by pic_9_7, btsel03.pic_x_7;

PIC_9_7  PIC_X_7
-------  -------

    100  5      
     80  7      
     80  8      
     90  A      
     80  B      
     50  michael

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select pic_9_7,medium_int
+>      from btsel03,btsel04
+>      group by pic_9_7,medium_int;

PIC_9_7  MEDIUM_INT 
-------  -----------

     90         1000
     90         2000
     90          200
     90          999
     80         1000
     80         2000
     80          200
     80          999
    100         1000
    100         2000
    100          200
    100          999
     50         1000
     50         2000
     50          200
     50          999

--- 16 row(s) selected.
>>-- <ufi-input>
>>      select pic_x_1,pic_9_7,medium_int
+>      from btsel02,btsel03,btsel04
+>      group by pic_x_1,pic_9_7,medium_int;

PIC_X_1  PIC_9_7  MEDIUM_INT 
-------  -------  -----------

B             90         1000
B             90         2000
B             90          200
B             90          999
Q             90         1000
Q             90         2000
Q             90          200
Q             90          999
C             90         1000
C             90         2000
C             90          200
C             90          999
B             80         1000
B             80         2000
B             80          200
B             80          999
Q             80         1000
Q             80         2000
Q             80          200
Q             80          999
C             80         1000
C             80         2000
C             80          200
C             80          999
B            100         1000
B            100         2000
B            100          200
B            100          999
Q            100         1000
Q            100         2000
Q            100          200
Q            100          999
C            100         1000
C            100         2000
C            100          200
C            100          999
B             50         1000
B             50         2000
B             50          200
B             50          999
Q             50         1000
Q             50         2000
Q             50          200
Q             50          999
C             50         1000
C             50         2000
C             50          200
C             50          999

--- 48 row(s) selected.
>>-- <ufi-input>
>>      select decimal_1,new_name_1
+>      from btsel01,pvsel03
+>      group by decimal_1,new_name_1;

DECIMAL_1  NEW_NAME_1
---------  ----------

        7          90
        7          80
        4          90
        4          80
        5          90
        5          80
        1          90
        1          80
        8          90
        8          80
        9          90
        9          80

--- 12 row(s) selected.
>>-- <ufi-input>
>>      select decimal_1,new_name_1
+>      from btsel01,svsel13
+>      group by decimal_1,new_name_1;

DECIMAL_1  NEW_NAME_1
---------  ----------

        7          80
        9          80
        8          80
        1          80
        5          80
        4          80
        7          90
        9          90
        8          90
        1          90
        5          90
        4          90

--- 12 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel01.medium_int, pvsel04.medium_int
+>      from pvsel01,pvsel04
+>      group by  pvsel01.medium_int, pvsel04.medium_int;

MEDIUM_INT  MEDIUM_INT 
----------  -----------

      8000         1000
      8000         2000
      8000          999
     10000         1000
     10000         2000
     10000          999
      9000         1000
      9000         2000
      9000          999
      1000         1000
      1000         2000
      1000          999
      5000         1000
      5000         2000
      5000          999

--- 15 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel01.medium_int
+>      from pvsel01,svsel13
+>      group by  pvsel01.medium_int;

MEDIUM_INT
----------

      8000
     10000
      9000
      1000
      5000

--- 5 row(s) selected.
>>-- <ufi-input>
>>      select new_name_3,col_3
+>      from svsel13,svsel11
+>      group by new_name_3,col_3;

NEW_NAME_3  COL_3     
----------  ----------

7                10000
B                10000
A                10000
7                 8000
B                 8000
A                 8000
7                 9000
B                 9000
A                 9000
7                 1000
7                 5000
B                 1000
B                 5000
A                 1000
A                 5000

--- 15 row(s) selected.
>>-- <ufi-input>
>>      select secondd.char_1, firstt.medium_int
+>      from  btsel01 firstt,  btsel01 secondd
+>      group by secondd.char_1,firstt.medium_int;

CHAR_1  MEDIUM_INT
------  ----------

D             8000
C             8000
E             8000
A             8000
D            10000
C            10000
E            10000
A            10000
D             9000
C             9000
E             9000
A             9000
D             1000
C             1000
E             1000
A             1000
D             5000
C             5000
E             5000
A             5000

--- 20 row(s) selected.
>>-- <ufi-input>
>>      select secondd.medium_int
+>      from pvsel01 firstt, pvsel01 secondd
+>      group by secondd.medium_int;

MEDIUM_INT
----------

      8000
     10000
      9000
      1000
      5000

--- 5 row(s) selected.
>>-- <ufi-input>
>>      select firstt.new_name_1,firstt.new_name_3
+>     from svsel13 firstt,svsel13 secondd
+>      group by firstt.new_name_1,firstt.new_name_3;

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

        80  7         
        90  A         
        80  B         

--- 3 row(s) selected.
>>-- <end-input>
>>
>>
>>
>>-- <testcase A1>
>>
>>-- <detail>
>>--    select join test case - this tests the use of a HAVING clause,
>>--    in conjunction with a GROUP BY clause .
>>
>>
>>-- <templates>
>>--    US00
>>
>>-- <ufi-input>
>>      select pic_9_7
+>      from btsel03,btsel04
+>      group by pic_9_7
+>      having pic_9_7 < 100;

PIC_9_7
-------

     50
     80
     90

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select medium_int
+>      from btsel03,btsel04
+>      group by medium_int
+>      having medium_int between 500 and 3000;

MEDIUM_INT 
-----------

        999
       1000
       2000

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select pic_9_7, btsel03.pic_x_7
+>      from btsel03,btsel04
+>      group by pic_9_7, btsel03.pic_x_7
+>      having pic_9_7 in (50,80,100);

PIC_9_7  PIC_X_7
-------  -------

    100  5      
     80  7      
     80  8      
     80  B      
     50  michael

--- 5 row(s) selected.
>>-- <ufi-input>
>>      select pic_9_7,medium_int
+>      from btsel03,btsel04
+>      group by pic_9_7,medium_int
+>      having (pic_9_7 * 2) <> medium_int;

PIC_9_7  MEDIUM_INT 
-------  -----------

     90         1000
     90         2000
     90          200
     90          999
     80         1000
     80         2000
     80          200
     80          999
    100         1000
    100         2000
    100          999
     50         1000
     50         2000
     50          200
     50          999

--- 15 row(s) selected.
>>-- <ufi-input>
>>      select pic_x_1,pic_9_7,medium_int
+>      from btsel02,btsel03,btsel04
+>      group by pic_x_1,pic_9_7,medium_int
+>      having pic_x_1 like 'Q';

PIC_X_1  PIC_9_7  MEDIUM_INT 
-------  -------  -----------

Q             90         1000
Q             90         2000
Q             90          200
Q             90          999
Q             80         1000
Q             80         2000
Q             80          200
Q             80          999
Q            100         1000
Q            100         2000
Q            100          200
Q            100          999
Q             50         1000
Q             50         2000
Q             50          200
Q             50          999

--- 16 row(s) selected.
>>-- <ufi-input>
>>      select decimal_1,new_name_1
+>      from btsel01,pvsel03
+>      group by decimal_1,new_name_1
+>      having new_name_1 in (80,100);

DECIMAL_1  NEW_NAME_1
---------  ----------

        7          80
        4          80
        5          80
        1          80
        8          80
        9          80

--- 6 row(s) selected.
>>
>>-- <comment> test select from 0 groups
>>-- <ufi-input>
>>      select decimal_1,new_name_1
+>      from btsel01,pvsel03
+>      group by decimal_1,new_name_1
+>      having new_name_1 in (872,100);

--- 0 row(s) selected.
>>-- <ufi-input>
>>      select decimal_1,new_name_1
+>      from btsel01,svsel13
+>      group by decimal_1,new_name_1
+>      having new_name_1 <> 80;

DECIMAL_1  NEW_NAME_1
---------  ----------

        7          90
        9          90
        8          90
        1          90
        5          90
        4          90

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel01.medium_int, pvsel04.medium_int
+>      from pvsel01,pvsel04
+>      group by  pvsel01.medium_int, pvsel04.medium_int
+>      having  pvsel01.medium_int =  pvsel04.medium_int;

MEDIUM_INT  MEDIUM_INT 
----------  -----------

      1000         1000

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel01.medium_int
+>      from pvsel01,svsel13
+>      group by  pvsel01.medium_int
+>      having  pvsel01.medium_int between 2000 and 10000;

MEDIUM_INT
----------

      8000
     10000
      9000
      5000

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select new_name_3,col_3
+>      from svsel13,svsel11
+>      group by new_name_3,col_3
+>      having new_name_3 like 'A' or new_name_3 like '7';

--- 0 row(s) selected.
>>-- <ufi-input>
>>      select secondd.char_1, firstt.medium_int
+>      from btsel01 firstt, btsel01 secondd
+>      group by secondd.char_1,firstt.medium_int
+>      having firstt.medium_int <> 5000;

CHAR_1  MEDIUM_INT
------  ----------

D             8000
D            10000
D             1000
D             9000
A             8000
A            10000
A             1000
A             9000
E             8000
E            10000
E             1000
E             9000
C             8000
C            10000
C             1000
C             9000

--- 16 row(s) selected.
>>-- <ufi-input>
>>      select secondd.medium_int
+>      from pvsel01 firstt, pvsel01 secondd
+>      group by secondd.medium_int
+>      having secondd.medium_int <> 5000;

MEDIUM_INT
----------

      8000
     10000
      9000
      1000

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select firstt.new_name_1,firstt.new_name_3
+>      from svsel13 firstt,svsel13 secondd
+>      group by firstt.new_name_1,firstt.new_name_3
+>      having firstt.new_name_1 <> 90;

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

        80  7         
        80  B         

--- 2 row(s) selected.
>>-- <end-input>
>>
>>
>>
>>-- <testcase A2>
>>
>>-- <detail>
>>--    select join test case - this tests the use of an ORDER BY
>>--    clause in a select statement.
>>
>>-- <templates>
>>--    US00
>>
>>-- <ufi-input>
>>      select *
+>      from btsel03,btsel04
+>      order by pic_9_7 ASC;

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

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

--- 64 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03,btsel04
+>      order by 6 DESC;

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

--- 64 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03,btsel04
+>      order by pic_9_7, btsel03.pic_9_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
-------  -----------  --------  -------  ---------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------

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

--- 64 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel03,btsel04
+>      order by 4,6 ;

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

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

--- 64 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel02,btsel03,btsel04
+>      order by pic_x_1,pic_9_7,medium_int ASC;

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        michael        70.00  joan           50                4000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        michael        50.00  dave           50                1500.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        michael        70.00  joan           50                4000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        michael        50.00  dave           50                1500.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        michael        70.00  joan           50                4000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        michael        70.00  joan           50                4000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        michael        70.00  joan           50                4000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        michael        70.00  joan           50                4000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        michael        50.00  dave           50                1500.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        michael        50.00  dave           50                1500.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        michael        50.00  dave           50                1500.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        michael        50.00  dave           50                1500.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        michael        70.00  joan           50                4000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        michael        70.00  joan           50                4000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        michael        50.00  dave           50                1500.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        michael        70.00  joan           50                4000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        michael        50.00  dave           50                1500.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        michael        50.00  dave           50                1500.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        michael        50.00  dave           50                1500.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        michael        50.00  dave           50                1500.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        michael        70.00  joan           50                4000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        michael        50.00  dave           50                1500.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        michael        50.00  dave           50                1500.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        michael        50.00  dave           50                1500.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        michael        50.00  dave           50                1500.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        michael        70.00  joan           50                4000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        michael        70.00  joan           50                4000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        michael        70.00  joan           50                4000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        michael        50.00  dave           50                1500.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  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
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  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        michael        50.00  dave           50                1500.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        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        7               6.00  john           80                2000.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  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
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        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
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        8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
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        7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        8               6.00  joe            80                1200.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  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        B               6.00  mark           80                3000.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        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
B        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        A               5.00  make           90                 200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
B        A               5.00  make           90                 200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
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  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        A               5.00  make           90                 200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
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  christopher                                                                                                                                                                                                                                                         1000  white                    1000
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  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
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        A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
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  bobby                                                                                                                                                                                                                                                                200  sue                       100
B        5            1000.00  5             100                1000.00  sue                                                                                                                                                                                                                                                                  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  bob                                                                                                                                                                                                                                                                  999  A                         300
B        5            1000.00  5             100                1000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
B        5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
B        5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
B        5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
B        5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
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  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
B        5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
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        5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        michael        50.00  dave           50                1500.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        michael        50.00  dave           50                1500.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        michael        70.00  joan           50                4000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        michael        50.00  dave           50                1500.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        michael        70.00  joan           50                4000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        michael        70.00  joan           50                4000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        michael        70.00  joan           50                4000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        michael        50.00  dave           50                1500.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        michael        50.00  dave           50                1500.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        michael        50.00  dave           50                1500.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        michael        70.00  joan           50                4000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        michael        70.00  joan           50                4000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        michael        50.00  dave           50                1500.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        michael        50.00  dave           50                1500.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        michael        50.00  dave           50                1500.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        michael        70.00  joan           50                4000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        michael        50.00  dave           50                1500.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        michael        70.00  joan           50                4000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        michael        70.00  joan           50                4000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        michael        70.00  joan           50                4000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        michael        70.00  joan           50                4000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        michael        70.00  joan           50                4000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        A               5.00  make           90                 200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        A               5.00  make           90                 200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        A               5.00  make           90                 200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        A               5.00  make           90                 200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        5            1000.00  5             100                1000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        5            1000.00  5             100                1000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
C        5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
C        5            1000.00  5             100                1000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        5            1000.00  5             100                1000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
C        5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
C        5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
C        5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
C        5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
C        5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
C        5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        michael        70.00  joan           50                4000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        michael        70.00  joan           50                4000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        michael        70.00  joan           50                4000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        michael        70.00  joan           50                4000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        michael        50.00  dave           50                1500.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        michael        70.00  joan           50                4000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        michael        50.00  dave           50                1500.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        michael        50.00  dave           50                1500.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        michael        50.00  dave           50                1500.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        michael        70.00  joan           50                4000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        michael        50.00  dave           50                1500.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        michael        50.00  dave           50                1500.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        michael        50.00  dave           50                1500.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        michael        70.00  joan           50                4000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        michael        70.00  joan           50                4000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        michael        50.00  dave           50                1500.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        michael        70.00  joan           50                4000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        michael        50.00  dave           50                1500.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        michael        50.00  dave           50                1500.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        michael        50.00  dave           50                1500.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        michael        50.00  dave           50                1500.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        michael        50.00  dave           50                1500.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        michael        70.00  joan           50                4000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        michael        70.00  joan           50                4000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        michael        70.00  joan           50                4000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        michael        50.00  dave           50                1500.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        michael        50.00  dave           50                1500.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        michael        70.00  joan           50                4000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        michael        70.00  joan           50                4000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        michael        70.00  joan           50                4000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        michael        70.00  joan           50                4000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        michael        70.00  joan           50                4000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        michael        70.00  joan           50                4000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        A               5.00  make           90                 200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        A               5.00  make           90                 200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        A               5.00  make           90                 200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        A               5.00  make           90                 200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        A               5.00  make           90                 200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        A               5.00  make           90                 200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        5            1000.00  5             100                1000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        5            1000.00  5             100                1000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        5            1000.00  5             100                1000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
Q        5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
Q        5            1000.00  5             100                1000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        5            1000.00  5             100                1000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        5            1000.00  5             100                1000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
Q        5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
Q        5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
Q        5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
Q        5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
Q        5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
Q        5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500

--- 512 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel01,pvsel03
+>      order by decimal_1,new_name_1 DESC;

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

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
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
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
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
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
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          80         6.00  7             216172782159534342
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          80         6.00  B             216172782159534343
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          80         6.00  7             216172782159534338
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          90         5.00  A             216172782159534337
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
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
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          80         6.00  7             216172782159534342
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
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          80         6.00  B             216172782159534343
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
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          80         6.00  7             216172782159534338
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          90         5.00  A             216172782159534337
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          90         5.00  A             216172782159534337
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          80         6.00  7             216172782159534338
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          80         6.00  B             216172782159534343
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          80         6.00  B             216172782159534343
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          80         6.00  7             216172782159534342
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          80         6.00  7             216172782159534338
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          80         6.00  7             216172782159534342
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
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
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
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
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
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
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
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

--- 32 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel01,svsel13
+>      order by decimal_1,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  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          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          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
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          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          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
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
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          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          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             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
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          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
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          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
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          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
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          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
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          80         6.00  7             216172782159534338  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          80         6.00  7             216172782159534338  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          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
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          80         6.00  7             216172782159534342  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          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
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          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  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          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          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  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          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          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300

--- 32 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01,pvsel04
+>      order by  pvsel01.medium_int DESC,
+>                pvsel04.medium_int DESC;

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

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

--- 48 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01,svsel13
+>      order by  pvsel01.medium_int;

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

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

--- 32 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13,svsel11
+>      order by new_name_3,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    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    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    2000              -1000000        8000      5  Q      sue        2000  8      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    2000              -1000000        8000      5  Q      sue        2000  8      
        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      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   -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    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  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      
        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    3000                  2000        1000      7  E      jimmy      9000  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    4000                     0        5000      8  Z      johnny     8000  7      
        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    2000              -1000000        8000      5  Q      sue        2000  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    2000              -1000000        8000      5  Q      sue        2000  8      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300      60                 -1000        8000      2  A      bobby      1000  8      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300      60                 -1000        8000      2  A      bobby      1000  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    1000                   999        9000      4  C      7            80  michael
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    8000                  1000       10000      3  B      9            90  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300      50            1000000000       10000      1  C      walter       10  A      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    3000                  2000        1000      7  E      jimmy      9000  7      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    4000                     0        5000      8  Z      johnny     8000  7      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500   -5000                   200        8000      6  D      michael      90  7      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500      60                 -1000        8000      2  A      bobby      1000  8      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500      60                 -1000        8000      2  A      bobby      1000  7      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    2000              -1000000        8000      5  Q      sue        2000  8      
        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    1000                   999        9000      4  C      7            80  michael
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    8000                  1000       10000      3  B      9            90  7      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500      50            1000000000       10000      1  C      walter       10  A      

--- 40 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel01 firstt,btsel01 secondd
+>      order by secondd.char_1 DESC, firstt.medium_int ASC;

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

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  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       marcia      Z        johnny   dum                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                  4000        40.00               2000.000                    50         .60     100.60000       8000        5000                     0          9               .99                 110            8.1           .800              8  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       bobby       A        bobby    bop                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         60        60.00               1200.000                    60         .79     100.99000       1000        8000                 -1000          5               .60                 100            2.1           .200              2  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  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
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  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
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
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  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       steven      C        walter   bob                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         50        50.00                200.000                    50         .12     100.90000         10       10000            1000000000          4               .50                  90            1.1           .100              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
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  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
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  D       steven      B        9        bat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                  8000        70.00               2000.000                   500         .10     100.99900         90       10000                  1000          7               .70                 110            3.1           .300              3
C       maureen     E        jimmy    rum                                                                                                                                                                                                       marilyn                                                                                                                                                                                                                                                                 3000        80.00               2000.000                   500         .50     100.70000       9000        1000                  2000          8               .97                 150            7.1           .700              7  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
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       michelle    D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                 -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6
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
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       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  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       bobby       A        bobby    bop                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         60        60.00               1200.000                    60         .79     100.99000       1000        8000                 -1000          5               .60                 100            2.1           .200              2  D       melissa     C        7        pop                                                                                                                                                                                                       jimmy                                                                                                                                                                                                                                                                   1000        80.00               1500.000                   500         .20     100.99990         80        9000                   999          5               .80                 120            4.1           .400              4
E       monica      Q        sue      pat                                                                                                                                                                                                       christopher                                                                                                                                                                                                                                                             2000        90.00               1200.000                  3000         .30     100.99999       2000        8000              -1000000          1               .90                  80            5.1           .500              5  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
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  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       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       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       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       bobby       A        bobby    bop                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         60        60.00               1200.000                    60         .79     100.99000       1000        8000                 -1000          5               .60                 100            2.1           .200              2  D       michelle    D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                 -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6
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       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  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  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       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       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  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       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       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       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
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
A       steven      C        walter   bob                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         50        50.00                200.000                    50         .12     100.90000         10       10000            1000000000          4               .50                  90            1.1           .100              1  D       steven      B        9        bat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                  8000        70.00               2000.000                   500         .10     100.99900         90       10000                  1000          7               .70                 110            3.1           .300              3
A       steven      C        walter   bob                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         50        50.00                200.000                    50         .12     100.90000         10       10000            1000000000          4               .50                  90            1.1           .100              1  D       michelle    D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                 -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6
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       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
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       maureen     E        jimmy    rum                                                                                                                                                                                                       marilyn                                                                                                                                                                                                                                                                 3000        80.00               2000.000                   500         .50     100.70000       9000        1000                  2000          8               .97                 150            7.1           .700              7
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  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       michelle    D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                 -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6  C       maureen     E        jimmy    rum                                                                                                                                                                                                       marilyn                                                                                                                                                                                                                                                                 3000        80.00               2000.000                   500         .50     100.70000       9000        1000                  2000          8               .97                 150            7.1           .700              7
A       bobby       A        bobby    bop                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         60        60.00               1200.000                    60         .79     100.99000       1000        8000                 -1000          5               .60                 100            2.1           .200              2  C       maureen     E        jimmy    rum                                                                                                                                                                                                       marilyn                                                                                                                                                                                                                                                                 3000        80.00               2000.000                   500         .50     100.70000       9000        1000                  2000          8               .97                 150            7.1           .700              7
A       bobby       A        bobby    bop                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         60        60.00               1200.000                    60         .79     100.99000       1000        8000                 -1000          5               .60                 100            2.1           .200              2  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
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
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       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       melissa     C        7        pop                                                                                                                                                                                                       jimmy                                                                                                                                                                                                                                                                   1000        80.00               1500.000                   500         .20     100.99990         80        9000                   999          5               .80                 120            4.1           .400              4  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       melissa     C        7        pop                                                                                                                                                                                                       jimmy                                                                                                                                                                                                                                                                   1000        80.00               1500.000                   500         .20     100.99990         80        9000                   999          5               .80                 120            4.1           .400              4  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
D       steven      B        9        bat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                  8000        70.00               2000.000                   500         .10     100.99900         90       10000                  1000          7               .70                 110            3.1           .300              3  C       marcia      Z        johnny   dum                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                  4000        40.00               2000.000                    50         .60     100.60000       8000        5000                     0          9               .99                 110            8.1           .800              8
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  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
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  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
D       steven      B        9        bat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                  8000        70.00               2000.000                   500         .10     100.99900         90       10000                  1000          7               .70                 110            3.1           .300              3  C       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  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
C       maureen     E        jimmy    rum                                                                                                                                                                                                       marilyn                                                                                                                                                                                                                                                                 3000        80.00               2000.000                   500         .50     100.70000       9000        1000                  2000          8               .97                 150            7.1           .700              7  A       steven      C        walter   bob                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         50        50.00                200.000                    50         .12     100.90000         10       10000            1000000000          4               .50                  90            1.1           .100              1
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  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
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  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
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       steven      C        walter   bob                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         50        50.00                200.000                    50         .12     100.90000         10       10000            1000000000          4               .50                  90            1.1           .100              1
D       michelle    D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                 -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6  A       bobby       A        bobby    bop                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         60        60.00               1200.000                    60         .79     100.99000       1000        8000                 -1000          5               .60                 100            2.1           .200              2
D       michelle    D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                 -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6  A       steven      C        walter   bob                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         50        50.00                200.000                    50         .12     100.90000         10       10000            1000000000          4               .50                  90            1.1           .100              1
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       steven      C        walter   bob                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         50        50.00                200.000                    50         .12     100.90000         10       10000            1000000000          4               .50                  90            1.1           .100              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  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  A       steven      C        walter   bob                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         50        50.00                200.000                    50         .12     100.90000         10       10000            1000000000          4               .50                  90            1.1           .100              1
D       melissa     C        7        pop                                                                                                                                                                                                       jimmy                                                                                                                                                                                                                                                                   1000        80.00               1500.000                   500         .20     100.99990         80        9000                   999          5               .80                 120            4.1           .400              4  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       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       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       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       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
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

--- 64 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from pvsel01 firstt,pvsel01 secondd
+>      order by secondd.medium_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
-------------  --------------------  ----------  -------------  -------  -------  ---------  -------------  --------------------  ----------  -------------  -------  -------  ---------

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

--- 64 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13 firstt,svsel13 secondd
+>      order by firstt.new_name_1,firstt.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  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
        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          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
        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          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

--- 16 row(s) selected.
>>-- <end-input>
>>
>>
>>-- <testcase A3>
>>
>>-- <detail>
>>--    select join test case - this tests some complex queries that
>>--    use all the SELECT clauses together.
>>
>>-- <templates>
>>--    US00
>>
>>-- <ufi-input>
>>      select pic_9_7,medium_int
+>      from btsel03,btsel04
+>      where (pic_9_7 <= pic_comp_1) and
+>            (binary_32_u between 0 and medium_int) and
+>            (pic_comp_1 in (medium_int,binary_64_s,100,300,500))
+>      group by pic_9_7,medium_int
+>      having (pic_9_7 * 2) <> medium_int
+>      order by pic_9_7,2 DESC
+>      for browse access;

PIC_9_7  MEDIUM_INT 
-------  -----------

     50         2000
     50         1000
     50          999
     50          200
     80         2000
     80         1000
     80          999
     80          200
     90         2000
     90         1000
     90          999
     90          200
    100         2000
    100         1000

--- 14 row(s) selected.
>>-- <ufi-input>
>>      select pic_x_1,pic_9_7,medium_int
+>      from btsel02,btsel03,btsel04
+>      where (pic_x_1 <>  btsel04.pic_x_7) and
+>            (pic_x_1 not in ( btsel03.pic_x_7,
+>                              btsel04.pic_x_7)) and
+>            (binary_32_u between 0 and medium_int)
+>      group by pic_x_1,pic_9_7,medium_int
+>      having pic_x_1 like 'Q'
+>      order by pic_x_1,pic_9_7,medium_int ASC
+>      for stable access;

PIC_X_1  PIC_9_7  MEDIUM_INT 
-------  -------  -----------

Q             50          200
Q             50          999
Q             50         1000
Q             50         2000
Q             80          200
Q             80          999
Q             80         1000
Q             80         2000
Q             90          200
Q             90          999
Q             90         1000
Q             90         2000
Q            100         1000
Q            100         2000

--- 14 row(s) selected.
>>-- <ufi-input>
>>      select decimal_1,new_name_1
+>      from btsel01,pvsel03
+>      where (btsel01.var_char like '_%') and
+>      (new_name_1 < binary_64_s)
+>      group by decimal_1,new_name_1
+>      having new_name_1 in (80,100)
+>      order by decimal_1,new_name_1 DESC
+>      for repeatable access;

DECIMAL_1  NEW_NAME_1
---------  ----------

        1          80
        4          80
        5          80
        7          80
        8          80
        9          80

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select decimal_1,new_name_1
+>      from btsel01,svsel13
+>      where (btsel01.var_char like '_%') and
+>            (new_name_1 < binary_64_s)
+>      group by decimal_1,new_name_1
+>      having new_name_1 <> 80
+>      order by decimal_1,new_name_1;

DECIMAL_1  NEW_NAME_1
---------  ----------

        1          90
        4          90
        5          90
        7          90
        8          90
        9          90

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel01.medium_int, pvsel04.medium_int
+>      from  pvsel01,pvsel04
+>      where  pvsel01.medium_int >=  pvsel04.medium_int
+>      group by  pvsel01.medium_int, pvsel04.medium_int
+>      having  pvsel01.medium_int =  pvsel04.medium_int
+>      order by  pvsel01.medium_int, pvsel04.medium_int;

MEDIUM_INT  MEDIUM_INT 
----------  -----------

      1000         1000

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel01.medium_int
+>      from pvsel01,svsel13
+>      where small_int <> new_name_1
+>      group by  pvsel01.medium_int
+>      having  pvsel01.medium_int between 2000 and 10000
+>      order by  pvsel01.medium_int;

MEDIUM_INT
----------

      5000
      8000
      9000
     10000

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select new_name_3,col_3
+>      from svsel13,svsel11
+>      where  svsel13.medium_int in (999,1000,2000)
+>      group by new_name_3,col_3
+>      having new_name_3 like 'A' or new_name_3 like '7'
+>      order by new_name_3;

--- 0 row(s) selected.
>>-- <ufi-input>
>>      select secondd.char_1,firstt.medium_int
+>      from btsel01 firstt,btsel01 secondd
+>      where firstt.small_int = secondd.small_int
+>      group by secondd.char_1,firstt.medium_int
+>      having firstt.medium_int <> 5000
+>      order by secondd.char_1;

CHAR_1  MEDIUM_INT
------  ----------

A            10000
A             8000
C             1000
D             9000
D            10000
D             8000
E             8000

--- 7 row(s) selected.
>>-- <end-input>
>>
>>
>>-- <testcase A4>
>>
>>-- <detail>
>>--    select join test case - this tests the use of the for browse access,
>>--    for stable access, and for repeatable access clauses with GROUP BY,
>>--    HAVING, and ORDER BY clauses. This is a test of syntax only - no actual
>>--    checking of the locks obtained is done.
>>
>>-- <templates>
>>--    US00
>>
>>-- <ufi-input>
>>      select pic_9_7
+>      from btsel03,btsel04
+>      group by pic_9_7
+>      for browse access;

PIC_9_7
-------

     50
     80
     90
    100

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select decimal_1,new_name_1
+>      from btsel01,pvsel03
+>      group by decimal_1,new_name_1
+>      having new_name_1 in (80,100)
+>      for stable access;

DECIMAL_1  NEW_NAME_1
---------  ----------

        7          80
        4          80
        5          80
        1          80
        8          80
        9          80

--- 6 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from btsel01,svsel13
+>      order by decimal_1,new_name_1
+>      for repeatable access;

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

--- 32 row(s) selected.
>>-- <ufi-input>
>>      select pic_x_1,pic_9_7,medium_int
+>      from btsel02,btsel03,btsel04
+>      group by pic_x_1,pic_9_7,medium_int
+>      for repeatable access;

PIC_X_1  PIC_9_7  MEDIUM_INT 
-------  -------  -----------

B             90         1000
B             90         2000
B             90          200
B             90          999
Q             90         1000
Q             90         2000
Q             90          200
Q             90          999
C             90         1000
C             90         2000
C             90          200
C             90          999
B             80         1000
B             80         2000
B             80          200
B             80          999
Q             80         1000
Q             80         2000
Q             80          200
Q             80          999
C             80         1000
C             80         2000
C             80          200
C             80          999
B            100         1000
B            100         2000
B            100          200
B            100          999
Q            100         1000
Q            100         2000
Q            100          200
Q            100          999
C            100         1000
C            100         2000
C            100          200
C            100          999
B             50         1000
B             50         2000
B             50          200
B             50          999
Q             50         1000
Q             50         2000
Q             50          200
Q             50          999
C             50         1000
C             50         2000
C             50          200
C             50          999

--- 48 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel01.medium_int
+>      from pvsel01,svsel13
+>      group by  pvsel01.medium_int
+>      having  pvsel01.medium_int between 2000 and 10000
+>      for browse access;

MEDIUM_INT
----------

      8000
     10000
      9000
      5000

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13,svsel11
+>      order by new_name_3,col_3
+>      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    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    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    2000              -1000000        8000      5  Q      sue        2000  8      
        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    2000              -1000000        8000      5  Q      sue        2000  8      
        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      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   -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    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  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      
        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    3000                  2000        1000      7  E      jimmy      9000  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    4000                     0        5000      8  Z      johnny     8000  7      
        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    2000              -1000000        8000      5  Q      sue        2000  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    2000              -1000000        8000      5  Q      sue        2000  8      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300      60                 -1000        8000      2  A      bobby      1000  8      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300      60                 -1000        8000      2  A      bobby      1000  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    1000                   999        9000      4  C      7            80  michael
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300    8000                  1000       10000      3  B      9            90  7      
        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300      50            1000000000       10000      1  C      walter       10  A      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    3000                  2000        1000      7  E      jimmy      9000  7      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    4000                     0        5000      8  Z      johnny     8000  7      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500   -5000                   200        8000      6  D      michael      90  7      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500      60                 -1000        8000      2  A      bobby      1000  8      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500      60                 -1000        8000      2  A      bobby      1000  7      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    2000              -1000000        8000      5  Q      sue        2000  8      
        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    1000                   999        9000      4  C      7            80  michael
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500    8000                  1000       10000      3  B      9            90  7      
        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500      50            1000000000       10000      1  C      walter       10  A      

--- 40 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel01.medium_int, pvsel04.medium_int
+>      from pvsel01,pvsel04
+>      group by  pvsel01.medium_int, pvsel04.medium_int
+>      for stable access;

MEDIUM_INT  MEDIUM_INT 
----------  -----------

      8000         1000
      8000         2000
      8000          999
     10000         1000
     10000         2000
     10000          999
      9000         1000
      9000         2000
      9000          999
      1000         1000
      1000         2000
      1000          999
      5000         1000
      5000         2000
      5000          999

--- 15 row(s) selected.
>>-- <ufi-input>
>>      select secondd.medium_int
+>      from pvsel01 firstt,pvsel01 secondd
+>      group by secondd.medium_int
+>      having secondd.medium_int <> 5000
+>      for repeatable access;

MEDIUM_INT
----------

      8000
     10000
      9000
      1000

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select *
+>      from svsel13 firstt,svsel13 secondd
+>      order by firstt.new_name_1,firstt.new_name_3
+>      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             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
        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          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
        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          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

--- 16 row(s) selected.
>>-- <ufi-input>
>>      select secondd.char_1,firstt.medium_int
+>      from btsel01 firstt, btsel01 secondd
+>      group by secondd.char_1,firstt.medium_int
+>      for repeatable access;

CHAR_1  MEDIUM_INT
------  ----------

D             8000
C             8000
E             8000
A             8000
D            10000
C            10000
E            10000
A            10000
D             9000
C             9000
E             9000
A             9000
D             1000
C             1000
E             1000
A             1000
D             5000
C             5000
E             5000
A             5000

--- 20 row(s) selected.
>>-- <end-input>
>>
>>
>>-- <testcase A5>
>>
>>-- <detail>
>>--    join select test - this tests the selection of aggregate functions
>>--    (COUNT, AVG, MAX, MIN, SUM).  Aggregates are tested in the SELECT
>>--    clause in conjunction with GROUP BY clauses.
>>
>>
>>-- <templates>
>>--    US00
>>
>>-- <comment> this query is similar to the secondd query in testcase A0 -
>>-- <comment> only 'count(*)' is also selected to determine if the join
>>-- <comment> is executing properly
>>-- <ufi-input>
>>      select medium_int, count(*)
+>      from btsel03,btsel04
+>      group by medium_int;

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

        200                    16
        999                     8
       1000                    24
       2000                    16

--- 4 row(s) selected.
>>
>>-- <comment> similar to query above, without reference to btsel03 -
>>-- <comment> compare value returned for count(*) here to value
>>-- <comment> returned for count(*), above
>>-- <ufi-input>
>>      select medium_int, count(*)
+>      from btsel04
+>      group by medium_int;

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

       1000                     3
        999                     1
        200                     2
       2000                     2

--- 4 row(s) selected.
>>
>>
>>-- <ufi-input>
>>      select firstt.binary_64_s, count(*)
+>      from btsel01 firstt, btsel01 secondd
+>      group by firstt.binary_64_s;

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

             2000.000                    32
              200.000                     8
             1200.000                    16
             1500.000                     8

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select avg(firstt.large_int)
+>      from pvsel01 firstt, pvsel01 secondd
+>      group by firstt.medium_int;

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

             -333600
           500000500
                 999
                2000
                   0

--- 5 row(s) selected.
>>-- <ufi-input>
>>      select avg(secondd.large_int)
+>      from pvsel01 firstt, pvsel01 secondd
+>      group by firstt.medium_int;

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

           124875399
           124875399
           124875399
           124875399
           124875399

--- 5 row(s) selected.
>>-- <ufi-input>
>>      select binary_64_s, pvsel04.pic_comp_1,min(ALL decimal_2_signed)
+>      from btsel01, pvsel04
+>      group by binary_64_s,  pvsel04.pic_comp_1;

BINARY_64_S            PIC_COMP_1            (EXPR)
---------------------  --------------------  ------

             2000.000                   200     .70
             2000.000                  3000     .70
             2000.000                  2000     .70
             2000.000                  1000     .70
             2000.000                   500     .70
             2000.000                   300     .70
              200.000                   200     .50
              200.000                  3000     .50
              200.000                  2000     .50
              200.000                  1000     .50
              200.000                   500     .50
              200.000                   300     .50
             1200.000                   200     .60
             1200.000                  3000     .60
             1200.000                  2000     .60
             1200.000                  1000     .60
             1200.000                   500     .60
             1200.000                   300     .60
             1500.000                   200     .80
             1500.000                  3000     .80
             1500.000                  2000     .80
             1500.000                  1000     .80
             1500.000                   500     .80
             1500.000                   300     .80

--- 24 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel03.new_name_2, sum( pvsel03.new_name_2)
+>      from pvsel03, svsel13
+>      group by  pvsel03.new_name_2;

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

       5.00                  20.00
       6.00                  72.00

--- 2 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel03.new_name_2, sum( svsel13.new_name_2)
+>      from pvsel03, svsel13
+>      group by  pvsel03.new_name_2;

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

       5.00                  23.00
       6.00                  69.00

--- 2 row(s) selected.
>>-- <ufi-input>
>>      select svsel13.pic_comp_1, count(distinct  svsel13.var_char)
+>      from svsel13, btsel01
+>      group by  svsel13.pic_comp_1;

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

                 200                     1
                 300                     1
                 500                     1

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select svsel13.pic_comp_1, count(distinct  btsel01.var_char)
+>      from svsel13, btsel01
+>      group by  svsel13.pic_comp_1;

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

                 200                     5
                 300                     5
                 500                     5

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select binary_64_s, avg(ALL binary_32_u +  btsel04.pic_comp_1)
+>      from btsel01, btsel04
+>      group by  btsel01.binary_64_s;

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

             2000.000                 970.00
              200.000                 950.00
             1200.000                 975.00
             1500.000                 980.00

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select  btsel01.medium_int,
+>              min(ALL  pvsel01.large_int *  btsel01.medium_int)
+>      from pvsel01, btsel01
+>      group by  btsel01.medium_int;

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

      1000           -1000000000
      5000           -5000000000
      8000           -8000000000
      9000           -9000000000
     10000          -10000000000

--- 5 row(s) selected.
>>-- <ufi-input>
>>      select firstt.pic_comp_1, avg(firstt.pic_comp_1) + sum(secondd.pic_comp_1)
+>      from svsel13 firstt, svsel13 secondd
+>      group by firstt.pic_comp_1;

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

                 200                  2600
                 300                  1500
                 500                  1700

--- 3 row(s) selected.
>>
>>-- <comment> queries with predicates
>>-- <ufi-input>
>>      select firstt.binary_64_s, count(*)
+>      from btsel01 firstt, btsel01 secondd
+>      where firstt.var_char = 'thomas'
+>      group by firstt.binary_64_s;

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

             2000.000                    24

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

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

                 999                     1
                2000                     2
                1000                     3

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

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

                 200                     1
                 300                     4
                 500                     1

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

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

      8000                  1333
     10000                  1333
      9000                  1333
      1000                   999
      5000                  1333

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

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

     90                1210.00
     80                9036.00
    100                2000.00
     50                2120.00

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

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

                 200               8071999
                 300                  3000

--- 2 row(s) selected.
>>-- <end-input>
>>
>>
>>-- <testcase A6>
>>
>>-- <detail>
>>--    select joins test case - this tests the selection of aggregate
>>--    functions in HAVING clauses in conjunction with GROUP BY from
>>--    multiple tables.  Aggregates are also tested in some select
>>--    statements with all clauses and locking clauses.
>>
>>-- <templates>
>>--    US00
>>
>>-- <comment> test use of HAVING clause with no GROUP BY clause
>>-- <ufi-input>
>>      select sum(pic_decimal_2), max( pvsel04.var_char)
+>      from btsel01,pvsel04
+>      having avg( btsel01.pic_comp_1) > 500 and
+>             avg( pvsel04.pic_comp_1) > 1000;

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

               21.600  william                                                                                                                                                                                                                                                    

--- 1 row(s) selected.
>>
>>-- <ufi-input>
>>      select firstt.binary_64_s, count(*)
+>      from btsel01 firstt, btsel01 secondd
+>      group by firstt.binary_64_s
+>      having sum(distinct firstt.pic_comp_1) < 1000;

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

              200.000                     8
             1500.000                     8
             2000.000                    32

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select avg(firstt.large_int)
+>      from pvsel01 firstt, pvsel01 secondd
+>      group by firstt.medium_int
+>      having sum(firstt.large_int) > 0;

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

           500000500
                 999
                2000

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select avg(secondd.large_int)
+>      from pvsel01 firstt, pvsel01 secondd
+>      group by firstt.medium_int
+>      having sum(ALL firstt.large_int) > 0;

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

           124875399
           124875399
           124875399

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select binary_64_s, pvsel04.pic_comp_1,min(ALL decimal_2_signed)
+>      from btsel01, pvsel04
+>      group by binary_64_s,  pvsel04.pic_comp_1
+>      having max(binary_32_u) >= 50;

BINARY_64_S            PIC_COMP_1            (EXPR)
---------------------  --------------------  ------

             2000.000                   200     .70
             2000.000                  3000     .70
             2000.000                  2000     .70
             2000.000                  1000     .70
             2000.000                   500     .70
             2000.000                   300     .70
              200.000                   200     .50
              200.000                  3000     .50
              200.000                  2000     .50
              200.000                  1000     .50
              200.000                   500     .50
              200.000                   300     .50
             1200.000                   200     .60
             1200.000                  3000     .60
             1200.000                  2000     .60
             1200.000                  1000     .60
             1200.000                   500     .60
             1200.000                   300     .60
             1500.000                   200     .80
             1500.000                  3000     .80
             1500.000                  2000     .80
             1500.000                  1000     .80
             1500.000                   500     .80
             1500.000                   300     .80

--- 24 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel03.new_name_2, sum( pvsel03.new_name_2)
+>      from pvsel03, svsel13
+>      group by  pvsel03.new_name_2
+>      having sum( svsel13.new_name_1) > 500;

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

       6.00                  72.00

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel03.new_name_2, sum( svsel13.new_name_2)
+>      from pvsel03, svsel13
+>      group by  pvsel03.new_name_2
+>      having sum(distinct  svsel13.new_name_1) > 100;

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

       5.00                  23.00
       6.00                  69.00

--- 2 row(s) selected.
>>-- <ufi-input>
>>      select svsel13.pic_comp_1, count(distinct  svsel13.var_char)
+>      from svsel13, btsel01
+>      group by  svsel13.pic_comp_1
+>      having avg((new_name_1 * new_name_2) / 2) <> 240;

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

                 300                     1

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select svsel13.pic_comp_1, count(distinct btsel01.var_char)
+>      from svsel13, btsel01
+>      group by  svsel13.pic_comp_1
+>      having min( svsel13.medium_int +  btsel01.medium_int)
+>    < 2000;

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

                 300                     5

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select binary_64_s, avg(ALL binary_32_u +  btsel04.pic_comp_1)
+>      from btsel01, btsel04
+>      group by  btsel01.binary_64_s
+>      having sum( btsel04.medium_int) +
+>             sum( btsel04.pic_comp_1) > 20000;

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

             2000.000                 970.00
             1200.000                 975.00

--- 2 row(s) selected.
>>-- <ufi-input>
>>      select  btsel01.medium_int,
+>             min(ALL  pvsel01.large_int *  btsel01.medium_int)
+>      from pvsel01, btsel01
+>      group by  btsel01.medium_int
+>      having avg( btsel01.medium_int) >
+>             avg( pvsel01.medium_int);

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

      8000           -8000000000
      9000           -9000000000
     10000          -10000000000

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select  btsel01.medium_int,
+>             min(ALL  pvsel01.large_int *  btsel01.medium_int)
+>      from pvsel01, btsel01
+>      group by  btsel01.medium_int
+>      having count(*) <> 16;

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

      1000           -1000000000
      5000           -5000000000
      8000           -8000000000
      9000           -9000000000

--- 4 row(s) selected.
>>
>>
>>-- <comment> queries with predicates
>>-- <ufi-input>
>>      select large_int, count(*)
+>      from btsel01, pvsel04
+>      where  btsel01.large_int =  pvsel04.medium_int
+>      group by large_int
+>      having sum( btsel01.small_int) >
+>             sum(decimal_2_signed * 100);

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

                2000                     2
                1000                     3

--- 2 row(s) selected.
>>-- <ufi-input>
>>      select  svsel13.pic_comp_1, avg(decimal_1)
+>      from svsel13, btsel01
+>      where decimal_3_unsigned = new_name_1
+>      group by  svsel13.pic_comp_1
+>      having min(ALL pic_decimal_3) < 5;

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

                 300                     4

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel01.medium_int,
+>             avg(distinct  pvsel04.medium_int)
+>      from pvsel01, pvsel04
+>      where  pvsel01.medium_int >  pvsel04.medium_int
+>      group by  pvsel01.medium_int
+>      having avg(pic_decimal_3 *  pvsel04.medium_int) < 7500;

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

      8000                  1333
     10000                  1333
      9000                  1333
      1000                   999

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select pic_9_7, sum(binary_32_u + pic_comp_1)
+>      from btsel03, btsel04
+>      where pic_comp_1 in (medium_int, binary_64_s)
+>      group by pic_9_7
+>      having sum(distinct binary_32_u) <> 5;

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

     50                2120.00
     80                9036.00
    100                2000.00

--- 3 row(s) selected.
>>-- <ufi-input>
>>      select pic_comp_1, avg(col_7) * sum(pic_comp_1)
+>      from svsel13, svsel11
+>      where new_name_3 = col_8
+>      group by pic_comp_1
+>      having sum(col_4 * col_7) < 5000;

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

                 300                  3000

--- 1 row(s) selected.
>>
>>
>>-- <comment> complex queries
>>-- <ufi-input>
>>      select large_int, count(*)
+>      from btsel01, pvsel04
+>      where  btsel01.large_int =  pvsel04.medium_int
+>      group by large_int
+>      having sum( btsel01.small_int) >
+>             sum(decimal_2_signed * 100)
+>      order by large_int
+>      for repeatable access;

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

                1000                     3
                2000                     2

--- 2 row(s) selected.
>>-- <ufi-input>
>>      select  svsel13.pic_comp_1, avg(decimal_1)
+>      from  svsel13, btsel01
+>      where decimal_3_unsigned = new_name_1
+>      group by  svsel13.pic_comp_1
+>      having min(ALL pic_decimal_3) < 5
+>      order by 1 DESC  ,2 DESC
+>      for stable access;

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

                 300                     4

--- 1 row(s) selected.
>>-- <ufi-input>
>>      select  pvsel01.medium_int,
+>             avg(distinct  pvsel04.medium_int)
+>      from  pvsel01, pvsel04
+>      where  pvsel01.medium_int >  pvsel04.medium_int
+>      group by  pvsel01.medium_int
+>      having avg(pic_decimal_3 *  pvsel04.medium_int) < 7500
+>      order by 2
+>      for browse access;

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

      1000                   999
     10000                  1333
      9000                  1333
      8000                  1333

--- 4 row(s) selected.
>>-- <ufi-input>
>>      select pic_9_7, sum(binary_32_u + pic_comp_1)
+>      from btsel03, btsel04
+>      where pic_comp_1 in (medium_int, binary_64_s)
+>      group by pic_9_7
+>      having sum(distinct binary_32_u) <> 5
+>      order by pic_9_7 ASC
+>      for repeatable access;

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

     50                2120.00
     80                9036.00
    100                2000.00

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

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

                 300                  3000

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