× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. September 2006

RE: SQL recursion


Yeah, I've found citations for recursive queries as far back as the 80's.
There are different ways to do it.  For example, the preferred method in SQL
Server 2000 is the recursive stored procedure call.  The ANSI standard for
recursion is the recursive CTE which was introduced in SQL-99 which has been
taken up at varying rates by different databases.  Recursive CTEs didn't
make it into the Microsoft product line until SQL Server 2005, and didn't
make it into DB2 for z/OS until V8.

Joe


From: R Bruce Hoffman

One text that I have found to have a clear explanation on the recursive
query in particular is "Using the New DB2" by Don Chamberlin. It may be
dated, but recursion was in the LUW stuff as far back as 1996 or 95. He
is one of the creators of the SQL language and was still working with
DB2 UDB for IBM as late as 1996.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.