|
From: Cristiano G. <cri...@gm...> - 2012-09-08 19:56:19
|
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 <rob...@gm...>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 < > aan...@bc...> 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.**** >> >> |
