XDB Migrate or Import of binary data in CHAR columns

Problem:

Table data are moved from IBM DB2 to XDB. A CHAR or VARCHAR column is containing any binary data, which are not displayable, hence not convertable. But the column is not declared as FOR BIT DATA. Those columns may be used to hold converted or compressed data.

The error reported by the customer, usually sounds like:

"XDB is returning rows not sorted correctly".

Resolution:

In the XDB table declaration, the FOR BIT DATA clause is required.

While importing the data by SQLWizard - File - New - Import, you may prohibit the conversion of this column. Step into the table information, and change the value below the column "EBCDIC" to "No".  This tells the SQLWizard, that the column is not EBCDIC, and must not be converted into ASCII.