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 cant 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:eri...@gm...]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: squ...@li...
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 <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
<http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktr
k> &iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
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.
************************************************************
|