rowset positionning with control break within

IBM's flagship relational database management system

rowset positionning with control break within

Postby wolfi57 » Tue Jan 03, 2017 8:16 pm

I have a requirement to fetch a table and do some control break ( in cobol ).
I thought for performance using rowset positioning but how to manage control break on fields inside sql statement and not by browse host array.
Thus each fetch next rowset have all my rows for a control break key.
For example:
Table a

Column A ( technical key) col B col C col D
tS1                                    AAAA   0001     A
ts2                                     AAAA   0001     B
ts3                                     BBBB   0001      A
ts4                                      BBBB   0001     B

For each next rowset it returns only subset on (col B and col C) , return 2 row even I specified for 300 row
of course I have between 150 and 270 occurs in group formed by (col B and col C)

Edited by moderator to change 'field' to 'col' - we are talking a DB2 table.
Also provided punctuation to make things clearer.
Posts: 10
Joined: Fri Dec 16, 2016 10:51 pm
Has thanked: 0 time
Been thanked: 0 time

Return to DB2


  • Related topics
    Last post