direct load, how to specify POSITION?

From: Erin Gu <ygu_at_lucent.com>
Date: Mon, 30 Sep 2002 17:50:21 -0400
Message-ID: <anagv0$fev@netnews.proxy.lucent.com>

Hi, I have a table like this: create table erin1 (name varchar(20), birthday DATE, b_year number, age number); Note the b_year is a "derived" value from birthday.

A sample data file looks like this:

erineringu|1980-06-30|

me|1980-06-30|

I am trying to use sqlldr to load data into table erin1:

...

(

name CHAR TERMINATED BY "|" ,

birthday DATE 'yyyy-mm-dd' TERMINATED BY "|" ,

b_year POSITION (12) INTEGER EXTERNAL TERMINATED BY "-"

)

The result is the second record got rejected, I think this is because the POSITION specified on the control file doesn't match. Can anyone tell me how to make this work? I read some document about using POSITION, but I still don't underestand how it works with data in a non-fixed-format.

also, does sql loader provides any kind of calculate/logic function? I also want load "age" field at the same time, which is calculated by b_year.

Thanks in advance!

Erin Received on Mon Sep 30 2002 - 16:50:21 CDT