1
Strange problem with locking of records
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, 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
Record Locking in SQLRPGLE
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
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
Record locking in iSeries
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
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
AS400 – File
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
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
When will AS/400 record lock?
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
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
Records lock error
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 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
Record Locking
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’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
Difference between Record and File locks
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
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
1
