converting string to date for DB2

[major]

Hi all,

I am loading a seq file to a DB2 db.
I have a date field column in the table
when i try to load the value in this column "cannot able to convert sting to date" warning is coming.

I have been using the below function but of no use

OConv(IConv(FM_FLEETS_HASH_FILE.START_DT,"D"),"D-YMD[4,2,2]")

Please help me in this regard.

Thanks,

[chulett]

I don't work with DB2 but from the forums here I think the DB2 stage wants dates in internal format, so you might try just the IConv part.

[ray.wurlod]

The error arises from the Iconv() function. Whatever the format of your date is, it is not understood by "D" as a conversion, which expects the date format of your locale (had you provided your location I could probably be more specific about that). Try

Code: Select all

Iconv(FM_FLEETS_HASH_FILE.START_DT,"DYMD")

if your date is in year - month - day order.

I agree with Craig that you probably don't need the Oconv() function when sending dates to DB2.

[major]

Thanks Ray,

I converted the input date to YEAR-MONTH-DAY format and applied the
ICONV(date,'DYMD') and its working fine.

Thanks all,