Doug,
Take a good look at this:
https://www.mcpressonline.com/programming-other/java/german-programmer-devises-novel-way-to-access-any-remote-db-from-ibm-i
See also the attached presentations. You can also do a google search for
"dieter bender appserver4rpg" (without quotes)
What is really nice about Dieter's solution is, once you have this set up and running on a system, you can easily use "embedded SQL" from RPG or any other language that supports embedded SQL, directly on the IBM i, to "talk to" remote databases on virtually any database that supports JDBC.
And you can run INSERT and UPDATE and DELETE statements, too, not just SELECT ... INTO ... etc.
Let me know if you have any questions.
Dieter can even help you to set it up and get it working. ;-)
And, once it is installed and running, no Java knowledge is required to use it; you can use SQL directly from STRSQL, or RUNSQLSTM, or RUNSQL, and of course embedded SQL, static or dynamic in your programs. :-)
Hope that helps,
Mark S. Waterbury
On Monday, August 26, 2024 at 12:37:51 PM EDT, DEnglander--- via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:
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?
I seem to be able to connect to the remote server in a test RPG program
and run a small set of simple commands [get a list of files in its DB],
but an not sure how to use the LOAD DATA LOCAL INFILE MySQL command to load the DB2 rows. This test RPG program connection uses the JDBCR4 service program from Scott Klement.
There is an existing, buggy Java program the normally does this, but it is
having problems lately and I was hoping I could rewrite the daily job in
RPG. The Java program appears to get a list of column names for the file
to send and concatenate them together somehow into a predetermined format. It then uses a Java command as
MYSQL_STMT.setLocalInfileInputStream
that sets the input stream to something set via IOUtils.toInputStream(), which appears to take the list of column names as input.
I have extremely limited Java experience.
Any resources anyone has to help would be great. Can this be done in
embedded SQL somehow, or is JDBC my only option? The original Java program is from 2015, and I assume there have been many improvements to the system since then that may allow a better way to do this.
Thank you,
Doug
midrange.com
