This Natural profile parameter specifies whether ISNs (internal sequence numbers) for records which were read and placed in hold status but were not updated are to be retained in hold status.
Possible settings | ON |
Natural releases the ISN of each record which has been
placed in hold status but was not updated (for example because the record was
rejected as a result of a WHERE clause or an
ACCEPT/REJECT
statement). This reduces the number of ISNs which are contained in the hold
queue.
Note: |
---|---|---|
OFF |
The ISN of each record which has been placed in hold status is not released until the end of the transaction. | |
Default setting | OFF |
|
Dynamic specification | yes | |
Specification within session | no | |
Application programming interface | USR1005N |
See SYSEXT - Natural Application Programming Interfaces in the Utilities documentation. |
Note:
In nested processing loops, a record which due to
RI=ON
is released in an inner processing loop is no longer kept in
hold status for any outer loop.