AS/400 to Mysql

[vinomails]

Hi,

Is it possible to write the data from DB2 to Mysql?

Could you please explain?

[dhanuxp]

Re: AS/400 to Mysql

Hi,
MySQL Database Access from RPG :

http://systeminetwork.com/article/mysql-database-access-rpg

[BenThurley]

Re: AS/400 to Mysql

That article seems like a convoluted way to avoid writing Java. Fair enough if you don't know Java but I can guarantee that the RPG equivalent will require a lot more code, be harder to read and in some cases be quite restrictive. Each to their own I suppose!

What are the actual requirements? Is this a one off migration or is it a scheduled extract of some kind? Does the data have to be manipulated in anyway first or is it a straight copy? How much data are we talking about?

You can import delimited files into MySQL.

http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html

If it's a one off task then I might experiment with the import command. I'm sure I've seen that you can get iSeries navigator to export a CSV for a file?

If it is supposed to run with any frequency then I would probably write a JDBC/ODBC program. Whether that program is RPG or Java or something else is personal taste. You could even write a PHP script to do it if that floats your boat.