DSXchange

Hi

I am encountering erron while trying to insert DATETIME YEAR TO FRACTION(3) field. DataStage takes the field as TimeStamp (25) while reading , but failed to insert the same column while I tried inserting it to exactly same data type field.
I encountered the same problem in Server Job for Data Type DATETIME HOUR TO MINUTE!

The error displayed is
Dynamic_RDBMS_15: [Informix][Informix ODBC Driver][Informix]Non-numeric character in datetime or interval.


I tried to use CAST statement in user defined query without any success.

Any suggestion.

Regards
Rubu

Hi,
DATETIME hour to minute has hh:mm format so you'll probably have to substring your data type since no DS type is compatible.
year to fraction could have a similar issue since timestamp (AFAIK) is not including a fraction part.

Unfotunatly I don't have Informix available to give you real solutions

IHTH,

Hi
Can you try this format and check if it works

{ts 'YYYY-MM-DD hh:mm:ss:mmm'

Hi, I suspect this is to be:

ts 'YYYY-MM-DD hh:mi:ss:mmm'