If you are getting locks on files with any regularity you may want to write an inquiry only version of program. The other thing we found in some of our code written by an outside vendor using old school coding methods was causing our lock problems. When they were trying to validate a record they were using the CHAIN command. This puts a lock on that record until it’s released. They should have used the CHAIN(N) which does basically the same thing but does not lock the record.
Register Hereor login if you are already a member