MVSFORUMS.com

JOHNCWL · Beginner Joined: 25 Feb 2004 Posts: 31 Topics: 16

Hi,

I would like to know how to implement recursive SQL in DB2 Version 7. I know that it is not supported in Version7 , But still any other alternate measure???

kolusu · Posted: Tue Mar 16, 2004 9:07 am Post subject:

JOhncwl,

You can implement recursive sql using UDF(User-defined functions). Take a look at this link which explains this in detail.

Expanding Recursive Opportunities with SQL UDFs in DB2 v7.2

You might also read the following article about RECURSIVE sql

http://www-106.ibm.com/developerworks/db2/library/techarticle/0307steinbach/0307steinbach.html

Hope this helps..

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

kolusu · Posted: Tue Mar 16, 2004 9:13 am Post subject:

Ravi,

You are late by 4 minutes Smile

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu