ODBC's output is not readable

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
nimix9ig
Participant
Posts: 4
Joined: Tue Nov 20, 2012 12:32 am

ODBC's output is not readable

Post by nimix9ig »

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
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
Post Reply