How to determine if any CA Ideal programs access a certain Datacom Table?

Document ID : KB000022344
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

How can I identify any CA Ideal programs which access a certain Datacom Table?

Answer:

Using the CA Datacom DDUTILTY batch utility, run a Datadictionary path report for Table --to-- Element --to-- Dataview --to-- Program using the following control statements. Since CA Ideal Programs require a Datadictionary relationship to a Dataview, this would be the conclusive way to determine if the Table has any connection to CA Ideal programs.

-USR user,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,table(PROD),PATHX
-RPT INDENT

Here is a sample output for the path report for a Table named "PAYROLL" which shows one Dataview and three related Programs.

Note the Program names start with "I$", another indication that they are CA Ideal Programs:

Date: 02/23/2015  Time: 16.10.16      *********************************************************          Page:        1
                                       *  Advantage CA-Datacom Database Datadictionary Option  *
 Security Level: 1                     *                  Maintenance Report                   *          Version: 14.0
                                       * Copyright 2004 Computer Associates International, Inc.*
 User: DATACOM-INSTALL                 *********************************************************          DD Base:     2
 
               *-----------------------------------------------------------------------------------*
               *  CODE USER-NAME,PSWD,DATABASE-ID                                                  *
               *  -USR DATACOM-INSTALL,*******                                            ;  PROC  *
               *-----------------------------------------------------------------------------------*
 Date: 02/23/2015  Time: 16.10.16      *********************************************************          Page:        2
                                       *  Advantage CA-Datacom Database Datadictionary Option  *
 Security Level: 1                     *                    Utility Report                     *          Version: 14.0
                                       * Copyright 2004 Computer Associates International, Inc.*
 User: DATACOM-INSTALL                 *********************************************************          DD Base:     2
 
 -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                                                                    ;
 Date: 02/23/2015  Time: 16.10.16      *********************************************************          Page:        3
                                       *  Advantage CA-Datacom Database Datadictionary Option  *
 Security Level: 1                     *                    Utility Report                     *          Version: 15.0
                                       * Copyright 2004 Computer Associates International, Inc.*
 User: DATACOM-INSTALL                 *********************************************************          DD Base:     2
 
 -RPT START,TABLE,PAYROLL(PROD),PATHX                                    ;
 -RPT INDENT                                                             ;
 Date: 02/23/2015  Time: 16.10.16      *********************************************************          Page:        4
                                       *  Advantage CA-Datacom Database Datadictionary Option  *
 Security Level: 1                     *                   Indented Report                     *          Version: 15.0
                                       * Copyright 2004 Computer Associates International, Inc.*
 User: DATACOM-INSTALL                 *********************************************************          DD Base:     2
 ENTITY-TYPE...................   OCCURRENCE....................................................... S VERS *DATACOM/DB *
                                     DESCRIPTION...................................                        NAME  ID  USE
                                        SQLNAME............................................
 
 TBL                              PAYROLL                                                           P 0001 PAY   001 N
                                     PAYROLL MASTER FILE
                                        SYSUSR.PAYROLL                                                               I A
    KEY                           PAYROLL.NUMBER                                                    P 0001 EMPNO 001 M N
                                     EMPLOYEE NUMBER
                                        SYSUSR.EMPNO_PAY00001
    ELM                           PAYROLL.ACTIVITY-CODE                                             P 0001 PYIDT
                                     EMPLOYEE NUMBER ELEMENT
    ELM                           PAYROLL.FIGURES                                                   P 0001 FIGSS
                                     EMPLOYEE PAY FIGURES
    ELM                           PAYROLL.RECORD                                                    P 0001 PAYRC
                                     EMPLOYEE PAYROLL RECORD ELEMENT
       DVW                        PAYROLL                                                           P 0002
                                     IDEAL SAMPLE DATAVIEW
          PGM                     $ICOLEMPTEST                                                      T 0001
          PGM                     $ISOLID#2976                                                      T 0001
                                     GETIT/GSETL
          PGM                     $ISOLID#2976                                                      T 0002
                                     GETIT/GSETL
                                         *-- E N D  OF  J O B  - N O  E R R O R S  F O U N D --*

Additional Information:

Refer to the CA Datacom Datadictionary Batch Reference Guide, "Chapter 10: DDUTILTY - Producing Reports and Source Language Statements"

https://support.ca.com/cadocs/7/CA%20Datacom%20V15%200%20Customer%20Access%20Only-ENU/Bookshelf_Files/PDF/DatacomDD15--Batch_Ref_ENU.pdf