Creating a field listing and COBOL copybook for Datacom tables

Products

• Datacom
• Datacom/AD
• Datacom/DB

Issue/Introduction

When researching field usage or the impact of field changes within a table, it is helpful to have a comprehensive overview of the data definitions in use. For example, you might want to know how the customer number is defined in every table, or you might want to know what the actual field name is for every date field. In addition, you might want to generate copy members for COBOL that can be used to reference this table data.

Environment

Component : Datacom/DB

Component : Datacom/AD

Resolution

There are many ways to retrieve field information fields for tables within the Datacom Datadictionary. Attached is a job that runs against the Datadictionary for selected tables and can produce the following:

1. A field report from Datadictionary, showing the position within the table, field length, and other basic attributes.
2. A series of COBOL copy members, with the fields and their associated PICTURE and other clauses.
3. A report showing the parent database name and DBID for every selected table (if the relationship exists).

There are instructions within the job to identify which reports you want to run, the selection criteria for the reports, and the various files to be created within the job to hold the reports and other intermediate data.

As with all samples provided, you are free to use and customize this job as needed, 

Additional Information

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