DSXchange

Hi Team,

I am using below below query in oracle connector in my parallel job in order to get yaer and month from date.

select to_char(DATE_COLUMN,'YYYYMM') from table_name.

While running facing error:literal does not match format string.

If i run same query in oracle datbase its working,not sure why datastage throwing fatal error.
Please help,cause i need to compare this to a numeric field from another table which contains year and month ex: 201308

What is your column defined as in DataStage? I would explicitly name the column, as below:
and define DataStageColumn as char with fixed length 6.

Hi ArndW,

After changing it to char,it is working fine.

Thanks.