Re: Program explosion report

[Dan <dan27649@xxxxxxxxx>]

Wow.  It's examples like this that demonstrate how deficient my SQL
knowledge is.  Just call me Grasshopper.

The list I created manually matches what your UDTF did.

Thank you for sharing this, Jonathan!

- Dan

On Thu, May 7, 2015 at 12:22 PM, Jonathan Mason <Jonathan.Mason@xxxxxxxxxxx>
wrote:

> Hi Dan
>
> I use the following UDTF which produces an indented hierarchical list of
> objects and programs/modules/service programs that call them.  So, for
> example, if PGM3 was called by PGM2A and PGM2B and PGM2B was called by PGM1
> then the result would look like:
>
>     Level  Program
>       1    PGM3
>       2      PGM2A
>       2      PGM2B
>       3        PGM1
>
> The source for the UDTF is shown below:
<snip>