DQM(JDBC):query item contains non-English characters

[ricky_ru]

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,

[Rahul Ganguli]

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

[ricky_ru]

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

Code Select Expand

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

[Rahul Ganguli]

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

[ricky_ru]

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

[Rahul Ganguli]

Great!
8)