Data Manipulation Language Statements › @ACCEPT DBKEY RELATIVE TO CURRENCY—moves the db-key › @ACCEPT DBKEY RELATIVE TO CURRENCY Parameters

@ACCEPT DBKEY RELATIVE TO CURRENCY Parameters

DBKEY=db-key

Identifies the location in variable storage that will contain the db-key of the requested record.

PGINFO=pg-info-v

Specifies the name of a four-byte field that is made up of two halfword fields. Identifies the location in variable storage that contains page information for the specified record. Upon successful completion of this statement, the first two bytes of the field contain the page group number and the last two bytes contain a value that may be used for interpreting dbkeys.

SETN=/SETP=/SETO=set-name

Determines the record whose db-key will be placed in the location identified by db-key. Set-name must be a set included in the subschema. The saved db-key can belong to the next, prior, or owner record relative to the current record of the named set:

• SETN=set-name saves the db-key of the next record relative to the record that is current of the specified set. A request for SETN currency cannot be specified unless the named set has prior pointers; prior pointers ensure that the next pointer in the prefix of the current record does not point to a logically deleted record.
• SETP=set-name saves the db-key of the prior record relative to the record that is current of the specified set. A request for SETP currency cannot be specified unless the named set has prior pointers.

  Note: No indication of an end-of-set condition is possible for an @ACCEPT SETN or SETP. A retrieval statement must be issued to determine whether the next or prior record in the set occurrence is the owner record.

• SETO=set-name saves the db-key of the owner of the current set. A request for SETO currency cannot be executed unless the named set has owner pointers. If the current record of the named set is the owner record occurrence, requests for SETO currency return the db-key of the record itself, even if this set does not have owner pointers.

  Note: When a record declared as 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 named set. A subsequent attempt to access the owner record will instead locate the owner of the current record of set. In such cases, determine whether the retrieved record is actually a set member before executing the @ACCEPT DBKEY=db-key, SETO=set-name statement. The @IF statement (see "@IF" later in this chapter) can be used for this purpose.