I have a simple Data Factory in Azure that reads from a CSV file and writes to an Informix table. I have a problem with decimal columns in Informix database. I can save integers but when I try to save numbers with decimals I have this error:
ERROR [22018] [Informix][Informix ODBC Driver][Informix]A character to numeric conversion process failed,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [22018] [Informix][Informix ODBC Driver][Informix]A character to numeric conversion process failed,Source=iclit09b.dll,'
The CSV contains the number with this format, example:
XX;22.22;xx
If I send the file with this format XX;22,22;xx Azure gives an error.
I think that the problem is related with the driver because with JDBC I can perform an update with the decimal column.
I have this configuration in ODBC. The database locale is es_ES.819.
