SQL Queries - CAST Knowledge Base - Queries on objects - How to List the Calling and Called Objects

These queries provide a list of objects calling another object or being called by another objects. This output can be useful in metrics such as fan-in (calling objects) or fan-out (called objects).

In other words, if routine A calls routine B then routine A is the caller and routine B is the callee. i.e. the caller is the routine which is calling the callee.  

Routine A is the calling object and routine B is the called object.

Calling Objects

For the query below, please provide a search string for the calling object(s) (CALLING_OBJECT in the query below):

SELECT *
FROM   OBJFULNAM
WHERE  IDOBJ IN
       ( SELECT IDCLR
       FROM    ACC
       WHERE   IDCLE IN
               (SELECT IDOBJ
               FROM    OBJFULNAM
               WHERE   fullname LIKE '%CALLING_OBJECT%'
               )
       );

Called Objects

For the query below, please provide a search string for the called object(s) (CALLED_OBJECT in the query below):

SELECT *
FROM   OBJFULNAM
WHERE  IDOBJ IN
       ( SELECT IDCLE
       FROM    ACC
       WHERE   IDCLR IN
               (SELECT IDOBJ
               FROM    OBJFULNAM
               WHERE   fullname LIKE '%CALLED_OBJECT%'
               )
       );