This is an old revision of the document!
Table of Contents
Ispirer Home Page
Ispirer SQLWays Migration Product Page
Request SQLWays
COLNAME Error - Converted N Bytes. X Errors Found Beginning At Offset
Symptoms
During the export process from DB2 database you can see error “COLNAME Error - Converted 50 Bytes. 49 Errors Found Beginning At Offset 0”. Here is the screenshot, how the error message looks like in the sqlways.log file:
Cause
The case is connected with the ODBC conversion of unsupported characters when making select from DB2 database.
Solution
To solve this case please go to the ODBC Data Source Administrator and edit your DB2 ODBC Connection. On the ODBC Driver settings please go on the Translation or Conversion tab, click “Advanced” button and check the 'Allow unsupported character' checkbox. Like it is shown on the screenshot:
If you will have some additional questions or face with some difficulties please contact our support team and provide detailed description of the case you faced with: support@ispirer.com
Ispirer Home Page
Ispirer SQLWays Migration Product Page
Request SQLWays