By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,611 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,611 IT Pros & Developers. It's quick & easy.

db2 loader problem

P: n/a

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?


Oct 10 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.