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
Dynamic lookup to table
Moderators: chulett, rschirm, roy
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.
You will have to run the jobs sequentially in that case.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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
-
- Premium Member
- Posts: 38
- Joined: Fri Apr 22, 2005 6:07 am