I have a situation in which I want the user to be able to make the same update to a number of records that can be described by a keylist. The issue is that other users may lock one or more of the records that require updating. I realize that I can use commitment control to handle situations where a record lock by one user would cause an update by another user to fail.
Is there a way use "Create View" to grab the records I want and allocate that view so that no other users can update these records? My problem is that when I attempted this, the created view would not allocate. The physical that the view was created over was in use but *SHRRD in HELD status. My other fear is that if I can allocate the view ALL the records in the file would be unupdateable (is that even a word?).
Any thoughts would be appreciated.