Informix – where the clause with merge

j & # 39; uses Informix Dynamic Server version 12.10.FC9W1X2.

I need to update a table with fields from another table. I'm trying to use the


statement, but I'm not able to use a Where the clause to filter the information of the table being updated because this causes a syntax error. I've also tried to add AND the When corresponds and it does not work.

Is there a way to do that?

This is my statement so far,

MERGE IN table1 as t1
USE table2 as t2
ON t1.some_no = t2.some
When corresponds
UPDATE SET t1.some_other_no = t2.some_other_no, is_processed = "Y", resolution = "AAA & # 39;