3 Replies Latest reply: Dec 10, 2017 4:55 AM by Petter Skjolden RSS

    Extracting Double Byte table from iSeries/DB2 using ODBC connection

    Lorraine Morgan

      I am consistently getting this message on the Load/SQL Select statement when extracting Double Byte files from our location in China.

       

      QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 22005, ErrorCode: 30019, ErrorMsg: [IBM][System i Access ODBC Driver]Error in assignment

       

      I have also gotten an invalid file type message.  Originally I felt there was garbage in one of the fields; however, I had the location review the data and remove some special characters in the data.  I still can't load the file.  This is only happening with files defined as double byte.  I need to be able to cleanse the data before it is loaded.  Can an ODBC connector be modified to do a cleanse before the data reaches the Load?  I am open to suggestions.