471,580 Members | 1,614 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,580 software developers and data experts.

Kinds of drivers for connecting to DB2 on os390

TP
Hi,

This is probably my 7th post of the day. not spamming, just want to
get the questions out, so that I can find the answers and post them
back or some good soul can help me out.

Right now I am using DB2 connect version 7.2 to connect to db2 version
7.1.1 on os390/zos. Could I use a third party driver to do this? What
would you recommend and is connecting to db2 on the mainframe a lot
different than connecting to db2 on the pc?
\
Thanks.

TP.
Nov 12 '05 #1
4 2260
Why do you want a different driver?

Connecting to DB2 on the mainframe uses the same connect statement as
DB2 on pc. They are very similar. The difference lies in the way that
the connectivity is set up beforehand (which boils down to either using
the CA a bit differently or using different catalog commands).

Larry Edelstein

TP wrote:
Hi,

This is probably my 7th post of the day. not spamming, just want to
get the questions out, so that I can find the answers and post them
back or some good soul can help me out.

Right now I am using DB2 connect version 7.2 to connect to db2 version
7.1.1 on os390/zos. Could I use a third party driver to do this? What
would you recommend and is connecting to db2 on the mainframe a lot
different than connecting to db2 on the pc?
\
Thanks.

TP.


Nov 12 '05 #2
The answer to your first question is "yes" (but I don't recommend any). I
would recommend your using DB2 Connect, as you are already doing. As you're
already have a solution, you should already know the answer to your final
question.

"TP" <tp******@hotmail.com> wrote in message
news:59**************************@posting.google.c om...
Hi,

This is probably my 7th post of the day. not spamming, just want to
get the questions out, so that I can find the answers and post them
back or some good soul can help me out.

Right now I am using DB2 connect version 7.2 to connect to db2 version
7.1.1 on os390/zos. Could I use a third party driver to do this? What
would you recommend and is connecting to db2 on the mainframe a lot
different than connecting to db2 on the pc?
\
Thanks.

TP.

Nov 12 '05 #3
DB2
Yes there are other third party drivers such as StarSQL
(www.starquest.com) or HiT, among others.

Bob

tp******@hotmail.com (TP) wrote in message news:<59**************************@posting.google. com>...
Hi,

This is probably my 7th post of the day. not spamming, just want to
get the questions out, so that I can find the answers and post them
back or some good soul can help me out.

Right now I am using DB2 connect version 7.2 to connect to db2 version
7.1.1 on os390/zos. Could I use a third party driver to do this? What
would you recommend and is connecting to db2 on the mainframe a lot
different than connecting to db2 on the pc?
\
Thanks.

TP.

Nov 12 '05 #4
TP
Right now when I run the jdbc sample java program shipped with
db2connect to determine the version of jdbc that I am using, it tells
me 1.2 and scrollable cursors are not implemented until 2.0.

I guess then the question is "how do I get the latest driver for db2
jdbc"

Thanks Larry

Larry <la***@nospam.net> wrote in message news:<jE*********************@news4.srv.hcvlny.cv. net>...
Why do you want a different driver?

Connecting to DB2 on the mainframe uses the same connect statement as
DB2 on pc. They are very similar. The difference lies in the way that
the connectivity is set up beforehand (which boils down to either using
the CA a bit differently or using different catalog commands).

Larry Edelstein

TP wrote:
Hi,

This is probably my 7th post of the day. not spamming, just want to
get the questions out, so that I can find the answers and post them
back or some good soul can help me out.

Right now I am using DB2 connect version 7.2 to connect to db2 version
7.1.1 on os390/zos. Could I use a third party driver to do this? What
would you recommend and is connecting to db2 on the mainframe a lot
different than connecting to db2 on the pc?
\
Thanks.

TP.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by TP | last post: by
2 posts views Thread by Pete H | last post: by
reply views Thread by Deepak | last post: by
16 posts views Thread by ML | last post: by
reply views Thread by Vinnie | last post: by
1 post views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.