# Toad for DB2 5.6 (scroll for more) problem

**URL:** <https://forums.toadworld.com/t/toad-for-db2-5-6-scroll-for-more-problem/32275>\
**Category:** Toad for IBM DB2\
**Created:** [January 7, 2015, 10:37pm UTC](https://forums.toadworld.com/t/toad-for-db2-5-6-scroll-for-more-problem/32275 "2015-01-07T22:37:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![plraven](https://avatars.discourse-cdn.com/v4/letter/p/9de0a6/32.png) [@plraven](https://forums.toadworld.com/u/plraven)\
**Post date:** [January 7, 2015, 10:37pm UTC](https://forums.toadworld.com/t/toad-for-db2-5-6-scroll-for-more-problem/32275/1 "2015-01-07T22:37:58Z")

</div>

I’m using Toad for DB2 at Win 7 Ent 64. Problem is that when I scroll down to a fetch limit on data grid i.e. 1000 record, Toad doesn’t show prompt “Do you want to fetch all rows?”

---

<div class="post-metadata">

**Author:** ![Jeff\_Podlasek](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jeff_podlasek/32/29_2.png) [@Jeff\_Podlasek](https://forums.toadworld.com/u/Jeff_Podlasek)\
**Post date:** [January 9, 2015, 9:19am UTC](https://forums.toadworld.com/t/toad-for-db2-5-6-scroll-for-more-problem/32275/2 "2015-01-09T09:19:19Z")

</div>

![Grid.jpeg](https://global.discourse-cdn.com/quest/original/2X/5/5dc9b96f4148db66924f3f8cfc3be91ab91a4b6c.jpeg)

I do not see that issue running v5.6 here. How many rows are in the table?

Can you post the DDL of the table?

Can you post a screen shot of your Database General settings like shown above?

Thanks,

Jeff

---

<div class="post-metadata">

**Author:** ![plraven](https://avatars.discourse-cdn.com/v4/letter/p/9de0a6/32.png) [@plraven](https://forums.toadworld.com/u/plraven)\
**Post date:** [January 12, 2015, 2:58am UTC](https://forums.toadworld.com/t/toad-for-db2-5-6-scroll-for-more-problem/32275/3 "2015-01-12T02:58:55Z")

</div>

I’ve hit “restore defaults” and everything starts to work. It’s interetning where Toad stores setting “Do you want to read all rows…” when you tick “Do not prompt me again” 🙂
