Main Menu

Home Webcasts Upcoming Webcasts

Upcoming Webcasts


Analyzing Recursive Data with SQL (FREE FOR MEMBERS)


by Birgitta Hauser, Toolmaker GmbH

Thursday, April 2, 2015 • 12:00 pm Central Time


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.


Learning Objectives: In this session you’ll learn how recursive data must be stored in database tables/files and the methods (Recursive Commont Table Expressions and Hierarchical Query Clause) to be used to analyze them.


Audience: Developers and Users who are experienced in SQL Queries and need to evaluate recursive data or simply want to enhance their SQL know-how.


About the speaker:

Birgitta Hauser has been a Software Engineer since 2008, focusing on RPG, SQL and Web development on System i/Power i at Toolmaker GmbH in Germany. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. Before joining Toolmaker, she was responsible for the complete RPG, ILE, and Database programming conceptions for a software house with its own Warehouse Management Software Package. She also works in consulting and education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON user groups in Germany, Switzerland and USA. In addition, she is co-author of two redbooks and also the author of several papers focusing on RPG and SQL for IBM Developer Works and a German magazine. 



COMMON Requirements

Welcome to COMMON’s Requirements Portal, your resource to share and enhance the IBM i and AIX operating systems by submitting feature requests and requirements to IBM. Part of COMMON’s advocacy efforts, this is your opportunity to make the operating system better for the entire community and provide a voice to IBM.

COMMON 2015 Buyer's Guide

Your 2015 guide to the latest products and services from leading Power Systems solution providers.