Interesting is the fact that v. 3.5.0 was able to access i5 and after migration to i7 it is still able to access.

Was using iAccess 7.1 on this box before and after migration if that matters.


Thank you!



From: Eric Gulatee []
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1




Thank you for the pointer.  I can now view the DB2/AS400  tables again using my Squirrel again.  

Much appreciated.



Eric Gulatee


On Mon, Mar 3, 2014 at 3:44 PM, Jim It <> wrote:



There are a whole host of jdbc properties which can effect the way the IBM system handles jdbc requests.



The one that changed is metadata source.  The default setting was 0 - Database metadata will be retrieved through the Retrieve Object Information (ROI) data flow, but was change to 1 - Database metadata will be retrieved by calling system stored procedures in 7.1.


Go into Alias properties, Driver Properties tab and specify the driver properties you want to use and the value you want to use, in this case 1.


Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works.
Faster operations. Version large binaries.  Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
Squirrel-sql-users mailing list