MERGE WITH clause

described in detail in Chapter 7.

MATCH ON clause

serves a somewhat different purpose in the MERGE command than in the other Join commands.  The match fields are not used to select records having identical match field values, as is the case in most commands, since in a merging operation all records that pass the master and transaction conditional clauses and the after conditional clause, are merged.  The match fields serve only to control the order of the records in the output DS, not actually to match field values: e.g., if the two DS’s are being merged on a numeric field, the value 1.25 in the transaction DS will be placed after 1.24 and before 1.26 from the master DS.  For records whose match fields are identical in master and transaction DS’s, the transaction records are merged before the master records by default. Described in detail in Chapter 7.

/MERGED/ TO ds_name

directs the merged records to the output DS.  The output DS must already exist, and its Schema Definition (SD) must be identical to that of both the master and transaction DS’s.  If there are records in the output DS, they will be cleared before the new merged DS is written out.  Either the master DS or the transaction DS can also be used as the output DS.

IN DBL dbl_name

is used to specify an output DS in another Data Base Library (DBL).

IF/:M/; UNLESS/:M/ clause

can be used to exclude matching records from the output DS. Described in detail in Chapter 7.

IF:T; UNLESS:T clause

described in detail in Chapter 7.

IF:A; UNLESS:A clause

described in detail in Chapter 7.

ADVANCE clause

is used to control the order in which matched records are merged when match field values are identical in master and transaction records.  ADVANCE TRANSACTION, the default, puts transaction records before the matching master records.  ADVANCE MASTER causes master records to precede matching transaction records.  ADVANCE BOTH causes each matching transaction record to be interleaved after a matching master record.  Described in detail in Chapter 7.

VIA clause

specifies a Process Module (PM) to be executed.  When a PM is specified in a MERGE command, the records are merged before the record processing sections of the PM execute.

SHOWING clause

shows all merged records after the SET clause has been applied. Described in detail in Chapter 7.

SET clause

affects only master records in the output DS. Described in detail in Chapter 7.

STOP; END clause

is described in detail in Chapter 7.