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
