Skip to main content

Data Dictionary Conversion

The conversion of a Thoroughbred® data dictionary is a two-step process:

  • The first step extracts the dictionary definitions to a flat text file.

  • The second step reads the text file and loads the data definitions into the PxPlus data dictionary.

The data dictionary conversion process and conversion programs are GETIDDBD and GENDICT respectively.

Step 1: Extract the LINK/FORMAT Definitions

Launch Thoroughbred®, load and run the program GETIDDBD, which is found in the *conv.tbd directory. It will prompt you for the name of the library to process. An output file, tbddict.txt, will be created.

This program will then read the IDDBD file to determine the "LINKs" to convert and output the related file and format information for each.

Step 2: Load PxPlus Dictionary

To complete the conversion of the dictionary, launch PxPlus, then load and run the program "*conv.tbd/gendict". It will prompt you for the name of output file generated in Step 1. This program will read the data dictionary definitions extracted in the first stage and create the PxPlus data dictionary

The Link Name, in the Thoroughbred®, will be used as the data dictionary Table Name. The Library, in the Thoroughbred®, will be used as the Group for the Table.

Thoroughbred® is a registered trademark of Thoroughbred Software International, Inc.