Connecting Tech Pros Worldwide Forums | Help | Site Map

MYSQL dump into DB2 OS400

Newbie
 
Join Date: Dec 2007
Posts: 5
#1: Dec 5 '07
hi all,

I am not an SQL expert but have experience with DB2 on the Iseries/AS400.
I simply want to generate an SQL database in OS400 DB2.
My idea was to create a dump of the MySQL database I have so I have a script with the create table statements etc.
If I execute this script in OS400 I get all kind of errors refering to incorrect field types, incorrect intial values etc.
Anyone has an idea of conversion programs, or something which can help me to quickly generate this database?
The goal is to run my java applications on DB2 OS400 without changing the code.

thanks.

Reply


Similar MySQL Database bytes