Loyd Goodbar wrote:
What you want looks like something similar to pp. 407-410 in Graeme
Birchall's DB2 SQL Cookbook. I checked in the latest version, for DB2
9.5. That example should work in V5R4 SQL.

You can get Graeme's e-book (free) from his website:

> Also, take a look at pp. 405-407, Denormalize Normalized Data may be more
> straightforward.

Thanks Loyd, those were both very interesting to look at, and I think this e-book will be a valuable resource for future reference. Combining some of the techniques of those two examples should give me what I'm after.

Thanks again,

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact