×
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.