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

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