Hi Bill You cannot assume the exit of a subroutine clears locks. The way DB works, I suspect that DB has a worker program that calls routines. If that worker program does not stop then locks may not be cleared. When you restart UO you are only then clearing a persistent lock. Also check that the locked message is from the routine you think it is. I don't know your code, I am just passing issues I have seen in the past. Do you have triggers doing an update.
It sounds like a lock from a previous step has not cleared. Put a RELEASE statement in the routine before it exits and see if that helps. Regards David Jordan _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
