Re: sqlldr load numbers changing decimal

grille11_at_yahoo.com wrote:

> Hello,
>
> I am trying to load a text file with numbers containing a . as a decimal.
> The only problem is only comma , is accepted as a decimal on my server.
>
> 1;0;0;2004-02-27 00:00:00;3;0;N;;2004-02-27 00:00:00;;
> 1;1990;2;2003-01-09 00:00:00;5;0;N;1513.2527515762899;;;
>
> my ctl:
> LOAD DATA
> INFILE 'D:\fnbhistoho.txt'
> INTO TABLE "USER"."FINANCIALNUMBERHISTOHOLLOW"
> FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
>
> (FINANCIAL_NUMBER_SET_ID, FISCAL_YEAR, PERIOD_TYPE_ID, DATE_ORA DATE
> "YYYY-MM-DD HH24:MI:SS", NUMBER_TYPE_ID, IS_WIP, IS_ESTIMATED, NUMBER_VALUE,
> NUMBER_DATE_VALUE DATE "YYYY-MM-DD HH24:MI:SS", NUMBER_STRING_VALUE,
> NUMBER_INT_VALUE )
>
>
> the command line:
> sqlldr user/pass_at_server control=D:\testrun.ctl log=D:\log.txt
>
>
> If anyone could help...
> thanks in advance

Use a function to TRANSLATE periods into commas.

Go to http://www.psoug.org
click on Morgan's Library
click on SQL*Loader
look at demos 7 and 8

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)