One of the strengths of WhereScape RED has always been the ability to work in a changing environment; one where source systems as well as user requirements are volatile. In order to identify the impact of changes, most customers use the track back and track forward capabilities. These are available in two places – through the diagrammatical view for table level impact analysis, and through the “Track back on specified column usage” report available from the Reports menu.
Another technique is to use the “Search for string” menu option under Tools. This search allows you to select whether you want to search procedures, scripts and/or tables for a specific string. It will search the meta data for all occurrences of the specified string in the selected objects.
Using the search capability can be the fastest way to see which objects will be impacted by an intended change.