[CLOSED] outer join changed to inner join in metadata
Hi, new user to WF. Version 7.7. I am joining DB2 files. I created my master file with dynamic keyed multiple, then try to join a secondary file. I am trying to follow the training manual from 340 Creating Metadata. In GUI secondary file does not have Type for Segment. Also I don't see where I would join the fields from primary file to secondary file. There is conditional join, but I don't think I want conditional join. I change the join from inner to outer join and save. When I go back into view metadata, it has changed back to innder join. I have read through documentation for set all=on but don't understand where to put this. When I view text for segments, there is no join statement. There is a join where, but I don't think I want conditional joins. I read somewhere about data adapter and DB2 files with default values for joins. I am wondering if this could be a problem also, but I don't know how to look at how our data adapter is set up. Help, and thanks, DSparksThis message has been edited. Last edited by: Kerry,
WebFOCUS 7.6 Windows, All Outputs
December 22, 2010, 04:33 AM
Senthilvasan S
The SET command could be used in 2 places while creating the report.
1. This could be given before the TABLE FILE as like SET ALL=ON
2. This also could be used inside the TABLE FILE as ON TABLE SET ALL ON