RE: Need ideas for SQL join select to replace logical view

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

CTE stands for Common Table Expression.  Here's a link explaining what
recursive CTE is:

http://www-03.ibm.com/systems/i/software/db2/pdf/rcte_olap.pdf

Elvis

RPG & DB2 Summit | Minneapolis | October 1-4
Mike Cain - DB2 for i5/OS Temporary Indexes - The Good, The Bad, The Ugly
October 16 
2007 System i Fall Technical Conference | Orlando | November 4-7
Celebrating 10-Years of SQL Performance Excellence on IBM System i, eServer
iSeries and the server affectionately known as the AS/400 

-----Original Message-----
Subject: RE: Need ideas for SQL join select to replace logical view

I am not familiar with the acronym "CTE."  Could you explain please.