Re: Feature/Driver combinations in V9 + Data Studio

I see what you mean now, Jon. I think that using the "IBM Toolbox for Java" (aka JTOpen and jt400.jar) for your IBM i connections is probably discouraged and using the "IBM Data Server Driver for JDBC and SQLJ (JDBC 4.0)" drivers will enable those features that are unavailable from the toolbox. I definitely have the SQL Outline View and Stored Proc debugging/editing with the JDBC 4.0 driver. (I don't have pureQuery or the federation server software, and don't use the other restricted features, so can't tell you about those.)


-Paul.


-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: 26 June 2013 16:54
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Feature/Driver combinations in V9 + Data Studio

Check out this page Paul http://www-01.ibm.com/support/docview.wss?uid=swg27038175 and select the DB2 for i tab. On the RHS it identifies the release that various features are supported on. You will see that a significant number are marked with X1. If you look at the bottom of the page and fine the X1 reference you will see:

"X1 - Not supported when a connection is created by using only the IBM Toolbox for Java driver" - but no link, no explanation, nothing. That's what I was talking about.


On 2013-06-26, at 5:22 AM, Paul Bailey <PaulBailey@xxxxxxxxxx> wrote:

If we can talk above the sound of Eric's crickets...

Jon, have you got any examples of which features were unavailable with the default driver? I'm not quite sure what you mean.

I know that there are various "jt400" JDBC drivers and they sometimes have slightly different SQL features (especially between versions), so perhaps the default drivers with Data Studio have limited features and you can just download the "best" jt400.jar and use that? (Try http://jt400.sourceforge.net/ and/or http://pic.dhe.ibm.com/infocenter/iseries/v6r1m0/index.jsp?topic=/rzahh/whatsnew.htm for more details. Sorry I can't provide direct download links.) Obviously this is just for connecting to an IBM i, and you'll need other drivers for other database types.


-Paul.


-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of DeLong, Eric
Sent: 25 June 2013 20:20
To: Rational Developer for IBM i / Websphere Development Studio Client
for System i & iSeries
Subject: Re: [WDSCI-L] Feature/Driver combinations in V9 + Data Studio

I have a sound board application on my tablet that plays a nice
"crickets chirping" sound, which seems appropriate for this topic
which obviously nobody knows anything about... Sorry I have nothing
of value to contribute, but at least you got a response! ;-D

-Eric DeLong

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Tuesday, June 25, 2013 2:07 PM
To: Wdsci-L
Subject: [WDSCI-L] Feature/Driver combinations in V9 + Data Studio

Didn't get a response on this before so I thought I;d try again:

In the list of supported features of Data Studio for IBM i there are a significant number that are marked as not being available using the default driver. Sadly it doesn't tell you which drivers will support those functions or how to obtain them. Are they chargeable features or ???


Jon Paris

www.partner400.com
www.SystemiDeveloper.com




--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post a
message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post a
message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/wdsci-l.

Scanned by MailDefender - managed email security from intY -
www.maildefender.net

Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.

We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.

Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham, B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF is authorised and regulated by the Financial Services Authority.
--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post a
message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/wdsci-l.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com




--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/wdsci-l.

Scanned by MailDefender - managed email security from intY - www.maildefender.net

Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.

We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.

Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham, B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF is authorised and regulated by the Financial Services Authority.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.