+ Reply to Thread
Results 1 to 3 of 3

Thread: Which one cause record lock

  1. #1

    Default Which one cause record lock

    When you read a record from an update file, the record is locked until the update is done, or another record is read from the SAME file. Trying to read and/or update the record with another logical will cause a lock error.

  2. #2
    Guest.Visitor Guest

    Default Which one cause record lock

    Hi.. I have a program that was copied from Mr Kevins Vanderver single page subfile. The display file is refering to the physical using REFFLD keyword. I'm using the one physical for update and 2 logical. One logical for read and another is for update. When I try to CHAIN the logical for update, error message CPF5032 appear (I/O error CPF5032 was detected in file SFLPAYQYF (C G D F).) . It seems like I've locked myself up. How can this be happening? Which one caused the lock? The display, the files, the activation group? regards

  3. #3

    Default Which one cause record lock

    If you're using a File that's open for update in the Read Loop that fills the SFL, then until the File gets to EOF, the last record you've read will always be locked (assuming you don't re-position etc). If this file must be both in update mode and used to fill the SFL, then avoid locking the record using one of the methods below. The N in the Half adjust field and the (N) Operation Extender will both do a read that does not lock the record. They can both be used with CHAIN (READE, READP etc) as well. But since the Record is not locked, you can't do an update based on that READ or CHAIN. An update would first require a locked READ or CHAIN of the record. Mike
    Code

+ Reply to Thread

Similar Threads

  1. Avoid Record Lock Errors
    By MQueue in forum RPG
    Replies: 2
    Last Post: 11-06-2008, 08:30 PM
  2. TechTip: Preventing Record Lock, Part 3
    By MCWebsite.Staff in forum RPG
    Replies: 1
    Last Post: 12-03-2004, 10:32 AM
  3. TechTip: Preventing Record Lock, Part 2
    By barnes@longwholesale.com in forum RPG
    Replies: 8
    Last Post: 11-19-2004, 06:41 AM
  4. Record Lock - Need Help.
    By ukpi1b in forum RPG
    Replies: 2
    Last Post: 11-11-2002, 10:12 AM
  5. File/Record Lock
    By wjminc in forum Programming
    Replies: 1
    Last Post: 04-17-1997, 11:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts