How do I find join index that references specific objects

Database
Enthusiast

How do I find join index that references specific objects

I'm trying to create a DROP/CREATE script for JI's to execute before/after daily batch jobs. The DROP statement needs to contain the databasename.jiname of any JI's that reference one, or more tables in the production database. This is a problem if the JI is in another database than the object(s) it references and has the same name as another JI. I can get the objects that are referenced from dbc.indexes and the databasename.jiname from dbc.TVM but I don't know how to join those two tables.
1 REPLY
Enthusiast

Re: How do I find join index that references specific objects

I opened up an incident and was told this is not available in v2r6. It is available beginning td 12 via a new column called, .JoinIndexTableID (in dbc.indexes?).