Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] outer join changed to inner join in metadata
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] outer join changed to inner join in metadata
 Login/Join
 
Member
posted
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
 
Posts: 1 | Registered: September 22, 2010Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 24 | Registered: April 24, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] outer join changed to inner join in metadata

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