Home » RDBMS Server » Server Utilities » SQL Loader - new line character
SQL Loader - new line character [message #69031] Wed, 17 October 2001 11:01 Go to next message
Chayan
Messages: 2
Registered: October 2001
Junior Member
The legacy email history data is imported into a text file. The body of the email has new line characters. But, when I am using SQL Loader, it is recognizing each new line character as a new record and splitting up each record.

How I can separate the records and keep the email body intact? Is there any special syntax that I can use to specify new line character in SQL Loader? How can I override the default end of record, which is the new line character?

Thanks!

----------------------------------------------------------------------
Re: SQL Loader - new line character [message #69063 is a reply to message #69031] Tue, 23 October 2001 08:12 Go to previous message
Naren
Messages: 8
Registered: October 2001
Junior Member
Hi Chayan,
I just saw your posting. May be you have figured out a way of doing it. If not, then here it is.

By default, it uses newline as the terminator string. If you want to override it, specify a hex-string as your terminator for the record. For example

control file:

load data
infile 'filename.dat' "str X'7c0a'"

The above hex-string X'7c0a' translates to '|' followed by 'n'

So, find out the hex-string for whatever terminator you want to use.

Hope it helps!

naren

----------------------------------------------------------------------
Previous Topic: Re: problem in loading data from data file using SQL *LOADER
Next Topic: sql loader issue
Goto Forum:
  


Current Time: Fri Mar 29 02:22:51 CDT 2024