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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!