WH - Wait for Record in Hold Status

#### Search Results

Search

# 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.