I am currently using Toad for Data Analysts 2.7.0.348 (upgraded from an earlier version) and I have noticed that DB2 views are not visible in the object explorer pane. I am able to write SQL calls against these views, but I am not able to view them. Has anyone else experienced a similar problem or can point me in the direction of a solution?
-Thanks!!
I am not aware of such issue. I recommend you update to the latest Toad Data Point product and try that.
Jeff
Same problem. Try navigating here:
Tools/options/database/DB2/SQL Dictionary/Listviews.
Set the database in the drop down to your version of Db2 or most recent. There should be some SQL. Where it says Seqno = 1, change that to Seqno = 0.
This is the SQL that Toad is sending to the server to build the list of views.
Hope this helps someone.
Ophelia