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 <ji...@ho...> wrote:
> Eric,
>
> There are a whole host of jdbc properties which can effect the way the IBM
> system handles jdbc requests.
>
>
> http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzahh/javadoc/com/ibm/as400/micro/doc-files/JDBCProperties.html?resultof=%22%53%79%73%74%65%6d%22%20%22%73%79%73%74%65%6d%22%20%22%70%72%6f%70%65%72%74%69%65%73%3a%22%20%22%70%72%6f%70%65%72%74%69%22%20
>
> 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
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
|