MySQL & AS400

[drgroove]

Hello,

We have need to connect an AS400 database w/ our MySQL database.

any thoughts as to the best way to do this?

right now, we're planning on having the AS400 drop its db into a .txt file onto our webserver; a Cron job would then execute a PHP page, which will parse the .txt file and import it into MySQL.

However... is there a better way? more efficient? more direct?

any ideas are appreciated!!! thanks!

[stolzyboy]

i had to do the very same thing with a job i was working on, the only thing that was different than a regular cron job, was that to do a php page you have to have the lynx browser installed to call up the php page and run it, other than that it worked flawlessly, good luck

[cwilhoit]

Get publication SG24-6551-00 from IBM. It is a Redbook. Look at page 19 and you will find a killer example on how to QUICKLY get the data from your AS400 via unixODBC and a C program and create a tab delimited file. Then you import into your MySQL database. I run this as cron jobs and it works very well.

The PHP code took too long and timed out (I was getting > 250,000 records).