Home > IT Answers > AS/400 > Record locking in iSeries
Kar
425 pts.
 Record locking in iSeries
AS/400, AS/400 Records, Record lock, RPG Record Locks
My program takes the input as file, and process those records one by one. Here I would like to add the commitment control, if any one record fails then roll back and continue with the next record. To test this, I need to lock the record in another session and to run the program to check the ROLBK. How to lock the record? I tried with UPDDTA and its not locking the record. So now I have written a record locking program to lock the required record when testing. Is there any other way to lock the specific record?



Software/Hardware used:
Iseries
ASKED: June 14, 2011  7:38 AM
UPDATED: June 16, 2011  3:44 AM
RELATED QUESTIONS
Answer Wiki:
STrSQL Options (F13) set commitment to *all Issue a select for the record. Remember that before you leave SQL do a commit and change the commit option back to *none Phil
Last Wiki Answer Submitted:  June 15, 2011  10:06 am  by  philpl1jb   44,070 pts.
All Answer Wiki Contributors:  philpl1jb   44,070 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks a lot Phil, it worked..!

Kar
 425 pts.