SQL*Load: Inserting NEWLINE's

From: Jeff Fields <jhf_at_dbrus.Unify.Com>
Date: 15 Jan 93 16:45:30 GMT
Message-ID: <lfrasc1_at_Unify.Com>

Does anyone out there know how to insert NEWLINE's into long data columns using sqlload?

The problem I am having is this:

I am loading data into a table with sqlload that contains a long column. I am using a control file and a ASCII data file. The data file contains multiple physical records, or lines of ASCII text formatted in such a way that each logical record inserted into the database spans multiple physical records. I am using CONTINUEIF in the control file to accomplish this. The data is loaded almost correctly, except that the NEWLINE's that I wish to insert into the long column aren't getting inserted. For example here is a logical record in the data file: <START OF LOGICAL RECORD>

     5|


%%	This text should be loaded into a long column with a newline here>

%%	and a newline here>


%%	and a newline here>

<END OF LOGICAL RECORD>

The '%%' at the beginning of each line is the CONTINUEF string. All the data is inserted into the long data column, except for the trailing newlines, so that when you retrieve the record and display the value of the long column it comes out like this:

        This text should be loaded into a long column with a newline here> and a newline here> and a newline here> where I expected this:

	This text should be loaded into a long column with a newline here>
	and a newline here>
	and a newline here>

Am I overlooking something in the sqlload documentation that would achieve the desired result? Is it possible to achieve what I want with sqlload?

-Jeff

Jeffery H. Fields               email: jhf_at_dbrus.unify.com
Unify Corporation               phone: 916 928-6286

Sacramento, California Received on Fri Jan 15 1993 - 17:45:30 CET