Ispirer Website Ispirer Capabilities: DB2 Migration Free Trial

Import Character Data Aet as FOR BIT DATA

Symptoms

During the data import process in SQLWays, codes are extracted instead of actual values.

Cause

When columns are specified as for binary data, codes will be extracted instead of actual values.

Solution

To import text data from character data created as FOR BIT DATA, there is a specific option to be set in SQLWays. Please refer to the screen shot below to set an option that will allow binary data conversion to text:


If you have any other questions, please contact us: support@ispirer.com