Articles & Content


NTE, CTE, and Recursive SQL (F06)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2005

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

Correlated NTE

CTE - Common Table Expression

Recursive SQL

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.