Slide 1

Abstract

“Plain vanilla”: IN

… Code

… Result

… Equivalent code

Basics

Data set options

BY processing: Requirements

Options and BY: IN

… Code

Managing variables in the PDV

Options and BY: Result

“Automatic” RETAIN

Other flavors

Combining Multiple Data Sets

IN= data set option

Attribute conflicts

STATES

COUNTRIES

Concatenation: Code

… Result

Interleaving: code

… Result

Interleaving (again): Code

… Result

Attribute conflict: Code

… Result

… Solution

… Result

MERGE without BY: Code

… Result

MERGE with BY: Code

… Results

LEFT

RIGHT

Collating peer data sets: Code

… Result

Matching cases only: Code

… Result

Table lookup: CUSTOMERS

… SERVICE_AREA

… Code

… Result

MERGE Pitfalls: DETAIL

…. RESTATE

Repeats & Collisions: Code

… Result

… Solution

… Result

User interference: Code

… Result

UPDATE: CUSTOMERS

… REV

… Code

… Result

UPDATE features

MODIFY: BIG

Pseudo-modification: Code

… Result

MODIFY: Features

MODIFY: Code

… Result

CUSTOMERS

REV

Master/transaction: Code

… Result

Random access

… Random-order data

… Logically sequential access

… Result

Arbitrary-order access

… Result

More

About the Speaker