Data Manipulation Language Statements › @DISCON—cancels the current membership of a specified record

@DISCON—cancels the current membership of a specified record

The @DISCON statement cancels the current membership of a specified record in a set occurrence. The specified record must be defined as an optional member of the named set.

Note: Native VSAM users—The @DISCON statement is not valid because all sets in native VSAM data sets must be defined as mandatory automatic.

The following consideration apply:

• All areas affected, either explicitly or implicitly, by the @DISCON statement must be readied with one of the update usage modes (see @READY later in this chapter).
• After successful execution of the @DISCON statement, you can no longer access the specified record through the set for which membership was canceled. However, you can access the disconnected record through all the other sets in which it participates as a member, or if it has a location mode of CALC. It is always accessible by means of a complete scan of the area in which it participates or directly through its db-key, if known.

Currency

Before execution of the @DISCON statement, the following currency-related conditions must be satisfied:

• The specified record must be established as current of its record type.
• The specified record must currently participate as a member in an occurrence of the named set.

A successfully executed @DISCON statement nullifies currency in the named set. However, the next of set and prior of set are maintained, thereby enabling continued access within the set. The disconnected record is current of run unit, its record type, and its area.