Why are fields in DMLO are displayed with the length doubled and high lighted with asterisks?
Release: All supported releases.
Component: DMLO.
Whenever DMLO recognizes a data exception or invalid data where the data type of the field does not match the data, it highlights the field, marks with an asterisk and displays in in hexadecimal format.
By displaying the field in hexadecimal format, DMLO provides the opportunity to correct the invalid data. With the field displayed in hexadecimal format the length appears to be doubled because there two characters in hexadecimal format to one character in "displayable" format.
Figure 1 an example of the employee record occurrence with the START-YEAR-0415 high lighted with an asterisk with data type N for numeric. The data in this field is X'C1C1' or AA which is invalid for a numeric field. The user can overtype x'C1C1' with the hexadecimal value for a valid two digit year such as x'F0F9' as in figure 2. The field remains high lighted with the asterisk in hexadecimal format until it is modified and re-obtain, at which point it is displayed as in figure 3.
Figure 1:03/26/09........................RECORD : EMPLOYEE...................02 EMP-ID-0415..............................N 0023 02 EMP-NAME-0415............................G 03 EMP-FIRST-NAME-0415.....................A 03 EMP-LAST-NAME-0415......................A 02 EMP-ADDRESS-0415.........................G 03 EMP-STREET-0415.........................A NEW STREET NAME 03 EMP-CITY-0415...........................A NATICK 03 EMP-STATE-0415..........................A MA 03 EMP-ZIP-0415............................G 04 EMP-ZIP-FIRST-FIVE-0415................A 00364 04 EMP-ZIP-LAST-FOUR-0415.................A 02 EMP-PHONE-0415...........................N 8008897142 02 STATUS-0415..............................A 01 02 SS-NUMBER-0415...........................N 019556712 02 START-DATE-0415..........................G 03 START-YEAR-0415.........................N* C1C1 03 START-MONTH-0415........................N 78 03 START-DAY-0415..........................N 05 02 TERMINATION-DATE-0415....................G 03 TERMINATION-YEAR-0415...................N 01 03 TERMINATION-MONTH-0415..................N 00 03 TERMINATION-DAY-0415....................N 00 02 BIRTH-DATE-0415..........................G 03 BIRTH-YEAR-0415.........................N 19 03 BIRTH-MONTH-0415........................N 54 03 BIRTH-DAY-0415..........................N 04 02 FILLER#001...............................A* 0000
Figure 2:03/26/09........................RECORD : EMPLOYEE................02 EMP-ID-0415..............................N 0023 02 EMP-NAME-0415............................G 03 EMP-FIRST-NAME-0415.....................A 03 EMP-LAST-NAME-0415......................A 02 EMP-ADDRESS-0415.........................G 03 EMP-STREET-0415.........................A NEW STREET NAME 03 EMP-CITY-0415...........................A NATICK 03 EMP-STATE-0415..........................A MA 03 EMP-ZIP-0415............................G 04 EMP-ZIP-FIRST-FIVE-0415................A 00364 04 EMP-ZIP-LAST-FOUR-0415.................A 02 EMP-PHONE-0415...........................N 8008897142 02 STATUS-0415..............................A 01 02 SS-NUMBER-0415...........................N 019556712 02 START-DATE-0415..........................G 03 START-YEAR-0415.........................N* F0F9 03 START-MONTH-0415........................N 78 03 START-DAY-0415..........................N 05 02 TERMINATION-DATE-0415....................G 03 TERMINATION-YEAR-0415...................N 01 03 TERMINATION-MONTH-0415..................N 00 03 TERMINATION-DAY-0415....................N 00 02 BIRTH-DATE-0415..........................G 03 BIRTH-YEAR-0415.........................N 19 03 BIRTH-MONTH-0415........................N 54 03 BIRTH-DAY-0415..........................N 04 02 FILLER#001...............................A* 0000
Figure 3:03/26/09........................RECORD : EMPLOYEE....................02 EMP-ID-0415..............................N 0023 02 EMP-NAME-0415............................G 03 EMP-FIRST-NAME-0415.....................A 03 EMP-LAST-NAME-0415......................A 02 EMP-ADDRESS-0415.........................G 03 EMP-STREET-0415.........................A NEW STREET NAME 03 EMP-CITY-0415...........................A NATICK 03 EMP-STATE-0415..........................A MA 03 EMP-ZIP-0415............................G 04 EMP-ZIP-FIRST-FIVE-0415................A 00364 04 EMP-ZIP-LAST-FOUR-0415.................A 02 EMP-PHONE-0415...........................N 8008897142 02 STATUS-0415..............................A 01 02 SS-NUMBER-0415...........................N 019556712 02 START-DATE-0415..........................G 03 START-YEAR-0415.........................N 09 03 START-MONTH-0415........................N 78 03 START-DAY-0415..........................N 05 02 TERMINATION-DATE-0415....................G 03 TERMINATION-YEAR-0415...................N 01 03 TERMINATION-MONTH-0415..................N 00 03 TERMINATION-DAY-0415....................N 00 02 BIRTH-DATE-0415..........................G 03 BIRTH-YEAR-0415.........................N 19 03 BIRTH-MONTH-0415........................N 54 03 BIRTH-DAY-0415..........................N 04 02 FILLER#001...............................A* 0000