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.
To see the definition for a key in CA SYSVIEW, the easiest method is to:
To see the field definition for all the keys in a DBID, you can
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.
As always, please contact CA Technologies support for CA Datacom if you have further questions.
***