Hi,

Can anyone tell me if this is possible and hopefully how to do it?
I have a datafile that looks like so:
86001007063029,+00000071,+00000300

The first column is a barcode, the 2nd a quantity, and the 3rd is a value.
My issue is with the 2nd column.

In the table - the quantity column is DECIMAL(12,3).

The value in the database after the insert should read "0.071".

My problem is when I use this as a column spec in the load statement
",del_qty ASCII(9)" - it loads the data as "71.000" which is obviously not what I need.

Can anyone help me out?

Thanks