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
ODBC's output is not readable
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.