How to find the keys for a CA Datacom table

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

There is often a need to see the keys associated with a table, along with the fields in that key. The information is readily available from CA SYSVIEW, and from a CXX (Directory) report or a Datadictionary report.

Instructions:

To see the definition for a key in CA SYSVIEW, the easiest method is to:

  1. Issue the ASID mufname command to set the focus on this MUF;
  2. Issue the DCKEYS ### command for the DBID you are interested in reviewing;
  3. Beside the key you want to see, enter the FIE line command. This will present the DCKEYFLD listing of that key.

To see the field definition for all the keys in a DBID, you can

  1. Issue the ASID mufname command to set the focus on this MUF;
  2. Issue the DCKEYFLD ### command for the DBID. This will present the DCKEYFLD screen, showing all the tables and keys in the DBID, along with the fields that make up each key.

 

For a CXX report, you can run a DBUTLTY step using the CXX report function:                              

//SYSIN    DD *
  REPORT AREA=CXX,DBID=###
/*

The CXX report will list all the keys (with their fields) for a table following each table's detailed information.

 

For the Datadictionary report, you can use the DDUTILTY program with this input:

//SYSIN     DD *                      
-USR DATACOM-INSTALL,NEWUSER            
-DEF PATH,PATH1                          
-DEF TRACE,TABLE.KEY,$INTERNAL          
-END                                    
-RPT START,TABLE,<your table name>(PROD),PATH1      
-RPT INDENT                              
-RPT NEST,KEY                            
-RPT FIELD                              
-RPT NESTEND                            
-END                                    
/*                                       

This will list only the particular table you want, using the full table occurrence name, not the short ID. It will list all the keys for that table, along with the definition of the fields that make up that key.

Additional Information:

As always, please contact CA Technologies support for CA Datacom if you have further questions.

***