export using .del files problem
Posted on 2007-03-29
I'm using the following command to export data from DB2 on a windows server:
export to <table>.del of del select * from DB2ADMIN.<table>
One of the tables has a problem as the .del file generated has 54 records that wrap to the next line. When I perform a load onto DB2 on UNIX using:
load from <table>.del of del modified by codepage=819 replace into <table>
The wrapped 54 rows do not load.
The table has 35,200 rows and each record is up to 2300 bytes long (including VARCHAR 2000 and VARCHAR 50).
Is there a parameter or technique to stop the bad formatting in my .del file?