with Tags: recursion X
SergeRielau Tags: function procedure sql routine sql_pl fibonacci recursion 7 Comments 13,645 Visits
Motivation There are multiple ways in which DB2 supports recursion in SQL. One of which is recursion using the ANSI SQL recursive UNION ALL approach. The other approach is using the CONNECT BY clause. Actually I like to add explanation of recursion into my...
from Blog: SQL Tips for DB2 LUW
A common question is how to obtain a list of all the elements and attributes that occur in an XML document. Producing such a list is what I call “XML profiling” and in a previous blog post I have discussed several SQL/XML queries that can do this. An...
from Blog: The XML Database Blog