Table File Relationships 1

[grindstonesolutions]

Currently I'm having to perform a "find" within the data dictionary to try and identify which files have a relationship to a Table File. Example: I know that the COMPL_TEXT_CDE (CC Table File) is related to MSF623, MSF693, and MSF700. But there could be other relationships that I'm not aware of. Does anyone know of a way to review all applications that are tied to a table file?

 

[Calator]

I think the 'find' on datadict is not 100% reliable. I have often seen fields in datadict that the software validates against the MSF010 table, however datadict itself has the field flagged as 'DB' - no reference to the table.

I would suggest to use the Unix command "grep" in order to obtain a list of MIMS programs that refer to the respective table, eg:

>cd to directory(ies) where the source code is;

>grep -li "TABLE ('CC')" *

This is based on the idea that TABLE ('CC') is part of a field validation instruction:
EXEC VALIDATE FIELD (field-name)

You may then need to open the source code file and do a find on TABLE ('CC') in order to get to the field which is validated against this table

Once you found the "field-name" then you can determine to which MSFnnn it belongs