Displaying Conversion Errors

Data Converter stores errors encountered during conversion in a conversion error file.  The conversion error display function displays errors using an external viewer program (the default is a Notepad) specified by an environment setting. àConversion Error File
àEnvironment Setup
Example of a Conversion Error File (SAMPLE.ERR)
*** Data Converter conversion error file ***
  Current Folder_: V:\HOME\MDPORT32\TEST
  Input File : DATA1.DAT
  Layout definition file : DATA1.LAY
  Conversion error count : 2

[Code Conversion Error] Number of occurrences indicated in ()  (*)more than 100
0000(1)

[Error Items] Item No : Item name : Attribute (Number of errors occurred; "*" than 100)
3:Product name:N( 1)
5:Sales volume:Z( 1)

[Error Details] Record number-Position Error contents Item No : Item name : Attribute
3-23 Code Conversion Error (0x0000) 3:Unit price:Z
4-46 Numeric part error  5:High sales:Z

[Code Conversion Error] List of character codes that caused code conversion errors.  For Unicode, UCS2 Big Endian is displayed regardless of type (UCS2/UTF8) or Endian.
Format Hexadecimal-character-code (number-of-occurrences)
[Error Items] List of items that contained conversion errors (data file conversion only)

Format Item-No- in-layout-definition : Item-name :Item-attribute (Number-of-errors)
[Error Details] Provides a detailed breakdown of each conversion error in the order they occurred. The number of errors reported is determined by the maximum specified in the Conversion Wizard.  For Unicode, displays Type (UCS2/UTF8) and Endian like the input code.

Format Input-record-number : Position-within-the-record Error-contents Item-No.-in-Layout-definition : Item-name : Item-attribute

Using Data Converter - Displaying Conversion Errors - Examples of Typical Conversion Errors
Typical conversion errors and their causes are explained below. .
Area overflow error - usually because of area length changes 
After data file conversion involving code conversion of alphanumeric character items, Japanese items, mixed items, variable-length character string items, or variable-length Japanese items, the input data length and output data length of the same item may not match.
 

Cause of area length changes

Action

1 Conversion from ASCII/EBCDIC to Unicode (UCS2 format) was performed.
àIn the UCS2 format, all characters are represented by 2-byte codes.
Use the layout definition function to increase the area length of each output item.
2 Conversion from the CSV/XML format to the data format was performed.
àIn the CSV/XML format, the length of each input item is variable. Therefore, the data length after conversion may not match the output area length. If the data length after conversion is shorter than the output area length, the non-data area is padded with null characters (or one-byte spaces for some item attributes). If the data length after conversion is longer than the output area length, extra characters are removed and an error is output.

Code conversion error - code conversion error/incorrect conversion 

 

Cause of code conversion errors

Action

3 Attempts to convert LOW-VALUE (0x00) or HIGH-VALUE (0xFF) or extended ASCII code result in a conversion error.
àBecause Data Converter does not recognize LOW / HIGH-VALUEs as characters, a conversion error occurs and the LOW / HIGH-VALUEs are replaced with specific alternate characters.
Create a mapping table in a user-defined file.
Example:
------------
# ASCI ASCI
00:00
80:80
81:81
FF:FF
0000:0000
------------

Errors in numeric part - causes of errors in numeric part

 

Causes of errors in numeric part

 

- Non-numeric data exists in an external/internal decimal data area.
Attribute Sign COPY clause Internal representation (hex.) Value Error
External decimal No 9(4) 31323334 1234 No
External decimal Yes S9(4) 31323344 +1234 No
External decimal No 9(4) 3132333A 0 Yes
Internal decimal No 9(4) COMP3 01234F 1234 No
Internal decimal Yes S9(4) COMP3 01234D -1234 No
Internal decimal No 9(4) COMP3 012B4F 0 Yes
- A non-numeric character or symbol exists in a CSV/XML-formatted (numeric) data area.
Attribute Sign COPY clause Value Error
External decimal No 9(4)

ABCD

Yes
External decimal Yes S9(4) $1234 Yes

Errors in sign part - causes of errors in sign part

When data file conversion involves conversion of external or internal decimal items, the sign part is strictly checked. Before the sign part can be checked, you must enable the Perform Input Check option when defining layout definition items.
Attribute Sign COPY clause Internal representation Value Error
External decimal No 9(4) 31323334 1234 Any digit that is not 3 is erroneous.
External decimal Yes S9(4) 31323354 -1234 Any digit that is not 4 or 5 is erroneous.
External decimal Yes S9(4) 31323344 1234
Internal decimal No 9(4) COMP3 01234F 1234 Any digit that is not F is erroneous.
Internal decimal Yes S9(4) COMP3 01234C +1234 Any digit that is not C or D is erroneous.
Internal decimal Yes S9(4) COMP3 01234D -1234
Note: The above external decimal examples assume the ASCII code system. The operational signs for the EBCDIC code system are as follows:
F: Zone bit
C: Positive operational sign
D: Negative operational sign