Hi ,
I was able to figure out the problem. In the control file I had to specify external for the decimal.

Example
----------
Control File
-------------
load data
infile 'test.txt'
badfile 'test.bad'
discardfile 'test.dcs'
into table test
(company position(01:10) char,
time position(11:20) char,
region position(21:30) char,
lineitem position(31:45) char,
actual position(46:65) decimal external,
actualus position(66:85) decimal external)


What does the external parameter signify??


Now I have another problem. sql loader is rejecting the records which have a comma in them.

Example of the records are
ALLEP YR_1991 REGROLL ISGR 2,215.964133 2,090.143202
ALLEP YR_1991 REGROLL ISOEXP 1,237.364420 1,176.367821


Is there any way I can import the data without commas by making some changes in the control file rather than removing the commas from the datafile itself

The other question which I have is why does the sql loader not return you back to the command prompt after Commit point reached - logical record count 101



Please suggest.

Thanks
Anurag



[Edited by anuragmin on 05-29-2001 at 11:12 AM]