Is there a way to compare the Datadictionary definitions, or table layouts, for a database in two different MUFs?
Article ID: 18807
Updated On:
Products
Issue/Introduction
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?
Resolution
Unfortunately, there is no ready utility within 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 Datacom Datadictionary Batch Reference Guide, in the section " DDBTGLM - Generating Batch Transactions."
Feedback
