41 Understand the Data Dictionary Structure
This chapter contains the topic:
41.1 Understanding the Data Dictionary Structure
Eight separate files comprise the Data Dictionary Repository.
The following diagram illustrates the relationships between these files.
This is the master file for the Data Dictionary. Every data item has a record in this file.
Data Field Specifications (F9210)
This file contains database fields, which is a glossary group of "D" or "S," work fields, glossary group "U," and categories, glossary group "C." This file contains the base display and validation rules for all file and data items. It also contains the "C" aliases.
Data Field Display Text (F9202)
This file lets you define multiple row descriptions and column titles for each data item, based upon language, or reporting system, or both. You can add a language value for each language translation required for the row description and column title. The reporting system code allows the entry of jargon or company terminology.
Data Item Alpha Descriptions (F9203)
This file contains the alpha and compressed descriptions for all data items. This allows you to perform a Data Dictionary search by description. You can also specify separate alpha descriptions by language preference and reporting system. Every data item has a record in this file.
This file contains only database fields, which are in a glossary group of "D" or "S." This file contains COBOL aliases for each data item.
Error Message Program ID (F9207)
This file contains error messages that have a program, screen, or report ID attached to them. You exit to this program, screen, or report when you receive the error. For example, if you receive a user defined code error, you could exit to the User Defined Code Revisions program to modify a value.
This file contains the glossary text for every data item. Each line of text in the glossary is one record.
This file contains key information to link the data items to their glossary and to specific items.