Focal Point
[CLOSED] outer join changed to inner join in metadata

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

December 20, 2010, 04:30 PM
dsparks
[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, DSparks

This 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

Try this...


WebFOCUS 7 6 9
Windows XP
HTML, AHTML, PDF, EXCEL