Re: SQLLOADER Q?

From: Catherine A. LeBlanc <cleblan2_at_abacus.bates.edu>
Date: Thu, 13 Jul 2000 14:54:21 -0400
Message-Id: <10557.111989@fatcity.com>

Try something like this in your .ctl file: ...
INTO TABLE YADAYADA
( field1 POSITION(001:010)INTEGER EXTERNAL "REPLACE(:field1,null,0)", ...

You can use just about any sql function on the field this way, inside the double quotes, after the datatype.

At 06:55 AM 7/13/2000 -0800, you wrote:
>...went through the doc's but no answer yet (looks like not posible)
>
>I want to load a file that has "null" values. During the load I want to
>substitute all null values with the number "0" (=zero)
>Anybody tried this before?
>
>Jack

--
Catherine A. LeBlanc
Database Analyst
Bates College, Lewiston, ME
cleblan2_at_bates.edu
Phone: (207)786-6431

Received on Thu Jul 13 2000 - 13:54:21 CDT