Re: JDBCR4 best use for BLOB/CLOB

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

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