FIND/OBTAIN OWNER

Database Access Commands › Navigational DML › FIND/OBTAIN OWNER

FIND/OBTAIN OWNER

Purpose

Accesses the owner record of the current occurrence of a set.

Syntax

►►──┬─ FIND ───┬───┬──────────────────────────┬───────────────────────────────►
    └─ OBTAIN ─┘   └─ KEEP ───┬─────────────┬─┘
                              └─ EXCLUSIVE ─┘

 ►──── OWNER WITHIN set-name ───┬────────────────────┬─── . ──────────────────►◄
                                └─ error-expression ─┘

Parameters

KEEP

Places a shared lock on the object record.

EXCLUSIVE

Places an exclusive lock on the object record.

OWNER WITHIN set-name

Specifies the set whose owner record is to be retrieved.

Set-name must be known to the dialog's subschema.

error-expression

Specifies the status codes that are returned to the dialog.

Usage

Considerations

If autostatus is not in use, a dialog's error-status field indicates the outcome of a FIND/OBTAIN OWNER command:

Status code	Meaning
0000	The request was executed successfully
0306	Currency was not established for the named record, set, or area
0308	The object record is not in the dialog's subschema
0310	The dialog's subschema specifies an access restriction that prohibits retrieval of the object record
0329	A run-unit deadlock condition occurred. DBMS aborted and rolled back the run unit. All resources associated with the task are released

Further Considerations

Currency must be established for the object set to execute a FIND/OBTAIN OWNER command.
FIND/OBTAIN OWNER can be used to retrieve the owner record of any set in a dialog's subschema, whether or not the set has owner pointers.
The FIND/OBTAIN OWNER command cannot be used with native VSAM data sets because owner records are not defined for such sets.
When an optional or manual member of a set is accessed, it is not established as current of set if it is not currently connected to the object set. A subsequent attempt to access the owner record locates instead the owner of the current record of set. The IF statement can be used to determine if the accessed record is actually a member of the object set before executing the FIND/OBTAIN OWNER command.
After successful execution of a FIND/OBTAIN OWNER command, the accessed record is current of:
- The run unit
- Its record type
- Its area
- All sets in which it currently participates as member or owner
If the current record of set is the owner record when the command is executed, currency in the object set is not changed.

Example

The statements in the following example illustrate the use of the FIND/OBTAIN OWNER command:

MOVE 'CC' TO ORD-NUM.
OBTAIN CALC ORDOR.
OBTAIN LAST ITEM WITHIN ORDER-ITEM.
OBTAIN OWNER WITHIN PRODUCT-ITEM.

More information:

Error Handling

Conditional Commands