Hi,
Here is the sample data which I am trying to load using sql loader.

ALLEP ,1996,REGROLL ,ISTUSPI , 43522.886393, 34635.613098,YR
ALLEP ,1996,REGROLL ,ISOCS , 11489.679547, 10619.922145,YR
ALLEP ,1996,REGROLL ,ISNGS , 8335.460687, 8144.415170,YR
ALLEP ,1996,REGROLL ,ISNGLS , 462.127086, 424.456126,YR


Here is the control file I am using to load this data

load data
infile 'testa'
badfile 'ofasweb.bad'
discardfile 'ofasweb.dcs'
truncate
into table testme
fields terminated by ","
(company,
time,
region,
lineitem,
actual
nullif (actual = BLANKS),
actualus
nullif (actualus = BLANKS),
year_quarter)

and here is what it loads
COMPANY TIME REGION LINEITEM ACTUAL ACTUALUS YEAR_
---------- ---------- ---------- --------------- ---------- ---------- -----
ALLEP 1996 REGROLL ISTUSPI 43522.8864 34635.6131 YR
ALLEP 1996 REGROLL ISOCS 11489.6795 10619.9221 YR
ALLEP 1996 REGROLL ISNGS 8335.46069 8144.41517 YR
ALLEP 1996 REGROLL ISNGLS 462.127086 424.456126 YR

Notice that the fields in bold have been rounded off.

I dont want to do this since this is a financial database.

Please suggest how.

Thanks
Anurag