Fields in DMLO are displayed with the length doubled and high lighted with asterisks.
Article ID: 44119
Updated On:
Products
Issue/Introduction
Question:
Why are fields in DMLO are displayed with the length doubled and high lighted with asterisks?
Answer:
Whenever DMLO recognizes a data exception or invalid data where the data type of the field does not match the data it high lights the field, marks with an asterisk and displays in in hexadecimal format.
By displaying the field in hexadecimal format DMLO gives you an 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. You 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
Additional Information:
DML Online User Guide
Environment
Component:
Feedback
