Hi

I exported data from a table in database to a comma seperated flat txt
file. Each row in the flat file are seperated by a new line character.
When I load this flat file back into the table using the db2 loader,
this new line character is being considered as the part of the last
column by db2 loader.

I am using following commands to export and load data:
--> export to C:\attribute.txt of del select * from my_table
-->load client from C:\attribute.txt of del insert into my_table


Is there some way that I can prevent the db2 loader from considering
the new line character as part of last column in each row?

Thanks
Amitabh