Jim,

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

Cheers,
Eric Gulatee


On Mon, Mar 3, 2014 at 3:44 PM, Jim It <jim_it@hotmail.com> wrote:
Eric,

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.

Jim

------------------------------------------------------------------------------
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.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users