File Management Software
|
Data Dictionary Search |
Last Revised: 06/08/14 |
This program can be used to search the Data Dictionary.
Options include:
Option 1 - Display where field name is used
This option can be used when you need to find all places that a particular field name is used. You can enter a field name, starting characters of a field name, or just touch F2 to select from a list of all field names in alphabetical order, as shown in the screen shot below.
| Option 1 Example |
|
| Example of search results |
|
Option 2 - Display where external program name is used
Touch F2 at the "Enter program name" prompt to display all external programs found in the data dictionary. The Typ column indicates the external program type.
| External Program Types | |
|---|---|
| Typ | Description |
| T | Template based external call, linked to a field |
| X | External routine compatible with the older file maintenance, deprecated yet still supported. Use T type for any new external routine. |
| C | Original external routine compatible with the older file maintenance, deprecated yet still supported. Use T type for any new external routine. |
| V | View or field level view validation routine |
| F | File Maintenance Add/Write/Delete routine |
| Option 2 Example |
| F2 entered at program name: |
|
|
|
Option 3 - Display where file is used for file verification
You may enter a specific file name (including the company code or XX) or touch the SpaceBar to display all files used for verification.
| Option 3 Example |
|
Option 4 - Display fields that call external program
You may include one or more external program types, T, X, or C. The result is sorted by external program name.
| Option 4 Example |
|
Option 5 - Display/Rename/Delete orphan notepad text
When a field is deleted using Data Dictionary Maintenance, it can be pasted into a different location within the data structure. As a result, the notepad text associated with that field name is not automatically deleted. When a field is renamed, any existing notepad text probably should be renamed as well. This process can result in notepad text that refers to a field name that has been deleted. This option can be used to list any orphan notepad text, to display the text, and to delete individual notepad text entries. It also provides an option to delete all orphan notepad text.
When exiting Data Dictionary Maintenance, there is also an option to rename the notepad text to another field that has not been deleted.
| Option 5 Example |
|
|
Option 6 - Display missing or invalid links
It is possible by deleting or changing a data dictionary to have a field that links to a field that has been deleted. This option can be used to locate these problems. Use Data Dictionary Maintenance to resolve.
| Option 6 Example |
|