Question about SKIP record option in INFILE with FIX mode
826879Dec 27 2010 — edited Jan 2 2011Hello,
I am using SQL Loader with the following format:
OPTIONS (SKIP=1, LOAD=4)
LOAD DATA
INFILE "C:\FILE.IMP" "FIX 6"
....
...
An example of an input file that works fine is:
HEADER
123456
123456
123456
TRAILER
The proces skip the first record("HEADER "), loads 4 records and skips the trailer. The issue happens when I have a file with this format:
HEADER 123456123456123456TRAILER
In this example, it skips the full file, not only the header, How can I skip the header in this example?
Thanks!
salu2...
masch...