Re: SQL*Loader NULLIF in date

From: Alkos <azerty_at_nospam.org>
Date: Thu, 6 Nov 2003 16:28:11 +0100
Message-ID: <bodpac$3fo3@news.rd.francetelecom.fr>

"Ralf Bender" <ralf.bender_at_arcor.de> a écrit dans le message news: 3faa588c$0$24759$9b4e6d93_at_newsread2.arcor-online.net...
> Hello
>
> i got a stupid problem here. i've got to load thousands of data with
> sql*loader. normally no problem. but there are a few records which i
> don't know to handle with.
>
> the last field is my problem:
>
> 30106053;1WES02;4082646;..
> 30109055;1WES03;4085598;..
> 30121980;1WES05;4098442;..
>
> normally it's a date here. now i want do write as NULL in db. but how?
>
> NULLIF date=blanks, should not be right, because it is not blank
>
> thx for helping
> ralf
>

Hello,

You can specify the datatype DATE and an optional format en the FIELDS clause
of the control. I think it'll work and all non-matching rows will be rejected (in the bad file)

Cheers,
Alkos Received on Thu Nov 06 2003 - 09:28:11 CST