Re: SQL Loader and Null Values

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/02/04
Message-ID: <34d8e6ea.31039304_at_www.sigov.si>#1/1

On Wed, 04 Feb 1998 14:43:44 -0500, Steve Mustanski <steve_mustanski_at_ici.nospam.com> wrote:

>Hi. I am trying to load a table with a source file that has nulls in
>several numeric fields. I am trying to force the nulls to zero. I have
>tried several variations, but can't seem to get the syntax right.
>Basicaly it looks like this:
>
>field1 position(001:010) decimal external,
>
>I know I need to add something at the end. I have tried defaultif
>(field1 is null) and several other things, but get syntax errors. The
>documentaion I have isn't very helpful. Thanks for any help.

Use the following:

field1 position(001:010) decimal external "NVL(:field1, 0)",

>
>Steve

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Feb 04 1998 - 00:00:00 CET