IBM Mainframe Forum

I have a batch job abending when it fetches more than 950 rows.
However, when I look at the program, there is no limitation set for how many rows can be fetched.
This program/job was established before my time and the developer is not here any longer.
Therefore, I cannot ask anybody why it abends when it hits over 950 rows.
Is there set rule in DB2 as to how many rows you could fetch at a time?
Thank you!!!

Hello,

Does the program abend or do you get an undesirable db2 return code?

There is no magic "950 rule". . .