By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,071 Members | 1,244 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,071 IT Pros & Developers. It's quick & easy.

common table expressions

P: n/a
It suddenly matters, but I don't have much old docs. When, on LUW, did
CTE support appear? I'm certain by v7, but was it earlier?

thanks,
robert
Jan 4 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
MeBuggyYouJane wrote:
It suddenly matters, but I don't have much old docs. When, on LUW, did
CTE support appear? I'm certain by v7, but was it earlier?
When I was a student working on DB2 V5.1 it was already there.
Starburst had CTE using different syntax.
My best guess is that CTE's were introduced when Starburst was merged
into DB2 V2 (DB2 Common Server)

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Jan 4 '08 #2

P: n/a
On Fri, 04 Jan 2008 12:11:01 -0000, Serge Rielau <sr*****@ca.ibm.com>
wrote:
MeBuggyYouJane wrote:
>It suddenly matters, but I don't have much old docs. When, on LUW, did
CTE support appear? I'm certain by v7, but was it earlier?
When I was a student working on DB2 V5.1 it was already there.
Starburst had CTE using different syntax.
My best guess is that CTE's were introduced when Starburst was merged
into DB2 V2 (DB2 Common Server)

Cheers
Serge
I too recall playing with the "WITH" syntax in DB2 v5 for LUW, which was
the first version of DB2 I ever played with. I also vaguely recall
something about v5 being the first version for LUW... is that correct?
Unfortunately I don't recall if the recursive capabilities of CTEs were
present in v5 (or v6 which I only touched briefly - recursion was
definitely there in v7 for LUW).

Cheers,

Dave.
Jan 4 '08 #3

P: n/a
Dave Hughes wrote:
I too recall playing with the "WITH" syntax in DB2 v5 for LUW, which was
the first version of DB2 I ever played with. I also vaguely recall
something about v5 being the first version for LUW... is that correct?
Unfortunately I don't recall if the recursive capabilities of CTEs were
present in v5 (or v6 which I only touched briefly - recursion was
definitely there in v7 for LUW).
That's stuff that Blair would know...

I do know (make myself believe?) that DB2 CS was the first version of
DB2 that worked on Unix and OS/2 (at least). DB2 V5 worked on Windows
for sure. I'm not sure when Linux came in... DB2 V7 was the last release
with OS/2 support.
DB2 V1 was OS/2 only .. so the tale goes anyways...long before my time.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Jan 4 '08 #4

P: n/a
Serge Rielau wrote:
I do know (make myself believe?) that DB2 CS was the first version of
DB2 that worked on Unix and OS/2 (at least). DB2 V5 worked on Windows
for sure. I'm not sure when Linux came in... DB2 V7 was the last release
with OS/2 support.
DB2 V1 was OS/2 only .. so the tale goes anyways...long before my time.
I remember that at least V5.2 run on Linux.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jan 6 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.