× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi Doug,

Am 26.08.2024 um 18:38 schrieb DEnglander--- via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx>:

Does anyone have any references as to how to set up an RPG program that
can send DB2 data to a MySQL database on a remote server?

No, I don't - and JDBC seems to be the only viable solution, if you want to replace the Java program 1-to-1.

MySQL has no DRDA connections AFAIK (Oracle has one, MS-SQL too) - that would be too easy.

Any resources anyone has to help would be great. Can this be done in
embedded SQL somehow, or is JDBC my only option?

I would try to think outside the box - maybe without complex programs, by setting up a form of "pipeline".

1st Idea: Using a ETL solution as a "middleware"

There are some open source ETL solutions available - creating a pipeline shouldn't be so hard.

2nd Idea: Exporting and importing

Use a flat file, XML or JSON to export the data you want - and setup an import "job" on the MySQL side - this could be a simple command called by CRON, which grabs the IFS file and imports it.

3rd Idea: using DB2 as backend for MySQL

You can use DB2 tables as MySQL backend on IBM i - means, your RPG program can simply INSERT the data into a regular table, that is also available as a table in MySQL on IBM i.

If you want to offload the data, setup MySQL data replication from IBM i to the non-IBM-I MySQL server.

Just some ideas - there are (probably) better ones.

HTH
Daniel

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.