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 8.0.6.0.0

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
headline2
record1
record2
..
recordn
footnote

(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.

Thanks,

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


Current Time: Fri Mar 29 01:12:08 CDT 2024