Broadcom supply drivers for access to Datacom/DB.
ODBC is a supported protocol, it has been for 30 years! JDBC came later and
is supported. It requires Datacom server which is similar to IBM DB2
Connect and DRDA.
I don't think there is a generic talk to everything, you have to configure
for each data source.
We used ODBC connections from MS Excel to Datacom as a data source back in
the 90's.
1. Create/edit the SVDBSPR job stream which initiates the Mainframe
Server.
2. Define a
Datacom Server
ODBC data source on the Windows workstation or web server.
3. Select the
Data Source
tab on the
Datacom/DB
ODBC
set-up panel and click the
Test
button.
4. Supply a user ID and password if required by the Mainframe Server
startup parameters and click
Connect
.
On Sun, Aug 25, 2024 at 7:19 PM Attila Fogarasi <
[email protected]> wrote:
> ODBC connects to the local SQL implementation, for z/OS there is only Db2
> for z/OS. In theory the C/C++ application program with ODBC calls coded
> could run unmodified on Linux or Windows with the same ODBC calls, after
> recompilation (of course this kind of platform independence is very hard to
> achieve). The ODBC goes to the local SQL implementation, such as SQL
> Server. The communication layer for Db2 on z/OS is DDF or DRDA and this is
> unrelated to ODBC but the ODBC requests can flow on it (just like they flow
> on TCP/IP). This is standard part of Db2 so nothing more to install,
> however there are add-on products to enrich the solution. The
> Linux/Windows end typically has both DDF and DRDA software already
> installed but Microsoft sells HIS (host integration server). From an
> application standpoint, there are superior solutions to using ODBC, which
> is now a very old, legacy and almost obsolete solution. For db2 remote
> data, using 3 part database name is what applications generally use, for
> example.
>
> On Sun, Aug 25, 2024 at 7:00 PM Binyamin Dissen <
> [email protected]> wrote:
>
> > ODBC is only good for connecting to DB2?
> >
> > Lets say that I want to connect to an arbitrary RDMS on an arbitrary
> > platform,
> > such as MYSQL or M%crosoft database on Windows from MVS.
> >
> > Does JDBC work out of the box? Is software required on MVS or Windows to
> > allow the connection?
> >
> >
> >
> > On Fri, 23 Aug 2024 00:45:06 +1000 Attila Fogarasi
> > <[email protected]> wrote:
> >
> > :>ODBC is a programming API for application programs written in C/C++ to
> > use
> > :>as an alternative to SQL. It isn't a connection protocol to a remote
> > :>database server. That connection can be a variety of ways, such as
> DRDA
> > or
> > :>Db2 Connect (that is a gateway) ... it all depends upon the specific
> > remote
> > :>system you want to use. JDBC is often more convenient as it is a
> > :>newer/more powerful protocol than ODBC (ODBC is over 30 years old now).
> > :>It's a bit unusual to run C/C++ application in z/OS to access non-z/OS
> > SQL
> > :>databases using ODBC, depending upon UOW and 2 phase commit
> requirements
> > :>there can be better solutions than ODBC. Db2 z/OS does have some
> special
> > :>connectivity to remote Db2 systems including LUW with/without ODBC, a
> bit
> > :>easier than to non-Db2 Unix or WIndows systems.
> > :>
> > :>On Wed, Aug 21, 2024 at 1:12?AM Binyamin Dissen <
> > :>[email protected]> wrote:
> > :>
> > :>> It would seem that this would be controlled by the DSNAOINI (based on
> > the
> > :>> DSN8OIVP).
> > :>>
> > :>> It is not clear to me if (1) how to specify the remote non-DB2
> > connection
> > :>> and
> > :>> (2) if special software is required. For example, while I can find
> > MYSQL
> > :>> ODBC
> > :>> for various platforms, I do not see a ZOS version. Are MVS drivers
> > :>> required to
> > :>> be installed for each database type?
> > :>>
> > :>> --
> > :>> Binyamin Dissen <[email protected]>
> > :>> http://www.dissensoftware.com
> > :>>
> > :>> Director, Dissen Software, Bar & Grill - Israel
> > :>>
> > :>>
> ----------------------------------------------------------------------
> > :>> For IBM-MAIN subscribe / signoff / archive access instructions,
> > :>> send email to [email protected] with the message: INFO
> IBM-MAIN
> > :>>
> > :>
> > :>----------------------------------------------------------------------
> > :>For IBM-MAIN subscribe / signoff / archive access instructions,
> > :>send email to [email protected] with the message: INFO IBM-MAIN
> >
> > --
> > Binyamin Dissen <[email protected]>
> > http://www.dissensoftware.com
> >
> > Director, Dissen Software, Bar & Grill - Israel
> >
> > ----------------------------------------------------------------------
> > For IBM-MAIN subscribe / signoff / archive access instructions,
> > send email to [email protected] with the message: INFO IBM-MAIN
> >
>
> ----------------------------------------------------------------------
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to [email protected] with the message: INFO IBM-MAIN
>
--
Wayne V. Bickerdike
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
