To find all the programs in a data set which Update table 'A'.
Current Solution -
1. Search all the programs of the data set for the table name.
2. From the result set of step 1 search programs having string ' UPDATE '
3. From the result set of step 2 -> Manually find all the programs Updating Table 'A'.
Desired Solution -
In a single utility I should get a list of programs pdating table 'A'.
I tried Search utility but couldn't find anything of my use.
Please let me know if anyone has developed a code for this amd also excuse me if this has already been answered or is a naive question. But my team needs this urgently.
SRCHFOR searches in 'OR' mode.
For example if I have two strings 'ABC' and 'DEF', then with multiple Strings option SRCHFOR will give (as per my knowledge) me programs containg 'ABC' OR programs containg 'DEF' in one go.
I need programs containing 'ABC' AND 'DEF'
Also I need a code/utility for general string search (Not resticted to DB2, was just an example).