hi,

i've SQLRPGLe program in which i'm writing a cursor to select all records, order them by a field A (suppose employee number). And once all the rows fetched for an employee and printed, print the count at the bottom. Repeat this for all the subsequent employees....

i'm not sure how to handle the print count part...i.e. in SQL how to differentiate when the new employee number begins..

i'm not willing to use ReadE or chain as the SQL query mentioned above has joins and selections date range....for which i think SQl will be faster and simple.

Thanks,

Nutan.