I have been trying to find a way to allow our analysts to look for element references in RAA starting with a field/data element as defined in a copybook. We make heavy use of the REPLACING option, so we have many Symbols and/or Data Elements related to a single copybook field. Symbol search and Element search return data elements by program, not so easy to filter to copybook from those results. Looking for an easy way to get field-level impact to code members. For example, given field 'XXX'-ACCT-NO in copybook MASTFILE, how and where is this field referenced. Ideally, would like the query to return: count of the # programs where the element is referenced directly but not modified (ignore reference to parent elements); count of # programs where the element is referenced directly in a statement that modifies it; count of # of programs that the element is available in but never referenced/modified.
From that point, it would be useful to be able to drill down into the statement details for References and Modifications, similar to the data you see on the Data Element Details page.
This has been a difficult task due to the RAA data model. In addition, our database contains 42.5 million data elements and 4.3 million symbols.
Wondered if anyone else has attempted to tackle looking at data elements this way?