On Tue, Jan 20, 2009 at 9:39 AM, <don.walt...@falconjet.com> wrote: > I am running DB2 v9 on AIX 5.3.0.0 with perl 5.8.2 and I'm having a > problem with a recursive script which is shown below. > > sub Recursion {
I was thinking that what you probably really want is Oracle's "CONNECT BY" clause so that you wouldn't have to have a recursive function, and all the work would be in the database instead of perl, and in an effort to see if DB2 had anything similar, I found this: http://bytes.com/groups/ibm-db2/183346-how-convert-oracle-sql-connect-db2-sql HTH, Douglas Wilson