|
Sounds like you want a recursive query (aka recursive common table
expression (v5r4))...
At 7.1 you even have the CONNECT BY clause available to do recursion
without the CTE...
https://www.mcpressonline.com/analytics-cognitive/db2/techtip-db2s-connect-by-simplifies-recursive-processing
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.