Data Manipulation Language Statements › @CONNECT—establishes a record occurrence

@CONNECT—establishes a record occurrence

The @CONNECT statement establishes a record occurrence as a member of a set occurrence. The specified record must be defined as an optional automatic, optional manual, or mandatory manual member of the set.

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

Currency

Before execution of the @CONNECT statement, you must satisfy the following conditions:

• All areas affected either explicitly or implicitly by the @CONNECT statement must be readied in one of the update usage modes (see @READY later in this chapter).
• The named record must be established as current of its record type.
• The appropriate occurrence of the set into which the named record will be connected must be established. The current record of set determines the set occurrence. If the set order is NEXT or PRIOR, this record determines the position of the new member within the set.

Following successful execution of the @CONNECT statement, the named record is current of run unit, its record type, its area, and all sets in which it currently participates. The following figure illustrates the steps required to connect an EMPLOYEE record to an occurrence of the OFFICE-EMPLOYEE set.

To connect EMPLOYEE 459 to the OFFICE 1 occurrence of the OFFICE- EMPLOYEE set, you must establish EMPLOYEE 459 as current of record type, locate the proper occurrence of the OFFICE record, and connect EMPLOYEE 459 to the OFFICE-EMPLOYEE set.