Re: SQLLOADER vs. NULLIF

In article <6f6o9j$1tr$1_at_nnrp1.dejanews.com>,

This probably won't help, but just in case it does I'll post it anyway.

I'm converting xBase data into Oracle via SQL*Loader. For my nullable date fields I use the following

first1 date 'YYYYMMDD' NULLIF(first1 = blanks)

Of course xBase actually stores the blanks. But it shouldn't take too long to try

  jeff.w.mcclure_at_ameritech.com wrote:
>
> Folks,
>
> I am attempting to transfer data from an Informix instance into an Oracle8
> (8.0.3.0.0) instance via SQLLOADER. My problem lies in transferring a
> date/time field. The output from Informix is in the format "YYYY-MM-DD
> HH:MI:SS" (there is a space between the date and time). My control file line
> looks like this:
>
> first1 date 'YYYY-MM-DD HH:MI:SS' NULLIF(first1 = X'4e554c4c')
>
> The error I am recieving is:
>
> Record 1: Rejected - Error on table ALERTLOG, column ACKNOWLEDGE.
> ORA-01849: hour must be between 1 and 12
>
> The date field (from Informix) may contain NULL. Where the field contains a
> date and time, it transfers correctly. How can I get this data to transfer
> when it includes a NULL date/time field (populating the Oracle8 instance with
> NULL in the date field)?
>
> Thanks,
>
> Jeff McClure
> Specialist DB Analyst
> Ameritech New Media
> Jeff.W.McClure_at_Ameritech.com
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 24 1998 - 00:00:00 CST