Data Manipulation Language Statements › @RETURN

@RETURN

The @RETURN statement retrieves the database key for an indexed record without retrieving the record itself, thus establishing currency in the index set. The record's symbolic key is moved into the data fields within the record in program variable storage. The contents of all non-key fields after the execution of the @RETURN verb are unpredictable. Alternatively, you can have the record's symbolic key moved into some other specified variable storage location.

Index currency is established by:

• Successful execution of the @RETURN statement, which sets current of index at the index entry from which the database key was retrieved.
• A status code 1707 (end of index), which sets currency on the index owner. The DBMS returns the owner's db-key.
• A status code 1726 (end of set), which sets current of index as follows:
  • Between the two entries that are higher and lower than the specified value
  • After the highest entry, if the specified value is higher than all index entries
  • Before the lowest entry, if the specified value is lower than all index entries

The @RETURN statement is used in both navigational and LRF environments.