The decision to go off the iSeries was made way above my paygrade for reasons that don't need to be fully explained to those at my paygrade -- in other words, I didn't get a vote.
So, that said: does anyone have any ideas on how to accomplish what I want to do?
Here's the text of my original email:
" I'm in over my head a bit. I think Scott Klement's JDBCR4 service program is what I need to complete my task - but I'm open to suggestions.
My task: copy the content of a table on the iSeries to a table on a MySQL server - the iSeries table has both BLOB and CLOB fields defined in it and I want these fields to copy over to the MySQL table intact.
My goal is to have a MySQL table that is a mirror of the iSeries table content for use by web and server applications that use the MySQL database rather than the iSeries database. Will I run into ASCII/EBCIDIC issues? How do I overcome them?
After following Scott's instructions, I have an RPGLE program that can connect to, and use, the MySQL schema and table - I'm just unsure of the best way to copy the iSeries content to it. For instance, the BLOB and CLOB fields are defined to contain up to 2GB so that effectively removes my ability to use an RPGLE host variable for these fields because of the size limitation, doesn't it?
I sure would appreciate some thoughts. Has anyone used this service program to copy BLOBs and/or CLOBs to MySQL?"
date: Mon, 1 Jul 2019 16:29:20 -0400
from: John Yeung <gallium.arsenide@xxxxxxxxx>
subject: Re: JDBCR4 best use for BLOB/CLOB
On Mon, Jul 1, 2019 at 4:13 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:
I would also query the need for MySQL at all. Why can't whatever tooling is accessing the MySQL just hit the Db2 tables directly?
As an application developer, that is the architecture I would prefer (just go to Db2 directly); but at least where I work, we are paranoid about allowing outside access to our i. So we have our Web stuff live completely outside of the firewall which surrounds the i and our local network. Some of our data is duplicated on the Web server; some other data is available through a convoluted relay involving an intermediary server living in the DMZ.
John Y.
midrange.com
