Is there a way to compare the CA Datadictionary definitions, or table layouts, for a database in two different MUFs?

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

Description:

I would like to compare the table layouts for a database in my production Multi-User Facility (called MUF) and in my development MUF. Is there a utility or tool within CA Datacom/DB to do this?

Solution:

Unfortunately, there is no ready utility within CA Datacom/DB that can compare the layouts.

The best process is to export the BTG definitions of the desired table and version from each MUF into a file, and then run a compare utility that you have available in your system against those files. Some compare tools allow filtering of columns or even qualifying records based on a transaction code. With this utility, you will also be able to identify every attribute discrepancy - including comments - and not just length, type and offset changes.

For more information about creating the BTG file and the DDBTGLM program, please refer to the CA Datacom Datadictionary Batch Reference Guide, in the section " DDBTGLM - Generating Batch Transactions."

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