decimal point

Stef · Post by **Stef** » Wed Aug 06, 2003 2:56 pm

Hi all,
I have to load a sequential file (the fields are comma separated) into an Oracle table. One of the fields is decimal 6 with scale 2. Values for this field are for example:

100.40
399.00.

Nothing is copied from the file to the Oracle table. The error message is "not valid number".

Any kind of suggestion will be particularly appreciated. Thank you very much for attention, Stef.

kduke · Post by **kduke** » Wed Aug 06, 2003 3:19 pm

Stef

Look at your generated SQL in the insert or update statement. The error should show it in the log as well. If your metadata is wrong then it will quote a number and Oracle will complain.

Example: '100.00' instead of 100.00

Kim.

Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com

ray.wurlod · Post by **ray.wurlod** » Wed Aug 06, 2003 4:49 pm

Try adding zero to the input number. This forces the result to be a number. You can also format it so that it specifically meets your output requirements. For example:
Fmt((InputLink.ColumnName + 0), "6R2")

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518