SY7I - UPDTLOCK
Update Lock
Update lock adds a restriction to a record update submitted from a 7i screen. The restriction checks to see if the record has been updated by another user between retrieval and update. If the record has been updated, the user is notified of the update and requested to re-retrieve the record try again.
Code Category: SY7I
Code Value: UPDTLOCK
Short Description: Not required.
Medium Description: Not required.
Long Description: Up to 72 characters may be used to describe the common code.
Associated Numeric Values
1-5: Reserved for future use.
Associated Codes
1: TIMESTAMP – By default the update check looks at the last update date for the record (UPDATE_WHEN) and compares it with the value currently stored in the database. If this column does not exist in the table being updated, the restriction looks at all values originally retrieved from the database and compares each one with what is currently stored.
2-5: Reserved for future use.
Associated Descriptions
1-5: Reserved for future use.