TechTip: Full Outer Joins on DB2 for i5/OS

[J.Pluta]

TechTip: Full Outer Joins on DB2 for i5/OS

Thanks, Tom. Exchange of ideas is always a good thing, even if it gets a little contentious, as long as you stay on topic and away from personal statements. Joe

[Guest.Visitor]

TechTip: Full Outer Joins on DB2 for i5/OS

Has anyone considered, tried, discarded, liked, etc, FETCH LAST to get the last row in the cursor, then done FETCH PRIOR to read backwards? Sam

[MCWebsite.Staff]

TechTip: Full Outer Joins on DB2 for i5/OS

** This thread discusses the Content article: TechTip: Full Outer Joins on DB2 for i5/OS **0

[WoofDog]

TechTip: Full Outer Joins on DB2 for i5/OS

Brian, It appears that your report would have been much like the one discussed in this blog entry: http://weblogs.sqlteam.com/jeffs/arc...ter-Joins.aspx It describes a different approach to the problem and may be of interest to you as well. I have found it to be most interesting and informative.