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.

[Larry]

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.

[Mark Yudkin]

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.

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

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