I have been using TOAD for DB2 version 22.214.171.1243 for a few weeks now. I have liked it for the most part. There is one feature that left in version 5.6 that has been a huge deal breaker for me and I was wondering if there was a way to fix it. I am going to try to explain this the best I can.
When you are in Object Explorer searching for objects in the db, by default TOAD will put case sensitive to true. I am not sure why you would want that to true, but it is. All our objects are in upper case which is fine, but I never have caps lock on so when I search for various things I never find them. In TOAD you can create filter rules and change the case sensitive. After creating the filter rule it seemed to keep the rule applied besides the search string in 5.6 unlike 6.0. I will outlay in a various screen shots. I hope you can follow along.
My Filter Rule:
Now lets change the ‘fr’ to ‘al’ and tab over to see the results. There are all my tables that contains ‘al’ in there.
***TOAD 6.0 ***
Now lets do the same thing in 5.6. Change ‘fr’ to ‘al’ and hit tab.
Now as you can see nothing shows up in 6.0. The reason is its not applying the filter rule I created. The string ‘case (named):’ is populated by TOAD.
Does my issue make sense? Is there way to make the same functionality happen in 6.0?
Any help is greatly appreciated!