Page 1 of 1

maximum row number limitaion on fetch?

PostPosted: Wed Dec 10, 2008 10:06 pm
by kihaho
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!!!

Re: maximum row number limitaion on fetch?

PostPosted: Thu Dec 11, 2008 2:56 am
by dick scherrer
Hello,

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

There is no magic "950 rule". . . ;)