WH - Wait for Record in Hold Status

This Natural profile and session parameter specifies the action to be taken if a required record is not available for processing, because it has been placed in hold status by another user.

Possible settings ON The user is placed in wait status until either the requested record becomes available, or an error message is issued due to Adabas exceeding a time limit or other limit while attempting to place the record in hold status.
OFF An error message is returned if any of these records cannot be placed in hold status.
Default setting OFF  
Dynamic specification yes  
Specification within session yes  
Applicable statements SET GLOBALS  
Applicable command GLOBALS  
Application programming interface USR1005N See SYSEXT - Natural Application Programming Interfaces in the Utilities documentation.

Notes:

  1. This Natural profile and session parameter applies to Adabas databases only.
  2. Within a Natural session, the profile parameter WH can be overridden by the session parameter WH.
  3. When a Natural statement is executed which results in Adabas records being read and an update/delete operation could follow, Natural requests that Adabas places these records in hold status. See the Adabas Command Reference documentation for further information on hold processing.
  4. Under Natural Security, the setting of this parameter can be overridden by the Session Parameters option of the Library Profile.
  5. For a READ or FIND statement using the SKIP RECORDS IN HOLD option, database access is always executed as if WH=OFF is set. If a user attempts to read a record that was placed into hold by another user, this record is skipped and processing continues with the next record in the read sequence. An error message is not returned in this case.