date difference to be found out

[ArndW]

Where do you want to do this? The format you showed can only be done in SQL yet you assigned the result to what looks like a stage variable. If it is SQL then you need to convert your string to_date; if in DataStage you would need to explain exactly what you are trying to achieve.

[praburaj]

Thanks for ur kindly reply Arnd,

I got answer. I have applied the condition with sql query in OCI stage.

Now, the jobs are working fine. :D

[ray.wurlod]

A CASE clause within the SQL would seem the obvious way to go.