RPGLE Example for reading SQL GROUP BY ROLLUP result

Hi all



I'm looking for some RPGLE example for reading the following SQL result



SELECT CLCLI, CLUB1, CLUB2, CLUB3, CLCAR, cllsi,

sum(clqis) FROM OCLLw00F WHERE CLSTS <>

'C' GROUP BY ROLLUP


(CLCLI, CLUB1, CLUB2, CLUB3, CLCAR, cllsi )


ORDER BY CLCLI, CLUB1, CLUB2, CLUB3, CLCAR



I would need to check the break level when CLCLI and CLCAR change , how can
I do it ? I check the null value .. how can I check the null value




34815 A01 002 0080502 1952
1,0000

34815 A01 002 0080502 -
1,0000

34815 A01 002 - -
1,0000

34815 A01 002 - - -
1,0000

34815 A01 003 0080501 1951
1,0000

34815 A01 003 0080501 1952
1,0000

34815 A01 003 0080501 -
2,0000

34815 A01 003 0080505 1951
1,0000

34815 A01 003 0080505 -
1,0000

34815 A01 003 - -
3,0000

34815 A01 003 - - -
3,0000

34815 A01 - - - -
4,0000

34815 - - - - -
4,0000

- - - - - -
4,0000

- - - - - -
4,0000