Dynamic lookup to table

forboy · Post by **forboy** » Mon Apr 10, 2006 10:36 am

How can I do a dynamic lookup.

I have a situation where Iam looking up a table and and table is constantly getting updated by some other job. I need these updated values reflected in the lookup as both the job runs at same time.

Thank You
Forboy

DSguru2B · Post by **DSguru2B** » Mon Apr 10, 2006 12:01 pm

Cant you lookup on the table that is being updated. If you are using a DB2 table then you cannot read from the table at the time of an update because a table level lock occurs.
You will have to run the jobs sequentially in that case.

forboy · Post by **forboy** » Mon Apr 10, 2006 12:22 pm

DSguru2B wrote:Cant you lookup on the table that is being updated. If you are using a DB2 table then you cannot read from the table at the time of an update because a table level lock occurs.
You will have to run the jobs sequentially in that case.

I guess lookup gets all the records into memory when the job is started. And if that table is updated , is that updated values reflect in the lookup.

forboy

Amit Jaiswal · Post by **Amit Jaiswal** » Wed Apr 11, 2007 6:08 am

Yes you can do this by using sparsed lookup option instead of normal lookup. In case of db2 udb this is possible only with EE stage.
-Amit