I have tried using the FM ENQUE_DELETE but I keep on not getting the expected result to delete the lock for some table entries.
I noticed that there are different kind of locks and the program that locked those table entries is using lock type 'E'.
Could I set the lock type to 'S' (Shared) so that it is possible for the first program to "lock" the table entries but once the second program is run, it can delete the table lock?
It should never be needed to explicitely delete specific table lock entries manually. Always only use the generated FM
enqueue_...
anddequeue_...
to lock/unlock db records!This will delete the previously created lock entries.