Re: JDBCR4 best use for BLOB/CLOB

It may not meet your needs but you could use the IBM Db2 Storage engine for MySQL to allow the MySQL table to actually be the exact same IBM i Db2 data.

It takes some fiddling to set up but it would be one approach. No problems with keeping updates in sync either.

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?


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Jul 1, 2019, at 2:26 PM, Jeff Bianchi <Jeff.Bianchi@xxxxxxxx> 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."

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com