Re: SQL*Loader NULLIF in date

From: Ralf Bender <ralf.bender_at_arcor.de>
Date: Thu, 06 Nov 2003 16:52:07 +0100
Message-ID: <3faa6da0$0$24753$9b4e6d93@newsread2.arcor-online.net>

Hi

rejecting runs right now, but i won't rejecting them. That's my problem. all other information should be inserted AND the wrong date with NULL

Alkos wrote:

> "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:52:07 CST