Skip to content

Maintain Codes View

The core functionality of this maintenance tool is the view labeled Maintain Code Files. The data entry view is split into two groups.

Code Types

This first group is also called the header or codetype group. You can browse and select a codetype record via a record selection dialog (F4 / Prompt button) or enter a completely new one.

You can modify the description and comments for this code record. The purpose of the description and comments columns is purely documentation, as they are not used in any programmatic area by default.

When you select an existing codetype record, the bottom part of the dialog (the datagrid) fills itself with the first N records of the table CodeMast.

Code Master

You can only access this section when an existing codetype record has been selected. If you are creating a new record or altering an existing one, the maintenance program will prompt you to confirm the save. In the datagrid, you can enter a virtually unlimited number of codes per codetype record. Each code (maximum of 10 characters) must be unique within the codetype code.

The maintenance program does not know where (in which DD) you use the codes. Therefore, the tool cannot assist you with:

  • Checking if the code length is valid. For example, when the length of the destination code column (e.g., orderhea.terms) is less than the code you enter, there will be a mismatch, and the correct code might not be found in real time.

  • Validating if a child record exists. When you delete a record, no checks will be performed to see if the code was in use.

  • Validating if the code was in use. When you alter a code via the tool (or via Database Builder), be aware of the possibility that the code was already used in the system, which may result in a situation where the description can no longer be found.