Page 1 of 1

rowset positionning with control break within

PostPosted: Tue Jan 03, 2017 8:16 pm
by wolfi57
Hi,
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.