Re: Newbie SQL*Loader question...

Hi

[Quoted]     In control file do not specify DECIMAL (9,4) .     remove this and give in your control file as      (exp_1, dept_code, chgdept, exp_4 )     Now your data will be loaded properly.     Do not specify data types except for DATE fields. I think it helps you.

Wishes
Suresh

Kathy Graham wrote:

> Hi Folks;
> I am attempting my first table load using the SQL*Loader utility.
> The first three fields load without a problem(char fields), however the
> fourth field is causing problems. Here is the ctl file with some sample
> data:
>
> -- Variable-length, delimited and enclosed data format
> LOAD DATA
> INFILE *
> APPEND INTO TABLE target_dept_hours_wcharges
> FIELDS TERMINATED BY " " OPTIONALLY ENCLOSED BY '"'
> (exp_1, dept_code, chgdept, exp_4 DECIMAL (9,4))
> BEGINDATA
> "9412" "5662" "5118" 8.7000
> "9412" "5662" "5212" 93.5000
> "9412" "5662" "5213" 157.7500
>
> The field is actually defined in the table as Number(17,4). I have
> tried various combinations of DECIMAL with different numbers as well as,
> but cannot seem to get the numeric field to load properly. Any
> assistance that anyone could provide would be very welcome. Thanks in
> advance....
>
> Kathy Graham
> Kathy_graham_at_hpl.hp.com
Received on Thu Jul 30 1998 - 11:25:41 CEST