Re: direct load, how to specify POSITION?

On Mon, 30 Sep 2002 17:50:21 -0400, "Erin Gu" <ygu_at_lucent.com> wrote:

>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
>

Position doesn't work with data in a non-fixed format. For the second question please refer to the Oracle Server Utilities Manual.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Sep 30 2002 - 17:43:48 CDT