Home » RDBMS Server » Server Utilities » SQL Loader + report ++headline+footnote+logical record
SQL Loader + report ++headline+footnote+logical record [message #368342] Wed, 22 November 2000 03:56
Zsolt Gaspar
Messages: 1
Registered: November 2000
Junior Member
"SQL*Plus: Release

The report looks like this:

two lines make a headline, the first line has an 'ACCOUNT'
string in the front
records have a '/' character at 88th position
one line makes a footnote there is a ':' character at 52nd position

A report sample:

' ACCOUNT' headline1

(And there are pageheaders and blank lines+reportheader in it.)

records in the table should look like this:

headline1 headline2 record1 footnote
headline1 headline2 record2 footnote
headline1 headline2 ....... footnote
headline1 headline2 recordn footnote

I think it is impossible to import it with SQLLoader.
(I could not even substract the headline(headline1+headline2).
If use continueif this (1:8)=' ACCOUNT', then it concatenates two lines, but
i also have filter it and with when (1:8)=' ACCOUNT' because of headline2 ('
') the whole logical record is rejected.)
What do you think about it?
If you can solve it please send me an email.


Previous Topic: imp80
Next Topic: Re: Line Breaks while uploading the data using SQL*Loader
Goto Forum:

Current Time: Sun Dec 05 08:48:25 CST 2021