|
The reason I asked was because we are looking at some ERP solutions that run on three different databases that might move
our DB2/400 ERP to Informix (DRDA compliant) or MS SQL (not DRDA compliant). We have lots of in house developed apps that
currently access our DB2/400 ERP. If we went the Informix route
we could simply use DRDA to make the Informix database look like
its local (CRTDDMF pointing to the Informix database). No code
changes needed. The JDBC route would work (we have done this from
some java apps already) but would require some major changes in
the applications to move from an "F" spec file definition with
CHAIN/READ/SETLL etc code to calls to a service program or
embedded SQL. Doable, and maybe a better long term solution, but
a much more costly, time-consuming conversion would be needed. We
are considering asking the vendors to use a DRDA compliant
database or provide as part of their package/support a 3rd party
DRDA gateway that would make MS SQL accessible via DRDA
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.