Oh, I didn't recognize Z/OS as being equal to Mainframe DB2.  There are so many flavors that I don't have access to; its hard to keep track of them all :)

Rob

On Sat, Sep 8, 2012 at 3:55 PM, Cristiano Guadagnino <criguada@gmail.com> wrote:
Robert,
I sent the correct queries for DB2 Z/OS a couple years ago. They are stilll available on sourceforge: in the "Feature Requests" tracker, ID 3134781. I could not attach a file so I wrote the queries as a comment.

Hope you can make something out of it. I am able and willing to test.

Bye
Cris




On Sat, Sep 8, 2012 at 12:54 PM, Robert Manning <robert.m.manning@gmail.com> wrote:
Since none of us SQuirreL developers have access to this platform, its hard to test.  However, if you could look at the "Metadata" tab in the object tab (click on the root node of the object tree) and tell us the value of the property named "getDatabaseProductName", we may be able to update the plugin to use the tables you have suggested.

Rob

On Fri, Sep 7, 2012 at 3:14 PM, Tony (Antonious) Anderson <aanderson@bcbsal.org> wrote:

When looking through the object tree for Triggers and Indexes, Squirrel attempts to run queries against SYSCAT.TRIGGERS and SYSCAT.INDEXES.  These are not valid catalog objects in mainframe DB2.  This causes -204, -514, and -516  sql errors in the tool.  How would one go about getting Squirrel updated to use the SYSIBM.SYSTRIGGERS and SYSIBM.SYSINDEXES instead?

 

Thanks.