DSXchange

Hi
I have a scenario where I want to update a table for records with date column is null

If I use generated query with date as a key column, job doesn't update anything in the table.

I think custom query doesn't accept Date is null and job fails if I use it.


Could any of you please let me know how to handle this situation?

Thanks,

A bit lost. Why don't we start with you posting the generated SQL? If you are passing in a value of NULL to a where clause that says where your "date column" *equals* that passed in value, then yes it will never work.

What database is this?

DB2 ..tried ...UPDATE SCHEMA.TABLE SET COL1 = ORCHESTRATE.COL1, COL2 = ORCHESTRATE.COL_2 WHERE ( KeY_COL1 = ORCHESTRATE.KeY_COL1 AND DATE=ORCHESTRATE.DATE)



UPDATE SCHEMA.TABLE SET COL1 = ORCHESTRATE.COL1, COL2 = ORCHESTRATE.COL_2 WHERE ( KeY_COL1 = ORCHESTRATE.KeY_COL1 AND DATE IS NULL)

I used NVL to handle this scenario. andit worked. thanks

Right. Exactly.