Informix DB load error [datetime field]

[sureshdsx1001]

Hi,

There is table defined in Informix DB havinb column defined with data-type as "Datetime year to month" i.e data expected in format "YYYY-MM"

I want to load this table using Informix Enterprise stage, but I am facing various issues during load due to datatype in-compatibility issues.

There is no datatype in DataStage defined as DateTime, and that too in format [Year to month] as required by target DB

I tried loading the data in "varchar" format, but its ignored and dropped

Note:
The following query works from any Informix client
insert into bill_etl
values
('1998-01')

Can you guys please advice on this

Regards,
Suresh