Sql*ldr and float dataformat

From: ranne <krieide_at_gmail.com>
Date: 15 Aug 2006 07:14:57 -0700
Message-ID: <1155651297.906601.181290_at_h48g2000cwc.googlegroups.com>

Hi,

[Quoted] [Quoted] I have some problem with loading data into tables. [Quoted] Float datatype.

an example ctl file:

---

LOAD DATA INTO TABLE <table_name>

TRUNCATE FIELDS TERMINATED BY X'09' TRAILING NULLCOLS (

        ANNUAL_RENT "to_number(trim(:ANNUAL_RENT),
'9999999999999999999.9999')",

        ADJUSTMENT FLOAT EXTERNAL,         PREMISES_TYPE_VL INTEGER EXTERNAL,         PREMISES_TYPE_RD INTEGER EXTERNAL,         TENANT_TYPE_VL INTEGER EXTERNAL,         TENANT_TYPE_RD INTEGER EXTERNAL,         PRICE "to_number(trim(:PRICE),
'9999999999999999999.9999')",

)

---

The "float external" does not work. the problem is that my language settings is looking for ' , ' instead of ' . ' in the float section. The float-number = 12.00012 is not recognized but if it say 12,00012 the loader would load the data.

I could use a to_number as i have with price-column, (that column has datatype number(19,4) therefore the format). But Im not sure what format would be valid for float data.

I belive that either a language setting is in order (preferably set on the ctl-file) or to_number with correct format. Any clues? Received on Tue Aug 15 2006 - 16:14:57 CEST