-
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
Appreciation is a wonderful thing;
It makes what is excellent in others belong to us as well.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|