473,247 Members | 2,862 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,247 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 2362
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: TP | last post by:
Does Db2 version 8 require a 64 bit machine or will it work on os390/zos non-64 bit machines?
1
by: TP | last post by:
Hi, I am using db2 connect version 7.2 on xp to connect to os390 db2 7.1.1. When I run the sample db2 java program to determine what jdbc version I am on it tells me version 1.2 I was...
4
by: TP | last post by:
Please let me know. thanks. TP
2
by: Pete H | last post by:
Hi All; On DB2 (OS390) v7.1 is there any reason to avoid the use of varchar() datatype for columns less than 50 bytes in length? Current DBA standard is to only use varchar when length of...
0
by: Deepak | last post by:
Hi, Recently while using db2 client 8.1 i faced the problem to use ROW_NUMBER functionality on OS390 platform. Is this function still not available on ZOS ??
1
by: MLH | last post by:
I'm running XP. Is it required that a given ODBC driver be selected or set somehow as a default driver? Look at this... Here's the error: Error: ODBC call failed... Datasource not found and no...
3
by: Laurence | last post by:
Hi there, Does somebody know the efficent way to connect DB2/400? Through iSeries Access ODBC/OLEDB driver or DB2 Connect? Which will more fast and efficent? In addition, does DB2 Connect use...
16
by: ML | last post by:
I have recently been looking on dice.com (and other sites) and noticed a striking difference in the number of listings for DB2 DBAs for the OS390 platform. Most of the listings are AIX. Anyone...
0
by: jpmad4it | last post by:
Hi there I know that I can connect to an IDMS DB using JDBC type 4 drivers, but I have a few questions: Is this the process: - Set up the IDMS system to allow JDBC connections - defining...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...

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.