RE: How to find wich program lock file record

Ellen Eliason <[email protected]> Thu, 2 Apr 2026 13:40:10 +0000
Newsgroups gmane.comp.lang.as400.rpg
Message-ID <BL1P220MB085056F6EF5D990BBF368FDACB51A@BL1P220MB0850.NAMP220.PROD.OUTLOOK.COM>
Hello,
I had a very frustrating bout with message CPF5032 "Record already locked to this job recently.

I was able to resolve it with a compile parameter.  I believe an SQL statement within the program was causing the lock.  This was an SQLRPGLE program.

Parameter is COMMIT.  The default (for us) was *CHG.  We needed to change it to *NONE.

Good luck

Ellen
-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.