A journal written by orang kampung.. There is a place that you will never forget.... kampung


Friday, March 28, 2008

Problem with del format for importing

When I run export from DB2 database into DEL format file, and then import to another DB2 database, I found out that if in a field there is line-feed character, or '\n', or something similar, then it will generate an error message due to some of the field were truncated due to the above character.

Until now, I have not found any solid ways as few of the solutions mention about IXF format which have some problems too... Anyone found any solution or ways to export a large table into another DB2 database?

No comments: