Dears,
It looks like Teradata does not support sql query contains non English characters such as the column alias is local language. It is very common to name the query item with local language in FM. So, this will cause the failure of the sql execution.
I want to know is there a workaround in cognos such as sending database the sql where the column alias is generated automatically such as c0, c1,c2.... and display it to user with the query item label...
Thanks,
I think Cognos Framework is able to handle this.
You must me using ODBC for teradata.
What is the issue are you facing?
Regards,
Rahul
Thank you.
Why did you said I must use ODBC for teradata? Is there official documentation warning that?
I got the following error when I ran SQL containing non-English characters via JDBC such as SELECT NAME AS "姓名", job AS "工作" FROM EMP
Error: [Teradata Database] [TeraJDBC 13.10.00.32] [Error 3697] [SQLState HY000] Attempt to translate Unicode/Graphic/KanjiSJIS data to another form has failed
SQLState: HY000
ErrorCode: 3697
Hi Ricky,
ODBC connection was just a confirmation, have you visited the following link
http://www.ibm.com/developerworks/data/library/cognos/infrastructure/databases/page492.html
It seems the issue is with ODCB bridge, have you tried with english characters?
Also, you can put the non-English headers in Cognos end itself.
Regards,
Rahul
Problem fixed.
Multilingual Metadata:
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_fm.8.4.0.doc/ug_fm_id7328multilingual_support.html
Great!
8)