"Invalid month in date" while updating in Informix

dataservices job design
1

A dataflow contains a Table_Comparison transform to update in an Informix target table.

The update fails because of : Invalid month in date.

SQL submitted to ODBC data source resulted in error <[Informix][Informix ODBC Driver][Informix]Invalid month in date>. The SQL submitted is <UPDATE eunadm.dw_audit SET idappli = ‘002176691’, nmtable = ‘corrmark’, nmcolumn = ’ ',
indvalue = ’ ', indoper = ‘I’, status = 1, dtinsert = ‘2/20/2006’, dtprocess = ‘6/21/2006’ WHERE idappli = ‘002176691’ AND
nmtable = ‘corrmark’ AND
nmcolumn = ’ ’ AND
indvalue = ’ ’ AND
indoper = ‘I’ AND
status = 0 AND
dtinsert = ‘2/20/2006’ AND
dtprocess IS NULL >.

Indeed, when I query the target table, I see the dates as YYYY-MM-DD.
However, Data Integrator formats the dates as MM/DD/YYYY.

Based on what settings is the update-statement generated ? How can I manipulate that ?

Hans Segers (BOB member since 2006-06-21)

2

Windows regional settings?
Informix default locale (database driver)?
Datastore locale?

No clue but you can try changing above and see what impact it has unless somebody can really answer that one.

Werner Daehn :de: (BOB member since 2004-12-17)