Identify parent of

[#1]

I have a table of all the program references in our live AS/400 environment, and it looks something like this:

Program Reference + umpteen other less important fields

Pgm A Pgm B
Pgm B Pgm C
Pgm B Pgm D
Pgm C Pgm E
Pgm D Pgm F
Pgm E Pgm F

Is there a way of manipulating the load so that I can display the highest level parent for any selected program? For instance if a user selects Pgm C I want to immediately be able to display Pgm A (Pgm C is called by Pgm B which is called by Pgm A).

[hector · Accepted solution]

Hi, check this model and see if it works for you

rgds

[rwunderlich]

The HIERARCHY LOAD function will do this nicely.

-Rob

[#4]

Many thanks for your help.