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