Kinds of drivers for connecting to DB2 on os390

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • TP
    #1

    Kinds of drivers for connecting to DB2 on os390

    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.
    Tags: None
    • Larry
      #2
      Re: Kinds of drivers for connecting to DB2 on os390

      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:
      [color=blue]
      > 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.[/color]

        Comment

        • Mark Yudkin
          #3
          Re: Kinds of drivers for connecting to DB2 on os390

          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" <tpass001@hotma il.com> wrote in message
          news:5947ff63.0 401291400.252d4 cb0@posting.goo gle.com...[color=blue]
          > 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.[/color]


            Comment

            • DB2
              #4
              Re: Kinds of drivers for connecting to DB2 on os390

              Yes there are other third party drivers such as StarSQL
              (www.starquest.com) or HiT, among others.

              Bob

              tpass001@hotmai l.com (TP) wrote in message news:<5947ff63. 0401291400.252d 4cb0@posting.go ogle.com>...[color=blue]
              > 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.[/color]

                Comment

                • TP
                  #5
                  Re: Kinds of drivers for connecting to DB2 on os390

                  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 <larry@nospam.n et> wrote in message news:<jEhSb.407 89$6J6.7938136@ news4.srv.hcvln y.cv.net>...[color=blue]
                  > 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:
                  >[color=green]
                  > > 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.[/color][/color]

                    Comment

                    Previous template Next
                    Working...