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

      Hi,

      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 13.64.08.00

       

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

       

      Many thanks in advance.

       

      Best Regards

      Andrea