SQL-Loader

Have any one loaded negative integers from a file using SQl-loader before ? I have looked in the manual (SQL loader) and it does not talk much about negative integers. I have defined this field as :

create table ..
..
..

earn_amt number(7,2) ,
...
..

My ctl file looks like :

options (rows =100)
load data
infile ......
replace
reclen 173
into table ...
(
 ....
 ...
 earn_amt position (167-179) decimal external,

 ...
 ..
 . )

Here is what the data looks like

E001                  0246202401                         2401 03224746892093092093085                                     1783    A900105M1007420912 000.00 PCR000.00 000001338.89-                                       1930910719309207193093072402000000.000    000000258.41-X

I can't see anything wrong with the way I have things defined. However, I never have worked with this type of data.

I appreciate any help, thanks.

Cheers !

Carlo Ciufoli                       |Voice 303-491-6064
Computer Programmer                 |e-mail : ciuffoli_at_vienna.ir.colostate.edu
Budgets & Institutional Analysis    |       : ciuffoli_at_lamar.ColoState.edu
Colorado State University           |Disclaimer: my opinions are my own and not
Fort Collins,CO. 80525. Great U.S.A.|            of my employer.
-------------------------------------------------------------------------------