Over the last couple years I have worked on a project in my spare time here at work. We have a good sized and rather complex database running under DB2 on an as/400. There has been intrest in publishing certain portions of this database on the internet. A web based query basically. The catch is that I need to connect to the as/400 from a linux server running apache and mine the query file via php. At one point I did have this working using DB2Connect for Linux from IBM. Maintaining the connections was a pain and the configuration was a nightmare. So since I have been playing recently with mysql I was wondering if anyone knows of a way to import an AS/400 query file from a DB2 database into mysql? If I could just schedule my as/400 to update that query file and then automate the import to mysql I wouldn't have to worry about the nasty configuration. Any help or suggestions would be greatly appreciated! Thanks!
Paul