1
  • 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:
  • Record Locking in RPGLE

    I'm using embedded SQL to delete (clear) all records in a file. I do not want more than 1 person in this file. So when 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 is locked to another job. Then...

    RonKoontz1,780 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:
  • 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)?

    GTank5 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:
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