Articles & Content
Topic: Cross Platform DB2 for z/OS & LUW
DATE: 2005-10-25 (08:30 - 09:30)
SPEAKERS: Peter Backlund (Peter Backlund DB2-Konsult AB)
Table expressions have existed long in DB2. In DB2 for z/OS only the Nested Table Expression (and its less wellknown variation Correlated NTE) has been available. With V8 of DB2 for z/OS also the Correlated Table Expression was made available. The CTE is valuable itself, but is also a prerequisite for Recursive SQL, which canm be used to solve Bill-of-Material problems. The presentation will give a technical overview and alsodiscuss performance and practical examples.
EXP. LEVEL: Intermediate,Advanced
NTE - Nested Table Expression
CTE - Common Table Expression
Practical Examples of Recursive SQL
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.