Re: SQL-Loader: how to handle more data fields than columns ?

[Quoted] You may be able to add a record size parameter to the INFILE statement in your control file. Documentation says this is specific to the operating system. I found two examples:
INFILE 'my.file' RECSIZE 123
INFILE 'my.file' "fix 123"

I did not find any examples or error messages referring to input records that exceed the specified record size. Also, if your records are variable-length, you obviously cannot use this approach.

[Quoted] If this fails, could you load a dummy table from beyond the end of the normal record? Or would that cause the "good" stuff to be rejected? (See Case 5 in the SQL*Loader docs.) Then check the dummy table after the load. It should be empty, but if it isn't your test case would presumably have occurred.

[Quoted] "Juergen Hartelt" <juergen.hartelt_at_t-mobil.de> wrote in message news:38F5FB37.3DA64EF0_at_t-mobil.de...
> Hi all,
>
> I asked this before without getting an answer. since the matter is still
> a problem here, I ask it again.
>
> I load ASCII files with delimited data fields. one of the test cases
> was to load a "user corrupted" data file, wherein two lines of data
> have been joined.
>
> SQL-Loader just ignores the extra data on that line and does not signal
> any error.
>
> can I change this behaviour somwhow? I
>
> thanks for your time (and answer?).
>
> Jürgen
>
>
>
Received on Fri Apr 14 2000 - 17:58:03 CEST