Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.
Mandar
Qlikview load error
ODBC read failed
JDE_SO_Data:
SQL SELECT *
FROM S102LAPM.JDEINTLIB.F5682QV
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.
SQL Scriptline:
SQL State:22005
8/17/2011 9:36:38 AM: Error: ODBC read failed
Hi Mandar,
have you loaded chinese fonts into your Windows System??
If you know chinese is a pictorial language.. it doesn't contain alphabets, so there might be some problems in data load without the chinese fonts.
hope this helps
Rgrds,
Abhinava
Hi Abhinav
thanks for your reply. Yes, I have already enabled Chinese font in my Windows. It still gives the same error when I try to load the script.
Mandar
Hi Abhinav
thanks for your reply. Yes, I have already enabled Chinese font in my Windows. It still gives the same error when I try to load the script.
Mandar