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