IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    SET ALL=PASS
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Member
Posted
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
 
Posts: 15 | Registered: May 17, 2004Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    SET ALL=PASS

Copyright © 1996-2008 Information Builders, leaders in enterprise business intelligence.