Hi All, My program reads many records one by one, and will update the OLD KEY with NEW KEY in more than 100 files. If any run-time error/record locking the pgm will roll back the partial updates and continue with the next record. So, example take 5 records… in which I locked the 3rd record [...]
Answer Question | March 31, 2012 2:45 PM
AS/400, iSeries, Record lock, RPG Record Locks
Hi All I have a SQLILE pgm which updates files through SQL statements. How to get the user id/job number which is locking the PF record through the program… if any data structure supports, whats the position of it… -Varun
Answer Question | July 1, 2011 12:35 PM
AS/400 Records, Record lock, RPG Record Locks, SQLRPGLE
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 [...]
Answer Question | June 16, 2011 7:38 AM
AS/400, AS/400 Records, Record lock, RPG Record Locks
I wanted to do Chain Kfld File1 If Found And Fld1 = ‘Y’ Update File Else Perform Next Chain Operation Endif Here I wanted to perform the Chain without Locking the Record. I wanted to perform Update Operation without Performing Read/Chain again if the Condition is True. How to achieve this?
Answer Question | February 26, 2011 2:05 PM
AS/400 Records, AS400- File, Record lock, RPG Record Locks
Hi Guru’s , I am new to RPG . I would like to know when record will be locked ? Example-1 : PGMA, using a PF1(Physical file) in input mode , PGMB using a logical file based on PF1, in input mode. In this case record will be locked or not (using read or chain [...]
Answer Question | September 28, 2010 8:58 AM
AS/400 Records, Record lock, RPG Record Locks, RPGLE
I keep getting a records lock error even after I change the setting to no records lock.
Answer Question | October 6, 2011 10:33 AM
AS/400 Locking, AS/400 Records, Record lock, RPG Record Locks
I’m using embeded SQL to delete (clear) all records in a file. I do not want more than 1 person in this file. So whe the user executes the program it runs the SQL and clears the records in the file. Now I want to do some file/record checking logic to see if the file [...]
Answer Question | November 27, 2009 6:59 PM
AS/400, RPG Record Locks, RPGLE
I had always thought that record and file locking where terms used interchangeably. I searched the web and couldn’t validate my assumpition. Is there anyway in RPG you can lock a specific record (record lock) in a file without locking the entire file (file lock)?
Answer Question | October 6, 2011 4:48 PM
RPG, RPG File Locks, RPG Record Locks