DSXchange

Dear all

did you have practice that use ODBC stage to read data from SQL server database ?

Now i am using ODBC stage to read SQL SEVER data, but data is not readable

all the values are showing as ?????

pls advise

Context

Datastage Version : 7.5
Stage : ODBC Enterprise
Source DB: SQL SERVER
Target DB: DB2
Platform: AIX

I have never had a problem. Obviously you can connect OK, therefore presumably the problem is no in .odbc.ini or uvodbc.ini). The most likely culprits are incorrect settings either of the metadata (for example CHAR instead of WCHAR or NCHAR) or of the NLS character map.