All Forums Tools
surmik 2 posts Joined 12/05
03 Jan 2006
FastLoad vs NL Character

I have a text file with records I want to import into Teradata with FastLoad. Columns are separated with a "|" character. There is a problem with a 'Comments' column containing rows with a new line character. For FastLoad new line is a new record so it gives an error of insufficient number of columns.Any ideas how I can deal woth new line characters without changing the text file?Thanks,Marek

hh 21 posts Joined 06/04
24 Jan 2006

maybe define that newline character but not loading it? Hope that helps..

You must sign in to leave a comment.