|
From: Robert M. <rob...@gm...> - 2012-09-11 12:53:35
|
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 <cri...@gm...>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 < > 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.**** >>> >>> > |
