In this session you'll learn how recursive data must be stored in database tables/files and the methods to be used to analyze them.
According to the SQL Standard, hierarchical (e.g. organization charts, bill of materials) or bi-directional data (e.g. flight connections) can be evaluated by using a recursive common table expression (RCTE). RCTEs were integrated with release V5R4 into DB2 for i. Other databases such as Oracle use a non-ANSI SQL Standard method for querying data called hierarchical query clause. To allow maximum portability the hierarchical query clause is introduced with PTF SF99701 Version 9 in DB2 for i. This session will show you both methods in depth.
Speaker: Birgitta Hauser, Toolmaker Advanced Efficiency GmbH
Session Handout: 31d Recursive Queries - Final.pdf
Back to the sessions