DRS stage-- I am doing a view data. I can see the data for all the columns except for the columns with binary Datatype. For these columns I see junk data when viewd through datastage.
Whereas when I view the same data through ODBC Stage
I can see all the data including the Binary Datatype columns.
Please explain whats happening here, also if you need more inputs..
Hi thumsup9 ..
What is your source database? And you are checking with two different jobs one with DRS stage and other is with ODBC stage right...or in one
Is this ASCII and binary data, or is there another character set (Thai?) involved? Is the DRS stage set to use ODBC or a native API connection protocol? If a native protocol, are the environment variables that it requires correctly set?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
splayer wrote:ray, how do you set DRS to use the native API?
By choosing Oracle, DB2, Sybase, etc.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle