On Tue, Jan 04, 2005 at 05:54:04AM -0500, D. Richard Hipp wrote:
> One stubling block with recursive triggers is that a recursive
> trigger can result in an infinite loop. I sent out a query a
> month or so ago requesting ideas on how to detect and deal with
> infinite loops in recursive triggers. I got a few helpful
> responses. More input would be appreciated.
Graeme Birchall has an excellent book (The DB2 UDB Cookbook) available
for download. It has an entire chapter dedicated to DB2's Recursive SQL
and one section of it is "Halting Recursive Processing". Maybe it will
provide some insight.
http://ourworld.compuserve.com/homepages/graeme_birchall/HTM_COOK.HTM
enjoy,
-jeremy
--
========================================================================
Jeremy Hinegardner [EMAIL PROTECTED]
