Enhance program call graph to not show unused Db2 calls referenced by commented PERFORM statement.

Currently in AD v6.0.1 program call graph shows unused SQL call statements of select/insert/update/delete from sections or para even if the calling PERFORM statement was commented out. Ideally those SQL calls are considered as dead codes as it will not execute in real-time but AD statically analyze those sources and considered them as valid SQL calls resulted as wrongly represented in the graph. Two ways of handling this issue.

1. From appl. aspect user should delete unwanted dead codes from the assets so AD won't show wrong presentation of SQL references in the program calls. This part we do agree.

2. Another option is, to improve the current feature of call graph to not consider dead SQL calls when the calling procedure is commented or not called.

Example:

Pgm1:

---

---

PROCEDURE DIVISION.

--

**** PERFORM XX1 (Commented out)

--

--

XX1 SECTION.

INSERT DB2X.TBL1 INTO VALUES (X,X,X,)

UPDATE DB2X.TBL2 SET COLX = 'XX' WHERE CONDITION..XX

XX1-EXIT.

   EXIT.

Result from Application Discovery call graph:

1. Both Table TBL1 and TBL2 are considered as valid SQL references, that is wrong.

Note:

In the above particular scenario standalone dead code analysis report 'unused routines within program' correctly captured XX1 section as unused but it doesn't work in conjunction with program call graph altogether. We see there is a scope for improvement so registered idea after checking with our IBM representative SPOC.