Re: sqlldr: setting NULL instead of rejecting record

On Feb 3, 2:42=A0am, Mathias Waack <M.Wa...@[EMAIL PROTECTED]
> wrote:
> Hi all,
>
> I'm going to im****t a table into oracle by using sqlldr. The table
contain=
s
> some cells with wrong contents, for instance number fields with text or
da=
te
> fields with invalid dates. sqlldr rejects these records. Is there an
optio=
n
> the tell sqlldr to just set wrong values to NULL intead of rejecting the
> whole record?
>
> Thanks,
>
> =A0 =A0 =A0 =A0 Mathias

There is (NULLIF) but it won't work in your case as you can't
guarantee the exact same value will appear in a given column across
multiple records.

I'd seriously suggest you fix the data, rather than try to finagle
SQL*Loader into replacing the errant values with NULLs.


David Fitzjarrell