Articles & Content
Topic: 2005 EU
Subtopic: Cross Platform DB2 for z/OS & LUW
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
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.