Can you (or anyone else paying attention to this thread) when you connect to DB2 on Z/OS with SQuirreL, look at the "Metadata" tab in the object tab (click on the root node of the object tree) and tell me the value of the property named "getDatabaseProductName". I need this in order to branch the logic that chooses which SQL statements to use when connected to DB2-UDB, DB2-OS400 or DB2-Z/OS.
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.
CrisOn Sat, Sep 8, 2012 at 12:54 PM, Robert Manning <firstname.lastname@example.org> 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.
RobOn Fri, Sep 7, 2012 at 3:14 PM, Tony (Antonious) Anderson <email@example.com> 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?