Re: Issues with DB2/AS400 v 7.1

classic Classic list List threaded Threaded
18 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

René A Valencourt

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:[hidden email]]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: [hidden email]
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 <[hidden email]> 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
[hidden email]
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.
************************************************************


------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

Alex Malmyguine

Rene:

 

What was the problem back then?

This is how driver is set up on my machine. As you can see I am still on 3.5.0 and it still works fine against i7.1

 

 

From: René A Valencourt [mailto:[hidden email]]
Sent: Wednesday, October 15, 2014 3:29 PM
To: Alex Malmyguine
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

This has been quite a delay in answering your question…

 

>> What versions of Squirrel and JT Open are you using?

 

I was on whatever version of Squirrel were current in April (either possibly 3.5.0 but maybe earlier) and JTOpen I thought was version 8.2, but I just discovered that the folder was empty (whether it were empty in April I don’t know).  So it had actually been using whatever came with Client Access, which was from 2012.

 

The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on my 64-bit Windows 7 PC.

 

So I:

·         upgraded to Squirrel 3.6

·         upgraded to JTOpen 8.3

·         updated my driver definition in squirrel to point to the new default jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)

 

and get the same result.

 

Then I

·         updated my driver definition in squirrel to point to the new jt400.jar for Java 6 and higher (C:\Program Files (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)

 

and still get the same result.

 

>> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.  …You might want to use that as a workaround until you figured out Squirrel.

 

I downloaded JTOpen 7.1, and put its jt400.jar at the head of the list, but nothing changed.

 

Has anyone had this problem and found a resolution?

 

Thanks,

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Friday, April 25, 2014 4:37 PM
To: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What versions of Squirrel and JT Open are you using?

 

I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.

 

Using the same JTOpen driver I can connect to iSeries from Oracle SQL Developer too. You might want to use that as a workaround until you figured out Squirrel.

 

Thank you!

Alex

 

From: René A Valencourt [[hidden email]]
Sent: Friday, April 25, 2014 3:30 PM
To: 'Eric Gulatee'; 'Jim It'
Cc: [hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

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 [[hidden email]]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: [hidden email]
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 <[hidden email]> 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
[hidden email]
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.
************************************************************

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


------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

René A Valencourt

Hello Alex,

 

>> What was the problem back then?

 

I expected to be able to view all objects associated with any given schema.  I am able to see at least the aliases, procedures, and sequences associated with any given schema.  But I am not able to see the tables for ANY schema, even when I have specified a default schema by the various means available – either doing it as you did, or by specifying the “libraries” property, or by specifying the “database name” property.

 

I was also having the same problem with MS SQL Server, but if given a default schema, Squirrel does show me the associated tables for that schema.

 

Here are my driver (using the jtopen 7.1 jar file) and alias definitions:

 

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [mailto:[hidden email]]
Sent: Wednesday, October 15, 2014 3:43 PM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What was the problem back then?

This is how driver is set up on my machine. As you can see I am still on 3.5.0 and it still works fine against i7.1

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 3:29 PM
To: Alex Malmyguine
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

This has been quite a delay in answering your question…

 

>> What versions of Squirrel and JT Open are you using?

 

I was on whatever version of Squirrel were current in April (either possibly 3.5.0 but maybe earlier) and JTOpen I thought was version 8.2, but I just discovered that the folder was empty (whether it were empty in April I don’t know).  So it had actually been using whatever came with Client Access, which was from 2012.

 

The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on my 64-bit Windows 7 PC.

 

So I:

·         upgraded to Squirrel 3.6

·         upgraded to JTOpen 8.3

·         updated my driver definition in squirrel to point to the new default jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)

 

and get the same result.

 

Then I

·         updated my driver definition in squirrel to point to the new jt400.jar for Java 6 and higher (C:\Program Files (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)

 

and still get the same result.

 

>> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.  …You might want to use that as a workaround until you figured out Squirrel.

 

I downloaded JTOpen 7.1, and put its jt400.jar at the head of the list, but nothing changed.

 

Has anyone had this problem and found a resolution?

 

Thanks,

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Friday, April 25, 2014 4:37 PM
To: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What versions of Squirrel and JT Open are you using?

 

I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.

 

Using the same JTOpen driver I can connect to iSeries from Oracle SQL Developer too. You might want to use that as a workaround until you figured out Squirrel.

 

Thank you!

Alex

 

From: René A Valencourt [[hidden email]]
Sent: Friday, April 25, 2014 3:30 PM
To: 'Eric Gulatee'; 'Jim It'
Cc: [hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

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 [[hidden email]]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: [hidden email]
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 <[hidden email]> 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
[hidden email]
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.
************************************************************

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


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

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

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

Alex Malmyguine

Rene,

 

Did you by any chance use this tab in the alias editor to inhibit loading of the schemas?

 

 

From: René A Valencourt [mailto:[hidden email]]
Sent: Wednesday, October 15, 2014 4:43 PM
To: Alex Malmyguine
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

>> What was the problem back then?

 

I expected to be able to view all objects associated with any given schema.  I am able to see at least the aliases, procedures, and sequences associated with any given schema.  But I am not able to see the tables for ANY schema, even when I have specified a default schema by the various means available – either doing it as you did, or by specifying the “libraries” property, or by specifying the “database name” property.

 

I was also having the same problem with MS SQL Server, but if given a default schema, Squirrel does show me the associated tables for that schema.

 

Here are my driver (using the jtopen 7.1 jar file) and alias definitions:

 

 

 

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Wednesday, October 15, 2014 3:43 PM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What was the problem back then?

This is how driver is set up on my machine. As you can see I am still on 3.5.0 and it still works fine against i7.1

 

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 3:29 PM
To: Alex Malmyguine
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

This has been quite a delay in answering your question…

 

>> What versions of Squirrel and JT Open are you using?

 

I was on whatever version of Squirrel were current in April (either possibly 3.5.0 but maybe earlier) and JTOpen I thought was version 8.2, but I just discovered that the folder was empty (whether it were empty in April I don’t know).  So it had actually been using whatever came with Client Access, which was from 2012.

 

The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on my 64-bit Windows 7 PC.

 

So I:

·         upgraded to Squirrel 3.6

·         upgraded to JTOpen 8.3

·         updated my driver definition in squirrel to point to the new default jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)

 

and get the same result.

 

Then I

·         updated my driver definition in squirrel to point to the new jt400.jar for Java 6 and higher (C:\Program Files (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)

 

and still get the same result.

 

>> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.  …You might want to use that as a workaround until you figured out Squirrel.

 

I downloaded JTOpen 7.1, and put its jt400.jar at the head of the list, but nothing changed.

 

Has anyone had this problem and found a resolution?

 

Thanks,

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Friday, April 25, 2014 4:37 PM
To: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What versions of Squirrel and JT Open are you using?

 

I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.

 

Using the same JTOpen driver I can connect to iSeries from Oracle SQL Developer too. You might want to use that as a workaround until you figured out Squirrel.

 

Thank you!

Alex

 

From: René A Valencourt [[hidden email]]
Sent: Friday, April 25, 2014 3:30 PM
To: 'Eric Gulatee'; 'Jim It'
Cc: [hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

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 [[hidden email]]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: [hidden email]
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 <[hidden email]> 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

René A Valencourt

Hi Alex,

 

Thanks for asking!  …but I had done nothing with schema.  Here is the spec:

 

 

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

IS Department
CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [mailto:[hidden email]]
Sent: Wednesday, October 15, 2014 4:58 PM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene,

 

Did you by any chance use this tab in the alias editor to inhibit loading of the schemas?

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 4:43 PM
To: Alex Malmyguine
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

>> What was the problem back then?

 

I expected to be able to view all objects associated with any given schema.  I am able to see at least the aliases, procedures, and sequences associated with any given schema.  But I am not able to see the tables for ANY schema, even when I have specified a default schema by the various means available – either doing it as you did, or by specifying the “libraries” property, or by specifying the “database name” property.

 

I was also having the same problem with MS SQL Server, but if given a default schema, Squirrel does show me the associated tables for that schema.

 

Here are my driver (using the jtopen 7.1 jar file) and alias definitions:

 

 

 

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Wednesday, October 15, 2014 3:43 PM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What was the problem back then?

This is how driver is set up on my machine. As you can see I am still on 3.5.0 and it still works fine against i7.1

 

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 3:29 PM
To: Alex Malmyguine
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

This has been quite a delay in answering your question…

 

>> What versions of Squirrel and JT Open are you using?

 

I was on whatever version of Squirrel were current in April (either possibly 3.5.0 but maybe earlier) and JTOpen I thought was version 8.2, but I just discovered that the folder was empty (whether it were empty in April I don’t know).  So it had actually been using whatever came with Client Access, which was from 2012.

 

The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on my 64-bit Windows 7 PC.

 

So I:

·         upgraded to Squirrel 3.6

·         upgraded to JTOpen 8.3

·         updated my driver definition in squirrel to point to the new default jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)

 

and get the same result.

 

Then I

·         updated my driver definition in squirrel to point to the new jt400.jar for Java 6 and higher (C:\Program Files (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)

 

and still get the same result.

 

>> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.  …You might want to use that as a workaround until you figured out Squirrel.

 

I downloaded JTOpen 7.1, and put its jt400.jar at the head of the list, but nothing changed.

 

Has anyone had this problem and found a resolution?

 

Thanks,

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Friday, April 25, 2014 4:37 PM
To: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What versions of Squirrel and JT Open are you using?

 

I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.

 

Using the same JTOpen driver I can connect to iSeries from Oracle SQL Developer too. You might want to use that as a workaround until you figured out Squirrel.

 

Thank you!

Alex

 

From: René A Valencourt [[hidden email]]
Sent: Friday, April 25, 2014 3:30 PM
To: 'Eric Gulatee'; 'Jim It'
Cc: [hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

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 [[hidden email]]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: [hidden email]
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 <[hidden email]> 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
[hidden email]
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.
************************************************************

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

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

Alex Malmyguine

Do you mean you do not see the tables even in the schema specified in the alias?

I can see them in TESTDAT which is the schema in the alias, but not in the other schemas.

 

 

From: René A Valencourt [mailto:[hidden email]]
Sent: Wednesday, October 15, 2014 5:10 PM
To: Alex Malmyguine
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hi Alex,

 

Thanks for asking!  …but I had done nothing with schema.  Here is the spec:

 

 

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

IS Department
CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Wednesday, October 15, 2014 4:58 PM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene,

 

Did you by any chance use this tab in the alias editor to inhibit loading of the schemas?

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 4:43 PM
To: Alex Malmyguine
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

>> What was the problem back then?

 

I expected to be able to view all objects associated with any given schema.  I am able to see at least the aliases, procedures, and sequences associated with any given schema.  But I am not able to see the tables for ANY schema, even when I have specified a default schema by the various means available – either doing it as you did, or by specifying the “libraries” property, or by specifying the “database name” property.

 

I was also having the same problem with MS SQL Server, but if given a default schema, Squirrel does show me the associated tables for that schema.

 

Here are my driver (using the jtopen 7.1 jar file) and alias definitions:

 

 

 

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Wednesday, October 15, 2014 3:43 PM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What was the problem back then?

This is how driver is set up on my machine. As you can see I am still on 3.5.0 and it still works fine against i7.1

 

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 3:29 PM
To: Alex Malmyguine
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

This has been quite a delay in answering your question…

 

>> What versions of Squirrel and JT Open are you using?

 

I was on whatever version of Squirrel were current in April (either possibly 3.5.0 but maybe earlier) and JTOpen I thought was version 8.2, but I just discovered that the folder was empty (whether it were empty in April I don’t know).  So it had actually been using whatever came with Client Access, which was from 2012.

 

The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on my 64-bit Windows 7 PC.

 

So I:

·         upgraded to Squirrel 3.6

·         upgraded to JTOpen 8.3

·         updated my driver definition in squirrel to point to the new default jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)

 

and get the same result.

 

Then I

·         updated my driver definition in squirrel to point to the new jt400.jar for Java 6 and higher (C:\Program Files (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)

 

and still get the same result.

 

>> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.  …You might want to use that as a workaround until you figured out Squirrel.

 

I downloaded JTOpen 7.1, and put its jt400.jar at the head of the list, but nothing changed.

 

Has anyone had this problem and found a resolution?

 

Thanks,

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Friday, April 25, 2014 4:37 PM
To: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What versions of Squirrel and JT Open are you using?

 

I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.

 

Using the same JTOpen driver I can connect to iSeries from Oracle SQL Developer too. You might want to use that as a workaround until you figured out Squirrel.

 

Thank you!

Alex

 

From: René A Valencourt [[hidden email]]
Sent: Friday, April 25, 2014 3:30 PM
To: 'Eric Gulatee'; 'Jim It'
Cc: [hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

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 [[hidden email]]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: [hidden email]
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 <[hidden email]> 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
[hidden email]
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.
************************************************************

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


------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

Jim It
In reply to this post by René A Valencourt
Rene,

I've been using SquirrelSQL with DB2 for i for 10+ years.  It only takes me about 5 minutes to install/configure SquirrelSQL on a windows based system.  Currently, I am running java version "1.8.0_20", SquirrelSQL (snapshot 20140911_2017) on windows 7 64bit connecting to V7R1 TR8 database.  I have no issues seeing OS/400 objects in the DB tree.


I looks like you have the DB2 for i JDBC driver installed and loaded correctly, now it is just the settings within SquirrelSQL which make everything work with os/400.


Starting with a brand new alias definition;
Enter Alias Name, Select Db2 for i driver in loaded drivers, enter jdbc URL for the i partition to connect to, user name and password.


Next, click the Properties button.  There are 4 tabs displayed, only need to change settings on the first two tabs.
Tab 1 - Schemas
  • Highlight Specify Schema loading and caching radio button.
  • Press Connect database to refresh Schema table.  (populates Schema list)
  • Below Schema list, change drop down to Don't Load and click apply. (changes all schemas to not load data)
  • Scroll through the list of Schema's and select the libraries you want to see the object details for and change Tables, Views and Procedures to Load but don't cache.
Tab2 - Driver Proprieties
  • Click use driver properties checkbox.
  • Change the following properties:
    • errors = full
    • transaction isolation = none
    • translate binary = true
    • extended metadata = true
    • metadata source = 0


Then in SquirrelSQL application, File -> Global Preferences -> Data Type Controls tab.
  • BLOB (SQL type 2004) - Read all
  • CLOB (SQL type 2005) - Read all and show new lines as /n
  • SQL Other (SQL type 1111) - Read contents when table is first loaded and display as string
  • FLOAT, REAL, DOUBLE, NUMERIC, DECIMAL (SQL types 6,7,8,2,3) - use default format (if you don't wan't 1000's comma separator)


This should allow SquirrelSQL to show the database objects in the tree that you specified and see the tabbed object attributes correctly.


Jim



From: [hidden email]
To: [hidden email]
Date: Wed, 15 Oct 2014 16:43:28 -0400
CC: [hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

Hello Alex,

 

>> What was the problem back then?

 

I expected to be able to view all objects associated with any given schema.  I am able to see at least the aliases, procedures, and sequences associated with any given schema.  But I am not able to see the tables for ANY schema, even when I have specified a default schema by the various means available – either doing it as you did, or by specifying the “libraries” property, or by specifying the “database name” property.

 

I was also having the same problem with MS SQL Server, but if given a default schema, Squirrel does show me the associated tables for that schema.

 

Here are my driver (using the jtopen 7.1 jar file) and alias definitions:

 

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [mailto:[hidden email]]
Sent: Wednesday, October 15, 2014 3:43 PM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What was the problem back then?

This is how driver is set up on my machine. As you can see I am still on 3.5.0 and it still works fine against i7.1

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 3:29 PM
To: Alex Malmyguine
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

This has been quite a delay in answering your question…

 

>> What versions of Squirrel and JT Open are you using?

 

I was on whatever version of Squirrel were current in April (either possibly 3.5.0 but maybe earlier) and JTOpen I thought was version 8.2, but I just discovered that the folder was empty (whether it were empty in April I don’t know).  So it had actually been using whatever came with Client Access, which was from 2012.

 

The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on my 64-bit Windows 7 PC.

 

So I:

·         upgraded to Squirrel 3.6

·         upgraded to JTOpen 8.3

·         updated my driver definition in squirrel to point to the new default jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)

 

and get the same result.

 

Then I

·         updated my driver definition in squirrel to point to the new jt400.jar for Java 6 and higher (C:\Program Files (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)

 

and still get the same result.

 

>> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.  …You might want to use that as a workaround until you figured out Squirrel.

 

I downloaded JTOpen 7.1, and put its jt400.jar at the head of the list, but nothing changed.

 

Has anyone had this problem and found a resolution?

 

Thanks,

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Friday, April 25, 2014 4:37 PM
To: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What versions of Squirrel and JT Open are you using?

 

I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.

 

Using the same JTOpen driver I can connect to iSeries from Oracle SQL Developer too. You might want to use that as a workaround until you figured out Squirrel.

 

Thank you!

Alex

 

From: René A Valencourt [[hidden email]]
Sent: Friday, April 25, 2014 3:30 PM
To: 'Eric Gulatee'; 'Jim It'
Cc: [hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

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 [[hidden email]]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: [hidden email]
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 <[hidden email]> 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
[hidden email]
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.
************************************************************

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


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

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

------------------------------------------------------------------------------ Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://p.sf.net/sfu/Zoho
_______________________________________________ Squirrel-sql-users mailing list [hidden email] https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

René A Valencourt
In reply to this post by Alex Malmyguine

Hi Alex,

 

>> Do you mean you do not see the tables even in the schema specified in the alias?

 

Precisely.  I discovered that the reason is having specified “Load all Schemas, cache none”.

 

·         If I specify “Load all Schemas, cache none”, then neither Tables nor Views can be seen, although Procedures do appear.

·         If I specify “Load all and cache all Schemas”, then I can see the Tables, Views, and Procedures.

·         If I “Specify Schema loading and caching”, then I can get a variety of results.  If I specify “Load…” for Tables, Views, or Procedures, then I will see the items specified to be loaded.  However, if I specify some to be loaded and others not to be loaded, I can get a variety of results.  If I specify “Don’t load” for some, but “Load…” for others, I may see still see all three, or maybe only a subset.  Appearance of objects not selected to be loaded appears to have to do with whether I had earlier specified loading for them…

 

So, the bottom line is that I can actually see tables and views for everything if I specify individual Schema loading, or “Load all and cache all Schemas”.

 

But,

1.    There is a bug with Tables and Views not displaying with “Load all Schemas, cache none”.

2.    There is also a bug with “Specify Schema loading and caching”, in that Tables, Views, and Properties may show even if they have been specified not to load.  It appears to relate to the information still being in the cache, if they had been earlier specified to load.

 

Is it sufficient to report this here, or do I need to report bugs elsewhere?

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [mailto:[hidden email]]
Sent: Thursday, October 16, 2014 8:45 AM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Do you mean you do not see the tables even in the schema specified in the alias?

I can see them in TESTDAT which is the schema in the alias, but not in the other schemas.

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 5:10 PM
To: Alex Malmyguine
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hi Alex,

 

Thanks for asking!  …but I had done nothing with schema.  Here is the spec:

 

 

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

IS Department
CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Wednesday, October 15, 2014 4:58 PM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene,

 

Did you by any chance use this tab in the alias editor to inhibit loading of the schemas?

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 4:43 PM
To: Alex Malmyguine
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

>> What was the problem back then?

 

I expected to be able to view all objects associated with any given schema.  I am able to see at least the aliases, procedures, and sequences associated with any given schema.  But I am not able to see the tables for ANY schema, even when I have specified a default schema by the various means available – either doing it as you did, or by specifying the “libraries” property, or by specifying the “database name” property.

 

I was also having the same problem with MS SQL Server, but if given a default schema, Squirrel does show me the associated tables for that schema.

 

Here are my driver (using the jtopen 7.1 jar file) and alias definitions:

 

 

 

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Wednesday, October 15, 2014 3:43 PM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What was the problem back then?

This is how driver is set up on my machine. As you can see I am still on 3.5.0 and it still works fine against i7.1

 

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 3:29 PM
To: Alex Malmyguine
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

This has been quite a delay in answering your question…

 

>> What versions of Squirrel and JT Open are you using?

 

I was on whatever version of Squirrel were current in April (either possibly 3.5.0 but maybe earlier) and JTOpen I thought was version 8.2, but I just discovered that the folder was empty (whether it were empty in April I don’t know).  So it had actually been using whatever came with Client Access, which was from 2012.

 

The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on my 64-bit Windows 7 PC.

 

So I:

·         upgraded to Squirrel 3.6

·         upgraded to JTOpen 8.3

·         updated my driver definition in squirrel to point to the new default jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)

 

and get the same result.

 

Then I

·         updated my driver definition in squirrel to point to the new jt400.jar for Java 6 and higher (C:\Program Files (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)

 

and still get the same result.

 

>> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.  …You might want to use that as a workaround until you figured out Squirrel.

 

I downloaded JTOpen 7.1, and put its jt400.jar at the head of the list, but nothing changed.

 

Has anyone had this problem and found a resolution?

 

Thanks,

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Friday, April 25, 2014 4:37 PM
To: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What versions of Squirrel and JT Open are you using?

 

I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.

 

Using the same JTOpen driver I can connect to iSeries from Oracle SQL Developer too. You might want to use that as a workaround until you figured out Squirrel.

 

Thank you!

Alex

 

From: René A Valencourt [[hidden email]]
Sent: Friday, April 25, 2014 3:30 PM
To: 'Eric Gulatee'; 'Jim It'
Cc: [hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

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 [[hidden email]]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: [hidden email]
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 <[hidden email]> 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
[hidden email]
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.
************************************************************

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

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

Alex Malmyguine

Wow, it sounds like this is really a bug introduced after 3.5.0

I am glad I am still using an older version! Thanks for reporting this – I hope developers see this bug report and eventually it gets corrected.

 

Regards

Alex

 

From: René A Valencourt [mailto:[hidden email]]
Sent: Friday, October 17, 2014 10:35 AM
To: Alex Malmyguine
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hi Alex,

 

>> Do you mean you do not see the tables even in the schema specified in the alias?

 

Precisely.  I discovered that the reason is having specified “Load all Schemas, cache none”.

 

·         If I specify “Load all Schemas, cache none”, then neither Tables nor Views can be seen, although Procedures do appear.

·         If I specify “Load all and cache all Schemas”, then I can see the Tables, Views, and Procedures.

·         If I “Specify Schema loading and caching”, then I can get a variety of results.  If I specify “Load…” for Tables, Views, or Procedures, then I will see the items specified to be loaded.  However, if I specify some to be loaded and others not to be loaded, I can get a variety of results.  If I specify “Don’t load” for some, but “Load…” for others, I may see still see all three, or maybe only a subset.  Appearance of objects not selected to be loaded appears to have to do with whether I had earlier specified loading for them…

 

So, the bottom line is that I can actually see tables and views for everything if I specify individual Schema loading, or “Load all and cache all Schemas”.

 

But,

1.    There is a bug with Tables and Views not displaying with “Load all Schemas, cache none”.

2.    There is also a bug with “Specify Schema loading and caching”, in that Tables, Views, and Properties may show even if they have been specified not to load.  It appears to relate to the information still being in the cache, if they had been earlier specified to load.

 

Is it sufficient to report this here, or do I need to report bugs elsewhere?

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Thursday, October 16, 2014 8:45 AM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Do you mean you do not see the tables even in the schema specified in the alias?

I can see them in TESTDAT which is the schema in the alias, but not in the other schemas.

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 5:10 PM
To: Alex Malmyguine
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hi Alex,

 

Thanks for asking!  …but I had done nothing with schema.  Here is the spec:

 

 

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

IS Department
CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Wednesday, October 15, 2014 4:58 PM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene,

 

Did you by any chance use this tab in the alias editor to inhibit loading of the schemas?

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 4:43 PM
To: Alex Malmyguine
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

>> What was the problem back then?

 

I expected to be able to view all objects associated with any given schema.  I am able to see at least the aliases, procedures, and sequences associated with any given schema.  But I am not able to see the tables for ANY schema, even when I have specified a default schema by the various means available – either doing it as you did, or by specifying the “libraries” property, or by specifying the “database name” property.

 

I was also having the same problem with MS SQL Server, but if given a default schema, Squirrel does show me the associated tables for that schema.

 

Here are my driver (using the jtopen 7.1 jar file) and alias definitions:

 

 

 

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Wednesday, October 15, 2014 3:43 PM
To: [hidden email]
Cc: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What was the problem back then?

This is how driver is set up on my machine. As you can see I am still on 3.5.0 and it still works fine against i7.1

 

 

 

From: René A Valencourt [[hidden email]]
Sent: Wednesday, October 15, 2014 3:29 PM
To: Alex Malmyguine
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Hello Alex,

 

This has been quite a delay in answering your question…

 

>> What versions of Squirrel and JT Open are you using?

 

I was on whatever version of Squirrel were current in April (either possibly 3.5.0 but maybe earlier) and JTOpen I thought was version 8.2, but I just discovered that the folder was empty (whether it were empty in April I don’t know).  So it had actually been using whatever came with Client Access, which was from 2012.

 

The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on my 64-bit Windows 7 PC.

 

So I:

·         upgraded to Squirrel 3.6

·         upgraded to JTOpen 8.3

·         updated my driver definition in squirrel to point to the new default jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)

 

and get the same result.

 

Then I

·         updated my driver definition in squirrel to point to the new jt400.jar for Java 6 and higher (C:\Program Files (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)

 

and still get the same result.

 

>> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.  …You might want to use that as a workaround until you figured out Squirrel.

 

I downloaded JTOpen 7.1, and put its jt400.jar at the head of the list, but nothing changed.

 

Has anyone had this problem and found a resolution?

 

Thanks,

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Alex Malmyguine [[hidden email]]
Sent: Friday, April 25, 2014 4:37 PM
To: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene:

 

What versions of Squirrel and JT Open are you using?

 

I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works fine with iSeries 7.1 and 5.3 DB with default settings.

 

Using the same JTOpen driver I can connect to iSeries from Oracle SQL Developer too. You might want to use that as a workaround until you figured out Squirrel.

 

Thank you!

Alex

 

From: René A Valencourt [[hidden email]]
Sent: Friday, April 25, 2014 3:30 PM
To: 'Eric Gulatee'; 'Jim It'
Cc: [hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

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 [[hidden email]]
Sent: Thursday, March 20, 2014 3:14 PM
To: Jim It
Cc: [hidden email]
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 <[hidden email]> 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
[hidden email]
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.
************************************************************

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


------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

John Hardin
In reply to this post by René A Valencourt
On Fri, 17 Oct 2014, René A Valencourt wrote:

> Is it sufficient to report this here, or do I need to report bugs elsewhere?

I suggest you open a new bug in SourceForge bugzilla:

   https://sourceforge.net/p/squirrel-sql/bugs/new/

--
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  [hidden email]    FALaholic #11174     pgpk -a [hidden email]
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   When I say "I don't want the government to do X", do not
   automatically assume that means I don't want X to happen.
-----------------------------------------------------------------------
  869 days since the first successful private support mission to ISS (SpaceX)
------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

Gerd Wagner-3
In reply to this post by René A Valencourt
Alex,

I just tried to reproduce your problem on a PostgreSQL and couldn't see
your problem. Schema loading works alright there.

Unfortunately I don't have access to a DB2/AS400. Do you or anybody else
know of a way I could reproduce the problem?

Sorry for the inconvenience

Gerd



Am 17.10.2014 um 16:35 schrieb René A Valencourt:

> Hi Alex,
>
>>>Do you mean you do not see the tables even in the schema specified in
> the alias?
>
> Precisely.I discovered that the reason is having specified “Load all
> Schemas, cache none”.
>
> ·If I specify “Load all Schemas, cache none”, then neither Tables nor
> Views can be seen, although Procedures do appear.
>
> ·If I specify “Load all and cache all Schemas”, then I can see the
> Tables, Views, and Procedures.
>
> ·If I “Specify Schema loading and caching”, then I can get a variety of
> results.If I specify “Load…” for Tables, Views, or Procedures, then I
> will see the items specified to be loaded.However, if I specify some to
> be loaded and others not to be loaded, I can get a variety of results.If
> I specify “Don’t load” for some, but “Load…” for others, I may see still
> see all three, or maybe only a subset.Appearance of objects not selected
> to be loaded appears to have to do with whether I had earlier specified
> loading for them…
>
> So, the bottom line is that I can actually see tables and views for
> everything if I specify individual Schema loading, or “Load all and
> cache all Schemas”.
>
> But,
>
> 1.There is a bug with Tables and Views not displaying with “Load all
> Schemas, cache none”.
>
> 2.There is also a bug with “Specify Schema loading and caching”, in that
> Tables, Views, and Properties may show even if they have been specified
> not to load. It appears to relate to the information still being in the
> cache, if they had been earlier specified to load.
>
> Is it sufficient to report this here, or do I need to report bugs elsewhere?
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
>
> (574)658-5208
> (574)658-8002 (FAX)
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Thursday, October 16, 2014 8:45 AM
> *To:* [hidden email]
> *Cc:* [hidden email]
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Do you mean you do not see the tables even in the schema specified in
> the alias?
>
> I can see them in TESTDAT which is the schema in the alias, but not in
> the other schemas.
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 5:10 PM
> *To:* Alex Malmyguine
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Hi Alex,
>
> Thanks for asking!  …but I had done nothing with schema.  Here is the spec:
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 4:58 PM
> *To:* [hidden email] <mailto:[hidden email]>
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Rene,
>
> Did you by any chance use this tab in the alias editor to inhibit
> loading of the schemas?
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 4:43 PM
> *To:* Alex Malmyguine
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Hello Alex,
>
>>>What was the problem back then?
>
> I expected to be able to view all objects associated with any given
> schema.  I am able to see at least the aliases, procedures, and
> sequences associated with any given schema.  But I am not able to see
> the tables for ANY schema, even when I have specified a default schema
> by the various means available – either doing it as you did, or by
> specifying the “libraries” property, or by specifying the “database
> name” property.
>
> I was also having the same problem with MS SQL Server, but if given a
> default schema, Squirrel does show me the associated tables for that schema.
>
> Here are my driver (using the jtopen 7.1 jar file) and alias definitions:
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
>
> (574)658-5208
> (574)658-8002 (FAX)
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 3:43 PM
> *To:* [hidden email] <mailto:[hidden email]>
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Rene:
>
> What was the problem back then?
>
> This is how driver is set up on my machine. As you can see I am still on
> 3.5.0 and it still works fine against i7.1
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 3:29 PM
> *To:* Alex Malmyguine
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Hello Alex,
>
> This has been quite a delay in answering your question…
>
>>>What versions of Squirrel and JT Open are you using?
>
> I was on whatever version of Squirrel were current in April (either
> possibly 3.5.0 but maybe earlier) and JTOpen I thought was version 8.2,
> but I just discovered that the folder was empty (whether it were empty
> in April I don’t know).  So it had actually been using whatever came
> with Client Access, which was from 2012.
>
> The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on my
> 64-bit Windows 7 PC.
>
> So I:
>
> ·upgraded to Squirrel 3.6
>
> ·upgraded to JTOpen 8.3
>
> ·updated my driver definition in squirrel to point to the new default
> jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)
>
> and get the same result.
>
> Then I
>
> ·updated my driver definition in squirrel to point to the new jt400.jar
> for Java 6 and higher (C:\Program Files
> (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)
>
> and still get the same result.
>
>>>I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works
> fine with iSeries 7.1 and 5.3 DB with default settings.  …You might want
> to use that as a workaround until you figured out Squirrel.
>
> I downloaded JTOpen 7.1, and put its jt400.jar at the head of the list,
> but nothing changed.
>
> Has anyone had this problem and found a resolution?
>
> Thanks,
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
>
> (574)658-5208
> (574)658-8002 (FAX)
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Friday, April 25, 2014 4:37 PM
> *To:* [hidden email] <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Rene:
>
> What versions of Squirrel and JT Open are you using?
>
> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that works
> fine with iSeries 7.1 and 5.3 DB with default settings.
>
> Using the same JTOpen driver I can connect to iSeries from Oracle SQL
> Developer too. You might want to use that as a workaround until you
> figured out Squirrel.
>
> Thank you!
>
> Alex
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Friday, April 25, 2014 3:30 PM
> *To:* 'Eric Gulatee'; 'Jim It'
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> 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:[hidden email]]
> *Sent:* Thursday, March 20, 2014 3:14 PM
> *To:* Jim It
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *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 <[hidden email]
> <mailto:[hidden email]>> 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
> [hidden email]
> <mailto:[hidden email]>
> 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.
> ************************************************************
>
> ************************************************************
> 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.
> ************************************************************
>
>
> ------------------------------------------------------------------------------
> Comprehensive Server Monitoring with Site24x7.
> Monitor 10 servers for $9/Month.
> Get alerted through email, SMS, voice calls or mobile push notifications.
> Take corrective actions from your mobile device.
> http://p.sf.net/sfu/Zoho
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

Ellary Kahan
I have a similar problem that changing to "Load all and cache all Schemas" did not fix. I am using the jTDS Microsoft SQL driver for a SQL Server database. The object tree does not show me the dbo owner at all.  A colleague does see it and he suggested I check the version of the driver. But I haven't figured out how to do that or to update it if necessary.

-----Original Message-----
From: Gerd Wagner [mailto:[hidden email]]
Sent: Sunday, October 19, 2014 1:19 PM
To: [hidden email]
Cc: [hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

Alex,

I just tried to reproduce your problem on a PostgreSQL and couldn't see your problem. Schema loading works alright there.

Unfortunately I don't have access to a DB2/AS400. Do you or anybody else know of a way I could reproduce the problem?

Sorry for the inconvenience

Gerd



Am 17.10.2014 um 16:35 schrieb René A Valencourt:

> Hi Alex,
>
>>>Do you mean you do not see the tables even in the schema specified in
> the alias?
>
> Precisely.I discovered that the reason is having specified "Load all
> Schemas, cache none".
>
> ·If I specify "Load all Schemas, cache none", then neither Tables nor
> Views can be seen, although Procedures do appear.
>
> ·If I specify "Load all and cache all Schemas", then I can see the
> Tables, Views, and Procedures.
>
> ·If I "Specify Schema loading and caching", then I can get a variety
> of results.If I specify "Load." for Tables, Views, or Procedures, then
> I will see the items specified to be loaded.However, if I specify some
> to be loaded and others not to be loaded, I can get a variety of
> results.If I specify "Don't load" for some, but "Load." for others, I
> may see still see all three, or maybe only a subset.Appearance of
> objects not selected to be loaded appears to have to do with whether I
> had earlier specified loading for them.
>
> So, the bottom line is that I can actually see tables and views for
> everything if I specify individual Schema loading, or "Load all and
> cache all Schemas".
>
> But,
>
> 1.There is a bug with Tables and Views not displaying with "Load all
> Schemas, cache none".
>
> 2.There is also a bug with "Specify Schema loading and caching", in
> that Tables, Views, and Properties may show even if they have been
> specified not to load. It appears to relate to the information still
> being in the cache, if they had been earlier specified to load.
>
> Is it sufficient to report this here, or do I need to report bugs elsewhere?
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
>
> (574)658-5208
> (574)658-8002 (FAX)
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Thursday, October 16, 2014 8:45 AM
> *To:* [hidden email]
> *Cc:* [hidden email]
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Do you mean you do not see the tables even in the schema specified in
> the alias?
>
> I can see them in TESTDAT which is the schema in the alias, but not in
> the other schemas.
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 5:10 PM
> *To:* Alex Malmyguine
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Hi Alex,
>
> Thanks for asking!  .but I had done nothing with schema.  Here is the spec:
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 4:58 PM
> *To:* [hidden email] <mailto:[hidden email]>
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Rene,
>
> Did you by any chance use this tab in the alias editor to inhibit
> loading of the schemas?
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 4:43 PM
> *To:* Alex Malmyguine
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Hello Alex,
>
>>>What was the problem back then?
>
> I expected to be able to view all objects associated with any given
> schema.  I am able to see at least the aliases, procedures, and
> sequences associated with any given schema.  But I am not able to see
> the tables for ANY schema, even when I have specified a default schema
> by the various means available - either doing it as you did, or by
> specifying the "libraries" property, or by specifying the "database
> name" property.
>
> I was also having the same problem with MS SQL Server, but if given a
> default schema, Squirrel does show me the associated tables for that schema.
>
> Here are my driver (using the jtopen 7.1 jar file) and alias definitions:
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
>
> (574)658-5208
> (574)658-8002 (FAX)
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 3:43 PM
> *To:* [hidden email] <mailto:[hidden email]>
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Rene:
>
> What was the problem back then?
>
> This is how driver is set up on my machine. As you can see I am still
> on
> 3.5.0 and it still works fine against i7.1
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 3:29 PM
> *To:* Alex Malmyguine
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Hello Alex,
>
> This has been quite a delay in answering your question.
>
>>>What versions of Squirrel and JT Open are you using?
>
> I was on whatever version of Squirrel were current in April (either
> possibly 3.5.0 but maybe earlier) and JTOpen I thought was version
> 8.2, but I just discovered that the folder was empty (whether it were
> empty in April I don't know).  So it had actually been using whatever
> came with Client Access, which was from 2012.
>
> The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on
> my 64-bit Windows 7 PC.
>
> So I:
>
> ·upgraded to Squirrel 3.6
>
> ·upgraded to JTOpen 8.3
>
> ·updated my driver definition in squirrel to point to the new default
> jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)
>
> and get the same result.
>
> Then I
>
> ·updated my driver definition in squirrel to point to the new
> jt400.jar for Java 6 and higher (C:\Program Files
> (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)
>
> and still get the same result.
>
>>>I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that
>>>works
> fine with iSeries 7.1 and 5.3 DB with default settings.  .You might
> want to use that as a workaround until you figured out Squirrel.
>
> I downloaded JTOpen 7.1, and put its jt400.jar at the head of the
> list, but nothing changed.
>
> Has anyone had this problem and found a resolution?
>
> Thanks,
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
>
> (574)658-5208
> (574)658-8002 (FAX)
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Friday, April 25, 2014 4:37 PM
> *To:* [hidden email] <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Rene:
>
> What versions of Squirrel and JT Open are you using?
>
> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that
> works fine with iSeries 7.1 and 5.3 DB with default settings.
>
> Using the same JTOpen driver I can connect to iSeries from Oracle SQL
> Developer too. You might want to use that as a workaround until you
> figured out Squirrel.
>
> Thank you!
>
> Alex
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Friday, April 25, 2014 3:30 PM
> *To:* 'Eric Gulatee'; 'Jim It'
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> 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/c
> om/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:[hidden email]]
> *Sent:* Thursday, March 20, 2014 3:14 PM
> *To:* Jim It
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *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 <[hidden email]
> <mailto:[hidden email]>> 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/c
> om/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
> [hidden email]
> <mailto:[hidden email]>
> 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.
> ************************************************************
>
> ************************************************************
> 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.
> ************************************************************
>
>
> ----------------------------------------------------------------------
> -------- Comprehensive Server Monitoring with Site24x7.
> Monitor 10 servers for $9/Month.
> Get alerted through email, SMS, voice calls or mobile push notifications.
> Take corrective actions from your mobile device.
> http://p.sf.net/sfu/Zoho
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

Alex Malmyguine
In reply to this post by Gerd Wagner-3
Greg,

I guess you were replying to Rene, as mine is working fine.

Thank you,

-----Original Message-----
From: Gerd Wagner [mailto:[hidden email]]
Sent: Sunday, October 19, 2014 2:19 PM
To: [hidden email]
Cc: Alex Malmyguine; [hidden email]; [hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

Alex,

I just tried to reproduce your problem on a PostgreSQL and couldn't see your problem. Schema loading works alright there.

Unfortunately I don't have access to a DB2/AS400. Do you or anybody else know of a way I could reproduce the problem?

Sorry for the inconvenience

Gerd



Am 17.10.2014 um 16:35 schrieb René A Valencourt:

> Hi Alex,
>
>>>Do you mean you do not see the tables even in the schema specified in
> the alias?
>
> Precisely.I discovered that the reason is having specified "Load all
> Schemas, cache none".
>
> ·If I specify "Load all Schemas, cache none", then neither Tables nor
> Views can be seen, although Procedures do appear.
>
> ·If I specify "Load all and cache all Schemas", then I can see the
> Tables, Views, and Procedures.
>
> ·If I "Specify Schema loading and caching", then I can get a variety
> of results.If I specify "Load." for Tables, Views, or Procedures, then
> I will see the items specified to be loaded.However, if I specify some
> to be loaded and others not to be loaded, I can get a variety of
> results.If I specify "Don't load" for some, but "Load." for others, I
> may see still see all three, or maybe only a subset.Appearance of
> objects not selected to be loaded appears to have to do with whether I
> had earlier specified loading for them.
>
> So, the bottom line is that I can actually see tables and views for
> everything if I specify individual Schema loading, or "Load all and
> cache all Schemas".
>
> But,
>
> 1.There is a bug with Tables and Views not displaying with "Load all
> Schemas, cache none".
>
> 2.There is also a bug with "Specify Schema loading and caching", in
> that Tables, Views, and Properties may show even if they have been
> specified not to load. It appears to relate to the information still
> being in the cache, if they had been earlier specified to load.
>
> Is it sufficient to report this here, or do I need to report bugs elsewhere?
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
>
> (574)658-5208
> (574)658-8002 (FAX)
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Thursday, October 16, 2014 8:45 AM
> *To:* [hidden email]
> *Cc:* [hidden email]
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Do you mean you do not see the tables even in the schema specified in
> the alias?
>
> I can see them in TESTDAT which is the schema in the alias, but not in
> the other schemas.
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 5:10 PM
> *To:* Alex Malmyguine
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Hi Alex,
>
> Thanks for asking!  .but I had done nothing with schema.  Here is the spec:
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 4:58 PM
> *To:* [hidden email] <mailto:[hidden email]>
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Rene,
>
> Did you by any chance use this tab in the alias editor to inhibit
> loading of the schemas?
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 4:43 PM
> *To:* Alex Malmyguine
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Hello Alex,
>
>>>What was the problem back then?
>
> I expected to be able to view all objects associated with any given
> schema.  I am able to see at least the aliases, procedures, and
> sequences associated with any given schema.  But I am not able to see
> the tables for ANY schema, even when I have specified a default schema
> by the various means available - either doing it as you did, or by
> specifying the "libraries" property, or by specifying the "database
> name" property.
>
> I was also having the same problem with MS SQL Server, but if given a
> default schema, Squirrel does show me the associated tables for that schema.
>
> Here are my driver (using the jtopen 7.1 jar file) and alias definitions:
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
>
> (574)658-5208
> (574)658-8002 (FAX)
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 3:43 PM
> *To:* [hidden email] <mailto:[hidden email]>
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Rene:
>
> What was the problem back then?
>
> This is how driver is set up on my machine. As you can see I am still
> on
> 3.5.0 and it still works fine against i7.1
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 3:29 PM
> *To:* Alex Malmyguine
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Hello Alex,
>
> This has been quite a delay in answering your question.
>
>>>What versions of Squirrel and JT Open are you using?
>
> I was on whatever version of Squirrel were current in April (either
> possibly 3.5.0 but maybe earlier) and JTOpen I thought was version
> 8.2, but I just discovered that the folder was empty (whether it were
> empty in April I don't know).  So it had actually been using whatever
> came with Client Access, which was from 2012.
>
> The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on
> my 64-bit Windows 7 PC.
>
> So I:
>
> ·upgraded to Squirrel 3.6
>
> ·upgraded to JTOpen 8.3
>
> ·updated my driver definition in squirrel to point to the new default
> jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)
>
> and get the same result.
>
> Then I
>
> ·updated my driver definition in squirrel to point to the new
> jt400.jar for Java 6 and higher (C:\Program Files
> (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)
>
> and still get the same result.
>
>>>I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that
>>>works
> fine with iSeries 7.1 and 5.3 DB with default settings.  .You might
> want to use that as a workaround until you figured out Squirrel.
>
> I downloaded JTOpen 7.1, and put its jt400.jar at the head of the
> list, but nothing changed.
>
> Has anyone had this problem and found a resolution?
>
> Thanks,
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
>
> (574)658-5208
> (574)658-8002 (FAX)
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Friday, April 25, 2014 4:37 PM
> *To:* [hidden email] <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Rene:
>
> What versions of Squirrel and JT Open are you using?
>
> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that
> works fine with iSeries 7.1 and 5.3 DB with default settings.
>
> Using the same JTOpen driver I can connect to iSeries from Oracle SQL
> Developer too. You might want to use that as a workaround until you
> figured out Squirrel.
>
> Thank you!
>
> Alex
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Friday, April 25, 2014 3:30 PM
> *To:* 'Eric Gulatee'; 'Jim It'
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> 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/c
> om/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:[hidden email]]
> *Sent:* Thursday, March 20, 2014 3:14 PM
> *To:* Jim It
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *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 <[hidden email]
> <mailto:[hidden email]>> 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/c
> om/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
> [hidden email]
> <mailto:[hidden email]>
> 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.
> ************************************************************
>
> ************************************************************
> 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.
> ************************************************************
>
>
> ----------------------------------------------------------------------
> -------- Comprehensive Server Monitoring with Site24x7.
> Monitor 10 servers for $9/Month.
> Get alerted through email, SMS, voice calls or mobile push notifications.
> Take corrective actions from your mobile device.
> http://p.sf.net/sfu/Zoho
>
>
>
> _______________________________________________
> Squirrel-sql-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

René A Valencourt
In reply to this post by René A Valencourt

Hi Jim,

 

>> … please check and make sure the instructions I provided worked as described.

>>        Tab 1 – Schemas

·         Highlight Specify Schema loading and caching radio button.

·         Press Connect database to refresh Schema table.  (populates Schema list)

·         Below Schema list, change drop down to Don't Load and click apply. (changes all schemas to not load data)

Scroll through the list of Schema's and select the libraries you want to see the object details for and change Tables, Views and Procedures to Load but don't cache.

 

Indeed, what I did to make it work was precisely what you specified (shown above) in your first steps on specifying schema loading.  That’s all that I needed.  (It remains that there are bugs in the schema-loading process, more or less as I identified in my post from Friday, October 17 at 10:35 a.m.  I will report those.)

 

As far as the other properties that you mentioned be concerned (which are described at http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_71/rzahh/javadoc/com/ibm/as400/micro/doc-files/JDBCProperties.html), I specified some variation of those as I indicated below, but I have not found that any of these be necessary to display a table list.

 

Tab2 - Driver Properties

·         Change the following properties:

o    errors = full

o    transaction isolation = none

o    translate binary = true

o    extended metadata = true

o    metadata source = 0

·         “errors=full” seems like a good thing to have for diagnostic purposes.

·          “transaction isolation=read uncommitted” is the default; I guess specifying “none” clarifies the driver’s actual behavior, since if the default value of “false” for “true autocommit” be left as is, the driver will ignore any isolation specification and use a value of “none” anyway.

·         I have been accustomed for many years to specifying “translate binary=true” for AS/400 data displayed in a PC app, so I already had that on the URL.  Typically I do not really need it, since according to the description, it affects the presentation only of binary fields, and I normally do not deal with those.

·          “extended metadata” seems like a good thing to have; have you had a beneficial experience with it, or is this basically a “best practice”?

·         I need to specify “metadata source=1” since I am at OS level v7r1.

 

>> Then in SquirrelSQL application, File -> Global Preferences -> Data Type Controls tab.

  • SQL Other (SQL type 1111) - Read contents when table is first loaded and display as string

What effect does this have?  I didn’t see any difference when looking at table contents (numeric and character fields).

 

 

Thanks!

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company

 

From: Jim It [mailto:[hidden email]]
Sent: Friday, October 17, 2014 6:20 PM
To: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

 

Rene,

 

I will check with a new alias, but please check and make sure the instructions I provided worked as described.

 

Jim


From: [hidden email]
To: [hidden email]
Subject: RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
Date: Fri, 17 Oct 2014 17:22:46 -0400

Hi Jim,

 

Thanks for the information.  I will review my driver properties.

 

Also, did you notice my last post?  The problem lay with the schema loading functionality apparently having some bugs.

 

Is this behavior that you could confirm?

 

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

IS Department

(574)658-5208
(574)658-8002 (FAX)

CTB

CTB, Inc.
A Berkshire Hathaway Company


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

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

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

René A Valencourt
In reply to this post by Gerd Wagner-3
Hello Gerd,

>> I just tried to reproduce your problem on a PostgreSQL and couldn't see
your problem. Schema loading works alright there.

I thought that I also had the problem with MS SQL Server, but am not seeing
it now...  The problem may have been that I was looking for tables under
"DBO Owner", not "DBO".

With regard to DB2 on the IBM i, the issue may relate to the fact that
database and schema are often (or usually or always?) the same layer
(related to the library name), and not separate as in SQL Server.

>> Unfortunately I don't have access to a DB2/AS400. Do you or anybody else
know of a way I could reproduce the problem?

Are you doing your development in Linux?  If the project can qualify, IBM's
program described at
http://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/stg_com_sys_p
ower-development-platform might be of use.


René A Valencourt, CCP, MCTS
Senior Programmer/Analyst
IS Department
(574)658-5208
(574)658-8002 (FAX)

CTB, Inc.
A Berkshire Hathaway Company

-----Original Message-----
From: Gerd Wagner [mailto:[hidden email]]
Sent: Sunday, October 19, 2014 2:19 PM
To: [hidden email]
Cc: 'Alex Malmyguine'; [hidden email];
[hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

Alex,

I just tried to reproduce your problem on a PostgreSQL and couldn't see your
problem. Schema loading works alright there.

Unfortunately I don't have access to a DB2/AS400. Do you or anybody else
know of a way I could reproduce the problem?

Sorry for the inconvenience

Gerd



Am 17.10.2014 um 16:35 schrieb René A Valencourt:

> Hi Alex,
>
>>>Do you mean you do not see the tables even in the schema specified in
> the alias?
>
> Precisely.I discovered that the reason is having specified "Load all
> Schemas, cache none".
>
> ·If I specify "Load all Schemas, cache none", then neither Tables nor
> Views can be seen, although Procedures do appear.
>
> ·If I specify "Load all and cache all Schemas", then I can see the
> Tables, Views, and Procedures.
>
> ·If I "Specify Schema loading and caching", then I can get a variety
> of results.If I specify "Load..." for Tables, Views, or Procedures, then
> I will see the items specified to be loaded.However, if I specify some
> to be loaded and others not to be loaded, I can get a variety of
> results.If I specify "Don't load" for some, but "Load..." for others, I
> may see still see all three, or maybe only a subset.Appearance of
> objects not selected to be loaded appears to have to do with whether I
> had earlier specified loading for them...
>
> So, the bottom line is that I can actually see tables and views for
> everything if I specify individual Schema loading, or "Load all and
> cache all Schemas".
>
> But,
>
> 1.There is a bug with Tables and Views not displaying with "Load all
> Schemas, cache none".
>
> 2.There is also a bug with "Specify Schema loading and caching", in
> that Tables, Views, and Properties may show even if they have been
> specified not to load. It appears to relate to the information still
> being in the cache, if they had been earlier specified to load.
>
> Is it sufficient to report this here, or do I need to report bugs
elsewhere?

>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
>
> (574)658-5208
> (574)658-8002 (FAX)
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Thursday, October 16, 2014 8:45 AM
> *To:* [hidden email]
> *Cc:* [hidden email]
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Do you mean you do not see the tables even in the schema specified in
> the alias?
>
> I can see them in TESTDAT which is the schema in the alias, but not in
> the other schemas.
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 5:10 PM
> *To:* Alex Malmyguine
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Hi Alex,
>
> Thanks for asking!  ...but I had done nothing with schema.  Here is the
spec:

>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 4:58 PM
> *To:* [hidden email] <mailto:[hidden email]>
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Rene,
>
> Did you by any chance use this tab in the alias editor to inhibit
> loading of the schemas?
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 4:43 PM
> *To:* Alex Malmyguine
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Hello Alex,
>
>>>What was the problem back then?
>
> I expected to be able to view all objects associated with any given
> schema.  I am able to see at least the aliases, procedures, and
> sequences associated with any given schema.  But I am not able to see
> the tables for ANY schema, even when I have specified a default schema
> by the various means available - either doing it as you did, or by
> specifying the "libraries" property, or by specifying the "database
> name" property.
>
> I was also having the same problem with MS SQL Server, but if given a
> default schema, Squirrel does show me the associated tables for that
schema.

>
> Here are my driver (using the jtopen 7.1 jar file) and alias definitions:
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
>
> (574)658-5208
> (574)658-8002 (FAX)
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 3:43 PM
> *To:* [hidden email] <mailto:[hidden email]>
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Rene:
>
> What was the problem back then?
>
> This is how driver is set up on my machine. As you can see I am still
> on
> 3.5.0 and it still works fine against i7.1
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Wednesday, October 15, 2014 3:29 PM
> *To:* Alex Malmyguine
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Hello Alex,
>
> This has been quite a delay in answering your question...
>
>>>What versions of Squirrel and JT Open are you using?
>
> I was on whatever version of Squirrel were current in April (either
> possibly 3.5.0 but maybe earlier) and JTOpen I thought was version
> 8.2, but I just discovered that the folder was empty (whether it were
> empty in April I don't know).  So it had actually been using whatever
> came with Client Access, which was from 2012.
>
> The IBM i is running OS v7r1, and I am running with Java 7.0.670.1 on
> my 64-bit Windows 7 PC.
>
> So I:
>
> ·upgraded to Squirrel 3.6
>
> ·upgraded to JTOpen 8.3
>
> ·updated my driver definition in squirrel to point to the new default
> jt400.jar (C:\Program Files (x86)\IBM\jtopen_8_3\lib\ jt400.jar)
>
> and get the same result.
>
> Then I
>
> ·updated my driver definition in squirrel to point to the new
> jt400.jar for Java 6 and higher (C:\Program Files
> (x86)\IBM\jtopen_8_3\lib\java6\jt400.jar)
>
> and still get the same result.
>
>>>I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that
>>>works
> fine with iSeries 7.1 and 5.3 DB with default settings.  ...You might
> want to use that as a workaround until you figured out Squirrel.
>
> I downloaded JTOpen 7.1, and put its jt400.jar at the head of the
> list, but nothing changed.
>
> Has anyone had this problem and found a resolution?
>
> Thanks,
>
> René A Valencourt, CCP, MCTS
> Senior Programmer/Analyst
>
> IS Department
>
> (574)658-5208
> (574)658-8002 (FAX)
> CTB
>
> CTB, Inc.
> A Berkshire Hathaway Company
>
> *From:*Alex Malmyguine [mailto:[hidden email]]
> *Sent:* Friday, April 25, 2014 4:37 PM
> *To:* [hidden email] <mailto:[hidden email]>
> *Subject:* RE: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> Rene:
>
> What versions of Squirrel and JT Open are you using?
>
> I am currently on Squirrel 3.5.0 with JT Open driver 7.1 and that
> works fine with iSeries 7.1 and 5.3 DB with default settings.
>
> Using the same JTOpen driver I can connect to iSeries from Oracle SQL
> Developer too. You might want to use that as a workaround until you
> figured out Squirrel.
>
> Thank you!
>
> Alex
>
> *From:*René A Valencourt [mailto:[hidden email]]
> *Sent:* Friday, April 25, 2014 3:30 PM
> *To:* 'Eric Gulatee'; 'Jim It'
> *Cc:* [hidden email]
> <mailto:[hidden email]>
> *Subject:* Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1
>
> 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/c
> om/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


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

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

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

Gerd Wagner-3
In reply to this post by Gerd Wagner-3
Am 20.10.2014 um 01:24 schrieb Sam Lennon:
> Gerd,
>
> You can get a free AS/400 accounts on WWW.PUB1.DE.  Sign up is very
> simple and automated.  DB2/400 is automatically included.  It is an
> older version of the operating system, but might be suitable for testing.
>

Thanks for the pointer. But I'm sorry I registered but didn't even
manage to login to the system.

Perhaps someone could send me a JDBC-Url/user/password combination
together with an URL where I could download the right JDBC driver so
that I could right away connect with SQuirreL.

Best would be if I could reproduce René's problem with that login.

Thanks

Gerd



------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

Alex Malmyguine
Gerd,

iSeries driver can be downloaded from http://jt400.sourceforge.net/

Thank you,
Alex

-----Original Message-----
From: Gerd Wagner [mailto:[hidden email]]
Sent: Tuesday, October 21, 2014 4:00 PM
To: Sam Lennon
Cc: [hidden email]; [hidden email]
Subject: Re: [Squirrel-sql-users] Issues with DB2/AS400 v 7.1

Am 20.10.2014 um 01:24 schrieb Sam Lennon:
> Gerd,
>
> You can get a free AS/400 accounts on WWW.PUB1.DE.  Sign up is very
> simple and automated.  DB2/400 is automatically included.  It is an
> older version of the operating system, but might be suitable for testing.
>

Thanks for the pointer. But I'm sorry I registered but didn't even manage to login to the system.

Perhaps someone could send me a JDBC-Url/user/password combination together with an URL where I could download the right JDBC driver so that I could right away connect with SQuirreL.

Best would be if I could reproduce René's problem with that login.

Thanks

Gerd

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issues with DB2/AS400 v 7.1

Gerd Wagner-3
In reply to this post by Gerd Wagner-3
René,

thanks to Sam's advice I was able to connect to AS400 on PUB1.DE.

I can not load schema information, too. This is due to the following error:

java.sql.SQLException: [MCH1210] Empfängerwert zu klein, um Ergebnis zu
halten.

Could you please see if you get the same error message? To see the error
please connect to AS400 and then go to
menu Windows --> View SQuirreL Logs

In case you see the same error you may use the attached little Java
program to reproduce it. (This requires a bit of java knowledge to
compile and run the program.)


The error occurs inside the JTOpen driver when SQuirreL tries to load
database schemas.

In this case you should contact the JTOpen team to fix the bug.


Gerd

------------------------------------------------------------------------------

_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

AS400Test.java (997 bytes) Download Attachment
Loading...