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

 

Jim >> 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

 

Jim >> The one that changed is metadata source.  …change to 1 - Database metadata will be retrieved by calling system stored procedures in 7.1.

 

Jim >> 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.

 

Eric >> …I can now view the DB2/AS400  tables again using my Squirrel again.

 

Unfortunately, I changed the “metadata source” driver property to a value of ‘1’, and I still can’t view the table list.  I was using the Client Access driver from March 2012, but I just downloaded and registered with SQuirreL the March 2014 version 8.2 jt400.jar from the web site http://sourceforge.net/projects/jt400/ (the web page said it would be version 8.1), with the same result.

 

Now I just checked a Microsoft SQL Server connection, and see that I cannot expand any categories (such as “TABLE”) underneath a schema (such as “dbo”) within a SQL Server database, either.

 

So there must be some other setting that I have wrong?

 

René A Valencourt, CCP, MCTS
Senior Programmer/Analyst

IS Department

CTB, Inc.
A Berkshire Hathaway Company

 

From: Eric Gulatee [mailto:eric.gulatee@gmail.com]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: squirrel-sql-users@lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

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

************************************************************
This message may contain privileged, confidential and/or
trade secret information which is protected by law and is
intended only for the addressee.  If you are not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this message is strictly
prohibited.  If you have received this message in error, 
please immediately notify us, and permanently delete all
copies of the message.  Due to the nature of the Internet, 
e-mail messages are not secure and may be delayed or
undelivered.  Also, in accordance with CTB company policy,
e-mail messages may be reviewed or retained by CTB
employees in addition to or other than the intended recipient.


This footnote also confirms that this email message has
been swept by Postini for the presence of computer viruses.
************************************************************