MySQL Forums
Forum List  »  IBM DB2

AS/400 DB2 data transfer to MySQL
Posted by: jimmy berry
Date: June 19, 2007 09:22AM

I am new to MySQL and trying to do what I consider to be to a easy task. Basically, I want to transfer Item Number and shelf life days from the AS/400 to a file in MySQL everynight. I am having an issue on how to do this. In MSSQL, I was able to use DTS (Data Transfer Service) to accomplish this task rather easy because I could schedule the job. Below are the details of what I am trying to accomplish.

1. Transfer the Item number and shelf life days from DB2 to MYSQL server. Call the MySQL table ItemShelf
2. Run a Stored procedure that will update the shelf life days in MySQL table Items using ItemShelf.

What is the best way to accomplish this and automate it?

Thanks for any help you can provide.

Jimmy

Options: ReplyQuote


Subject
Views
Written By
Posted
AS/400 DB2 data transfer to MySQL
12516
June 19, 2007 09:22AM
7422
September 07, 2007 11:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.