I read through "V5R4 SQL Packs a Punch" http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf
I would need the query in figure 20 and the result in figure 21 which do not show up in the article.
I have a query similar to the example (parts of an iSeries Power5 server) that shows all the levels correctly, however, I must display the top level part of the recursion in every line of the result. (In the example there should be a field "Product" filled with "iSeries Power5 server" in every line of the result.). I must be able to distinguish the parts of different products.
Would you be so kind and post the corresponding T-SQL query?
November 24, 2010 1:36 PM
November 29, 2010 10:33 AM