Analyzing Recursive Data with SQL

  Application #2
  Kungsholmen 2
  Jun 14, 2021

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

Birgitta Hauser

Software & Database Engineer, Toolmaker Advanced Efficiency GmbH

Read more