In the example that follows, I am receiving an incorrect result set in the View. I am looking to get the FULL result set from View_LY and Table_TY. Instead, this View is returning the Common (Equi) records and records on Table_TY only. Missing the records on View_LY only. Any known problems with FULL OUTER JOIN in DB2 or am I missing something. Documentation all around is somewhat limited:
View: View_LY
Store (PK)
...
brunodamato
Last Activity: Aug 24 '07, 03:40 AM
Joined: May 23 '07
Location:
-
Incorrect results using FULL OUTER JOIN in DB2 v8
-
Range Partitioning
I have 2 questions regarding DB2 9's Range Partitioning.
1. Do the Partition fields have to reside on the table being Partitioned? We have a Fact table we would like to Partition and the Week identifier resides on the table. This identifier's parent Dimension table has a month value. In order to Partition the Fact table by month, somehow the Dimension table would need to be referenced.
2. The Fact table mentioned...
No activity results to display