Objects linkage information in repository tables

[Former Member]

Hi All,

I am trying to create a report which lists down all the objects in a job right down to the table level.

I have been able to find Parent-Child relationships in AL_PARENT_CHILD in the repository table.

However, the linkage between child objects isn't available.

Which table does provide this information, and how do we read it?

Thanks,

Bhupendra

[Former Member]

Any ideas, anyone?

[mageshwaran_subramanian]

Here you go

[Former Member]

Magesh,

Thanks for the link.

I already have achieved the Job-->Workflow-->Dataflow-->Table information from AL_PARENT_CHILD table of the repository.

However, I am looking for information about the position of each component within objects.

Thanks,

Bhupendra

[aasavaribhave]

you will find most of that information in AL_LANG and AL_LANGTEXT table, please do not alter it any ways and that will corrupt your repository.

You can export a job to atl\ XML which will also have all that information. e.g. all dependents - DF\WF\datastores-tables etc.

[Former Member]

Thanks Aasavari.

Is there any other way to find the linkage information?

The data in these two tables is actually the ATL of the individual objects.

I am precisely looking to get that information in an organized format.

Anyway we can achieve it?