Articles & Content


Using DB2 UDB V8 Recursive SQL on all Platforms (F13)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2005

DATE: 2005-10-26 (09:00 - 10:30)
SPEAKERS: Daniel Luksetich (Yevich, Lawson and Associates)

With version 8 of DB2 UDB for OS/390 and z/OS, recursive SQL will be available on every platform. This very powerful SQL construct can be utilized to quickly solve many business functions. This presentation introduces DB2 recursive SQL, and its many uses. From traversing hierarchies, loops, and networks, to generating test data and statements, the very simple to the most extremely complex will be addressed.

EXP. LEVEL: Intermediate


Introduction to Recursion

Using Recursion to Solve Business Problems

Complex Recursive Examples

Using Recursion to Generate Data

Using Recursion to Generate Statements

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.