Most replies will recommend pivot tables. They're close but I think
they're more for predefined columns. So, instead of this:
Account Year Orders
------- ---- --------
1000 2012 10001, 11023, 12700, 13508
2000 2012 1255
you'd get something where each number would be in it's own column. Quite
useful for some applications but not what you want here. This sounds a
lot like Fred Clemens recent post
http://archive.midrange.com/midrange-l/201205/msg00286.html
but I never did hear if he got it resolved.
Hierarchical queries sound close:
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzhierquerycl.htm
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.