The RI command releases a held record and ISN.
This document covers the following topics:
The RI command releases ISNs for records being held by the issuing user. The selected ISN for a single database file, or all ISNs held by the issuing user in all files can be released.
The user specifies the file and ISN of the record to be released in the appropriate Adabas control block fields. Specifying zeros in the ISN field releases all the records currently being held by the user in all files.
Note:
Programs using ET logic should not release records with the RI
command if any updating has been performed during the current transaction,
since this could result in a loss of data integrity. ET users should release
ISNs with the ET or CL commands.
| Field | Position | Format | Before Adabas Call | After Adabas Call |
|---|---|---|---|---|
| 1-2 | -- | -- | -- | |
| COMMAND CODE | 3-4 | alphanumeric | F | U |
| 5-8 | -- | -- | -- | |
| FILE NUMBER | 9-10 | binary | F | U |
| RESPONSE CODE | 11-12 | binary | -- | A |
| ISN | 13-16 | binary | F | U |
| 17-72 | -- | -- | -- | |
| COMMAND TIME | 73-76 | binary | -- | A |
| USER AREA | 77-80 | -- | -- | U |
Not used
where:
| F | Filled in by user before Adabas Call |
| A | Filled in by Adabas |
| U | Unchanged after Adabas call |
| -- | Not used |
RI
The number of the file containing the record to be released.
Note:
When using two-byte file numbers and database IDs, a X'30' must be
coded in the first byte of the control block.
Adabas returns the response code for the command in this field. Response code 0 indicates that the command was executed successfully. Non-zero response codes, which can also have accompanying subcodes returned in the rightmost half of the additions 2 field, are described in the Adabas Messages and Codes documentation.
The ISN of the record to be released. If an ISN value is entered, the file number must also be specified. To release all ISNs held by the user, set this field to binary zeros.
The record identified by ISN 3 in file 2 is to be released from hold status.
| Command Code | RI | |
|---|---|---|
| File Number | 2 | record to be released is in file 2 |
| ISN | 3 | record with ISN 3 is to be released |
Any records being held by the issuing user are to be released from hold status.
| Command Code | RI | |
|---|---|---|
| File Number | - | a value in this field is ignored if the ISN field is zero |
| ISN | 0 | release ISNs for all held records from all files |
