maximum row number limitaion on fetch?

IBM's flagship relational database management system

maximum row number limitaion on fetch?

Postby kihaho » Wed Dec 10, 2008 10:06 pm

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!!!
Posts: 19
Joined: Tue May 06, 2008 11:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: maximum row number limitaion on fetch?

Postby dick scherrer » Thu Dec 11, 2008 2:56 am


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

There is no magic "950 rule". . . ;)
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6269
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Return to DB2


  • Related topics
    Last post