This content has been marked as final. Show 3 replies
I am trying to build a QVD file. My source data is a DB2 table located on IBM AS/400 system. Some of the columns in the table contain Chinese characters. I am trying to load the table using ODBC and generate a QVD. Qlikview gives error when the load starts. I have attached the error long file below. If I exclude the columns with Chinese characters from the load statement then it works. I am using Windows 7 and my language settings for Non-Unicode programs is set to "Chinese" but still no good.
Has anybody experienced the same problem ??
Thanks a lot in advance for helping.
Qlikview load error
ODBC read failed
SQL SELECT *
SQL SELECT *
8/17/2011 9:36:32 AM: 0017 FROM S102LAPM.JDEINTLIB.F5682QV
8/17/2011 9:36:34 AM: 98 fields found: WFSRP3, W1DL01, WFSRP2, W2DL01, WFSRP1, W3DL01, WFDOCO, WFDCTO, WFKCOO, WFNAME, WFLNID, WFLNTY, WFROUT, WFPRP1, WFDESC, WFVR01, WFMCU, WFTRDJ, WFDRQJ, WFADDJ, WFDGL, WFIVD, WFDGJ, WFDOC, WFDCT, WFORIG, W4DL01, WFLITM, WFAITM, WFDSC1, WFDSC2, WFAC03, WFAN8, WFALPH, WFAC11, W5DL01, WFSHAN, W2ALPH, WFAC13, W6DL01, WFDL01, WFADD1, WFADD2, WFADD3, WFADD4, WFDL02, WFCTY1, WFLOTN, WFLOCN, WFNXTR, W7DL01, WFLTTR, W8DL01, WFUORG, WFSOQS, WFSOBK, WFCRCD, WFTXR1, WFUPRC, WFFEP, WFAEXP, W2AEXP, W3AEXP, W4AEXP, WFUNCS, WFECST, W5AEXP, W6AEXP, WFRATE, WFLPRC, W7AEXP, WFFUP, WFFEA, W8AEXP, WFFUC, WFFEC, W9AEXP, WFSRP7, W2UNCS, WAAEXP, WFSLSM, WFALP1, WFAC02, W9DL01, WFSLM2, W3ALPH, WFPTC, WFDTE, WFANFL, WFCCPR, WFAC14, WADL01, WFOPRD, WFRMK, WFVEND, W2VEND, WFPRP2, WFUPMJ,
SQL Error:[IBM][System i Access ODBC Driver]Error in assignment.
8/17/2011 9:36:38 AM: Error: ODBC read failed