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



Jeff,

I do not recommend "mirroring" the database table between MySQL and Db2.  Its simply too easy for one to get out of sync with the other, causing havoc.

Instead, change your RPG programs to access the MySQL database table directly when needed rather than mirroring it.

-SK

On 7/1/2019 1:26 PM, Jeff Bianchi wrote:
Hello!

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?

Thanks!

Jeff Bianchi

Jeff.Bianchi@xxxxxxxx<mailto:Jeff.Bianchi@xxxxxxxx>| P 253.804.1034
Oak Harbor Freight Lines, Inc.
"Bringing Peace of Mind Since 1916."


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.