Re: For the SQL gurus: Is this practical? Is it even possible?

["Mark S. Waterbury" <mark.s.waterbury@xxxxxxx>]

Hi, James:

Common Table Expressions are a fairly recent addition to i5/OS DB2, as 
of V5R4.

Here are some references:
   www-03.ibm.com/servers/eserver/iseries/*db2*/pdf/rcte_olap.pdf
and
   www.itjungle.com/fhg/fhg041206-story01.html
and
   www.itjungle.com/fhg/fhg071206-story02.html

Regards,

Mark

> James Lampert wrote:
> Joe Pluta wrote:
>   
> > "Common Table Expression"
> >     
>
> Fascinating.
>
> But I can't find any reference to them in my "DB2 for AS/400 SQL 
> Reference" or my "DB2 for AS/400 SQL Programming" books.
>
> At what release level were they made available?
>
> And can they be used through CLI?
>
>