I was wondering to know if the LOOKUP in MVS Edition can read an uncommited record from a DB2 table acting as a reference for lookup. I tried to use WITH UR option in the Relational stage, but it does not seem to be working for me. In my process, I insert records into the same table if the preceding lookup was not successful. But, when I process the next record with the same values, it should have found the previously inserted row and the lookup should have been successful. However, I keep getting the lookup unsuccessful and causing to insert the same row to the table(Since we have timestamp as part of the key, it allows).
This topic has been locked.