Expanding Recursive Opportunities with SQL UDFs in DB2 v7.2

From the developerWorks archives

Srini Venigalla

Date archived: January 13, 2017 | First published: March 01, 2002

Recursion is an extremely efficient technique to resolve tree-like relationships. In relational databases, tree-like models are used to represent data for Bill of Materials (BOM), document hierarchies, and organizational structures. This article solves a complex problem involving multiple data hierarchies by combining recursive SQL with SQL user-defined functions.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=14100
ArticleTitle=Expanding Recursive Opportunities with SQL UDFs in DB2 v7.2
publish-date=03012002