3 Replies Latest reply: Dec 3, 2013 7:09 AM by Henric Cronström RSS

    Getting data from DB2/AS400 in wrong data type

    Andrea Gigliotti


      I faced this issue for the second time in reading data from DB2 on AS400.

      Specifically some of fields declared as CHAR on DB2 I get those fields as numeric/integer rather than text/ascii (Tags) on QlikView and it causes wrong data result.

      I noted the values on those fields are numeric and alphanumeric (ex. 3, 03, abcd, etc...).

      Is this a problem of ODBC driver I'm using ? Is there some settings I have to looking for ?


      Currently I'm using iSeries Access ODBC Driver version


      Can someone drives me to the right direction to fix this problem ?


      Many thanks in advance.


      Best Regards