title: Mysql connecting to iseries
body: <p>Any easy way to get mysql server to query from an iseries (as/400 db2)? I have the odbc installed so I can query and export the data manually to my desktop and then import it to mysql. </p>
  
  <p>The problem is the as400 database is so huge the performance is poor. I need to run a query every 1/2 hour or so on mysql to pull the new updated information on the iseries database.</p>
  
  <p>Basically how do you use odbc on the mysql server to query from the iseries odbc?</p>