Articles & Content
Archives
NTE, CTE, and Recursive SQL (F06)
Topic: 2005 EU
Subtopic: 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
OBJECTIVES:
NTE - Nested Table Expression
Correlated NTE
CTE - Common Table Expression
Recursive SQL
Practical Examples of Recursive SQL
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!
Download File
Click to Download
Download File
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.
