Re: Help: SQLLDR and NULL values

From: <michael_bialik_at_my-deja.com>
Date: Wed, 10 Nov 1999 21:54:13 GMT
Message-ID: <80cpi3$ht9$1@nnrp1.deja.com>

Hi.

Generate your data again use blanks instead of NULL : 1234 XYZ
Change your load command : field1 char(4), field2 char(5) NULLIF (field2)=BLANKS field3 char(3)

HTH. Michael.

In article <80ch4m$auj$1_at_nnrp1.deja.com>, la_quake_at_my-deja.com wrote:
> Hello everyone, here is the problem:
>
> SQLLDR keeps insisting that there are no NULLs in my data and so what
> it does, it moves the next data over to where NULL was. For example,
> the following fixed data:
>
> 1234<NULL>XYZ
>
> is converted to
>
> 1234XYZ
>
> by SQLLDR. How can I make SQLLDR to see the NULL? Thanks in advance
> for your help.
> --
> Please visit the following site to get to know the real Sathya Sai
Baba:
> http://www.myfreeoffice.com/saibabaexposed/index.html
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 10 1999 - 15:54:13 CST