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