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

@ACCEPT DBKEY RELATIVE TO CURRENCY—moves the db-key

The @ACCEPT DBKEY RELATIVE TO CURRENCY statement moves the db-key of the next, prior, or owner record relative to the current record of set to a location in variable storage. Use the PGINFO option to specify a location in program variable storage where the page information associated with the returned dbkey is moved. The DBMS examines the current record of the named set and extracts the requested pointer from its prefix.

This statement allows you to save the db-key of a record within a set without actually having to access the record. Records whose db-keys are saved in this manner are available for subsequent direct access by an @FIND/@OBTAIN DBKEY statement.

Note: Native VSAM users—The @ACCEPT DBKEY RELATIVE TO CURRENCY statement is not valid for native VSAM data sets.

Note: You must establish set currency before using this statement. If no set currency has been established, the DBMS returns 0000 to the ERRSTAT field and -1 to the DB-KEY field.

Currency

Currency is not updated after execution of an @ACCEPT DBKEY RELATIVE TO CURRENCY statement. The record that is current of record type before the @ACCEPT statement will remain current immediately after the statement is executed.

For more information on page information fields, see @ACCEPT PGINFO.