DRS Vs ODBC Stage

thumsup9 · Post by **thumsup9** » Thu Aug 10, 2006 3:37 pm

Hello All,

I am trying to understand this

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

Thanks much.

chulett · Post by **chulett** » Thu Aug 10, 2006 4:23 pm

Source database? And this is with the DRS set to ODBC as well, I presume?

meena · Post by **meena** » Thu Aug 10, 2006 4:34 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Aug 10, 2006 9:14 pm

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?

thumsup9 · Post by **thumsup9** » Fri Aug 11, 2006 8:35 am

Hi All,

Sorry for the delay.

Chulet -- SQL Server with DRS set to ODBC.

Meena-- Yes I am doing this in two jobs

Ray -- This is ASCII and Binary Data. NLS is set to ISO8859-1

Pls let me know if you need more inputs...

Thanks,

splayer · Post by **splayer** » Tue Aug 22, 2006 10:21 am

ray, how do you set DRS to use the native API?

kcbland · Post by **kcbland** » Tue Aug 22, 2006 10:31 am

splayer wrote:ray, how do you set DRS to use the native API?

By choosing Oracle, DB2, Sybase, etc.

chulett · Post by **chulett** » Tue Aug 22, 2006 10:33 am

Via the DBMS Type selection. Read the Help, it will list which are native and which are ODBC.