Hi,
I have a table T and two programs P1 and P2. P1 sets a lock on table T and P2 has a simple MODIFY statement to insert/update data in T (no locking).
I executed P1 till the call to the enqueue function module and then had the program wait in debug mode. In another session, I executed P2. What I saw was that P2 had updated T inspite of the lock issued by P1.
On the other hand, when I tried to issue a lock on T from within P2, it failed (since P1 had already locked the table).
Is this normal behaviour?