Lookup problem

[saprebv]

I have a job which does lookup to Hashfile and inserts into same if lookup fails.

Now If second row has same value as that of first, I want it to find in Hash file as first row has inserted it. But lookup is failing for second row.

I tried various options for lookup as Preload to memory disabled, disabled lock for Update,..

There are lots of link collectors in my job which needs inter process row buffering enabled.

Lookup works if inter process in disabled, as I tried in some test jobs.

Is there any way to make this work without removing Interprocess as removing interprocess would require me to do lot of rework on the job?

Regards,
Balkrishna Sapre

[kcbland]

No. You must rework your job. Row buffering and caching defeat your need to have committed data after each row is processed.