Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

Import Character data set 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:


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

sqlways/troubleshooting-guide/db2/import-conversion/data/import-character-data-set-as-for-bit-data.txt · Last modified: May 07, 2018, 03:15:34 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement