data migration - sql loader issue

[charmingcann]

I need some help with the following issues in sql*loader :
(1) How can I eliminate the job headers and job tails (unwanted lines) in the file?
(2) How to do the import where each line represents column in the interim table?

Here is my sample data :

!job header1 (1st line)
!job header2 (2nd line)
101 -- trans type (3rd Line)
89900 - part number (4th line)
10 -- quantity (5th line)
YES -- if to continue with the next record (6th line)
E -- (7th line)
102 - (8th line) - next record
9000 - (9th line)
10 - (10th line)
YES - if to continue with the next record (6th line)
E - job tail 1
E - job tail 2
E - job tail 3
!END OF JOB

Thanks .

 

[ADV27]

before generating spool file, please change the page size setting from the environment settings menu.

Just increase values so that you get one line per record and increase the page length as well.

Then browse the text file created by the SPOOL command.