DB2 Views not appearing?

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