RE: SQL recursion

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

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.