Mainframe, MVS and zOS Discussion

Thank you so much.

Hi,

I know tha tusing SUM FIELDS I can sum the values in an input file in sort but how can I get the count of the fields too which are summed up? For example, if my input is like this:

ABC 250
ABC 150
EFG 700
EFG 100
EFG 100
EFG 050

The output should look like:

ABC 400 2
EFG 950 4 ...

While working with cursors, I need to know the number of records selected by a cursor. I want to know this before processing the first row is fetched by cursor. Can we get this information from a variable of SQLCA? I don't know the answer to it. Need help.

Let's take a step back and understand ...

Ok. But I still not sure why it is not possible.

Thank for the answers. So basically, it is not possible actually?

Hi

While working with cursors, I need to know the number of records selected by a cursor. I want to know this before processing the first row is fetched by cursor. Can we get this information from a variable of SQLCA? I don't know the answer to it. Need help.