Great tip! A similar technique utilizes multiple SET statements instead of the MERGE (less overhead for big data sets). Also if using the MERGE without a BY, consider including the system option MERGENOBY=NOWARN.