Reading Date from DB2 Enterprise stage

gauravrb · Post by **gauravrb** » Mon Feb 19, 2007 3:36 am

Hi

While reading BIRTH_DATE field of format Date(4) "YYYY-MM-DD" from DB2 database table through DB2 enterprise stage in datastage , is showing a constant default value "1901-01-01" for all the rows at datastage level in spite of different correct date values seen at database level.

I tried increasing the length of field at stage level till 10 but then it was showing the same value.

Is the problem arising due to length or is this a different issue?

boppanakrishna · Post by **boppanakrishna** » Mon Feb 19, 2007 4:49 am

hi,
You can convert the Datatype ...my suggestion could be you can use To_char function and then start processing

Thanks
Bopppana

ray.wurlod · Post by **ray.wurlod** » Mon Feb 19, 2007 2:53 pm

Does DB2 have a TO_CHAR() function? You can certainly CAST (BIRTH_DATE AS CHAR(10)) to read it as Char(10).