Focal Point
SET ALL=PASS

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8521038331

February 10, 2005, 05:32 PM
koslo
SET ALL=PASS
My problem is very similar to a recent one, and maybe someone can help me too. Using mainframe Focus 7.3. I can't get an outer JOIN working with SET ALL=PASS in certain cases. It is documented that including contradictory filters for the child would return only parents without children, e.g. JOIN A IN F1 TO B IN F2, or JOIN A IN F1 TO ALL B IN F2, would return only F1 records without F2 records. In other words, no F1 records with children would return data, but F1 records without children do show up because the filter is irrelevant if there are no children.
So if I include a more reasonable filter on F2, I still should get this childless parent. I don't.
A recent posting on using SET ALL=PASS suggested that a MATCH be used instead. Does this mean there is no way to get a left outer JOIN?

Thanks,
Phyllis