I have noticed this happen a few times so I wanted to put it out there and see if anyone else had noticed the same thing.
I’m working with DB2/Universe Design 4.1.6.
I have a lot of outer joins and they work fine.
Until I get to the complex outer join.
When I create a join with a single field I select the outer join. When I add the second field (for the complex join) it appears to switch which table my outer join is actually applied to!
When I look at the SQL that is generated it puts the outer on the opposite table that I selected it to be on.
I have noticed this happens sometimes too. I just manually change it in the expression box. I save it and reopen to make sure the changes really saved.
I feel like I’m losing my everlovin’ marbles! This join will NOT do what I tell it to do…
I want an outer join on
RC_BASIC_EMPLOYEE_DATA.EMP_NO=RC_EMPLOYEE.EMP_NO
Everytime I create it and export the universe I go in to the report and look at the sql generated and I get
LEFT OUTER JOIN REPCENTER.RC_EMPLOYEE ON (REPCENTER.RC_EMPLOYEE.EMP_NO=REPCENTER.RC_BASIC_EMPLOYEE_DATA.EMP_NO)
Anybody have any suggestions?
I have another universe with the exact opposite join in the universe that generates the same SQL. I have different reports. One the outer join needs to be on EMPLOYEE and the other requirements if for the outer join needs to be on .RC_BASIC_EMPLOYEE_DATA
I’m using Universe Design Tool 14.1.6.1805 with DB2.
At the bottom you will see the box on the right that says “Edit”. You can change them there. I’ve found that if I have a complex join it seems to work better to create two separate joins.
I’m still having issues though…but it’s not a 100% do the opposite kind of thing!
(BOB member since 2002-07-10)
(BOB member since 2002-07-10)