codemonkey156
asked on
export using .del files problem
Hi,
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?
Thanks
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?
Thanks
Hello codemonkey156,
Are you sure that they wrap? I'm not aware that export sets an arbitrary limit on line lengths. DB2 should warn if a column is wider than 255 characters.
Perhaps the string data contains your delimiter. That's a pretty common hitch.
Kent
Are you sure that they wrap? I'm not aware that export sets an arbitrary limit on line lengths. DB2 should warn if a column is wider than 255 characters.
Perhaps the string data contains your delimiter. That's a pretty common hitch.
Kent
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your comments. I will try on Tuesday and get back to you.
ASKER
Thanks ghp7000. The modifier did the trick!
can you try that and check if it works ?
plus, can you notice something different in those 54 rows (maybe they have lf cr in the varchar fields), or do they seem like all the other rows ?