1
  • RPGLE Record Lock Data

    I have a program that get a Record Lock. I have captured the *status, however, I need the Program & User that initially read the record first.

    Doc135 pointsBadges:
  • AS/400 – Chain 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?

    rajeshece1,215 pointsBadges:
  • RPGLE SETLL / READE for update getting record lock on different key

    We are encountering sporadic unexpected record locks with update files using: setll (Key1) MasterFile; // Partial key. dou %eof(MasterFile); reade (Key1) MasterFile; if not %eof(MasterFile); // [Stuff] update MasterFmt; endif; enddo; Looking at the problem record by RRN, its key does not match...

    SemiTechieGeo70 pointsBadges:
  • Record Locking in Access 2007

    How can I lock records in a simple Access database after updates? And, how do I set up the user interface to include only the form I would like for the user to complete?

    SJohnso35 pointsBadges:
  • 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 in...

    Varun123190 pointsBadges:
  • Records lock error

    I keep getting a records lock error even after I change the setting to no records lock.

    Tbartlett20105 pointsBadges:
  • 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

    Varun123190 pointsBadges:
  • 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 check the ROLBK....

    Kar425 pointsBadges:
  • 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 or setll operation codes) ? If I will...

    SARKNS30 pointsBadges:
  • Prevent record lock scenario with AS/400 ?

    Suppose 2 users are accesssing the same record in a file.User 1 tried to update the record and while doing so he did not log-off from his update screen,while the user tries to do inquiry on that same record. As a result there will be a record lock situation.How to prevent this scenario ? i need...

    Supriyoas400130 pointsBadges:
  • remove a trigger file record lock

    I have a CLLE trigger program that is trying to set a job environment. I am manipulating the LIBL on the fly based on the location of the order and if it's TEST or LIVE. I get the info from the trigger input parms which has the order#, location, TEST or LIVE, order# and order status which is blank...

    ToddN20009,905 pointsBadges:
  • Batch Files – Record Locks

    What is the most proficient technique to eliminate the record lock errors in batch processing?

    Rpgilequestions0 pointsBadges:
  • Mysterious AS/400 record locking

    We have been experiencing a surge in the number of occurrences of record locks in our shop. We make sure we follow the rules for preventing record locks. But I have seen programs where the UNLOCK is not used even though the UPDATE operation is embedded in between If-EndIf statements. At first I...

    bogeybetsy560 pointsBadges:
  • AS/400 iSeries Submitted Job/Batch Record Lock issue

    I have looked at the other record lock questions/answers on this board but have been unable to find an answer to this problem. I am trying to capture a record lock error in a submitted program. The program is coded to capture the File Status as shown below. I have tested this same record locking...

    kevleemor605 pointsBadges:
  • How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?

    How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?

    Lokanath5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following