Now the problem is that if the key for lookup repeats then the values have already been updated so the lookup should return updated values. But the Lookup stage still returns the same un-updated rows.
I have used an ODBC stage for Lookup and a DB2 stage for update.
I have tried setting the isolation levels to 'Read committed' and 'Read Uncommited' in ODBC stage. I have configured DB2 stage with array size and transaction size both 1. But it still does not work.
Is there anything else I can do to ensure that the lookup returns the updated values?
Code: Select all
Input -------> Tfm ------------> Tfm -----------> Output
| |
| |
| |
ODBC Stage DB2 stage(update)
<lookup>