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?”
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?
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”