Determining if any Ideal programs access a certain Datacom Table

Products

• Datacom
• Ideal

Issue/Introduction

This article provides a way to obtain a list of all programs that access a certain Datacom table.

Environment

Ideal 15.1 

Datacom 15.1 

Resolution

Run Datacom Datadictionary batch utility DDUTILTY with following SYSIN cards:

-USR name,password                        
-DEF PATH,PATHX                           
-DEF TRACE,TABLE.KEY,$INTERNAL            
-DEF TRACE,TABLE.ELEMENT,$INTERNAL        
-DEF TRACE ELEMENT.DATAVIEW,$INTERNAL     
-DEF TRACE DATAVIEW.PROGRAM,PGM-DVW-USE   
-DEF TRACE PROGRAM.PROGRAM,PGM-PGM-CALL   
-END                                      
-RPT START,TABLE,yourtable(PROD),PATHX    
-RPT INDENT                

Additional Information

Note that Program names starting with "$I" are Ideal Programs. The next 3 characters after $I indicate the Ideal system name and then follows the Ideal program name.

This is a sample report that has been run on table PAYROLL :

For documentation, see DDUTILTY - Producing Reports and Source Language Statements