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

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

Wrong!
CTEs were introduced in Release V4R4 much earlier than sub-selects which
were introduced in release V5R1.
That are recursive CTEs which are introduced with release V5R4

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Mark S. Waterbury
Gesendet: Friday, November 02, 2007 22:49
An: Midrange Systems Technical Discussion
Betreff: Re: For the SQL gurus: Is this practical? Is it even possible?


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?