I had a similar case when I needed to export SQL Server database to DB2. I first generated the DDL commands, and executed them on DB2, then I exported each table data into a text file, and then imported that file in DB2. I'm not sure if there is an easier way, but my trial did work.
posted 14 years ago
Thanks for your reply. I've decided to use a software that will convert the data from Access to DB2. It'll be much easier that way.