How to query to get program overrides for a Model in CA 2E.

Products

• CA 2E

Issue/Introduction

We are looking for a query by which we can identify those programs created in CA2E Model which has override added for TGTRLS parameter. 

Environment

CA 2E 8.7.3

Resolution

This below query will list out all the functions which have compiler over ride of TGTRLS:

select OBJNME as FUNCTION_NAME , OBJOWN as                          
FILE_NAME_OF_THE_FUNCTION , IMPNME as                              
IMPLEMENTATION_NAME_OF_THE_FUNCTION from YMDLOBJRFP where @@OBJ in  
( select @@MSG from YMSGSECRFP where SECLVL like '%TGTRLS%' )      

Alternatively, One can also search the generated source members by using option "25=Find string" in "IBMi Work with Members Using PDM" screen.