SAS ACCESS TO DB2

[MSaber]

Dear all,

I'm Using SAS E.G and SAS Base installed on windows 2008 64 Bit. I'm trying to read DB2 tables which reside on Linux Redhat 6. I can read most of data, but other data which has Arabic characters I receive it as blank. I think I need to do transcode for the data while retrieve from DB2. can anyone advise how to do that or is there any other solution?

thanks,

[jakarman]

Probably it is encoding. As you can read most of the data there is not technical issue in connecting.

When the DB/2 is utf-8 (the most common unicode option) one single (1) character can be represented by one 1 to 4 four bytes. A lot of old guys are mind-blocked on this

see: SAS(R) 9.4 National Language Support (NLS): Reference Guide (Common Encoding Methods)

Your local sesssion must also support that als you work on SAS base english (latin-1 437 850) based installation you could possible need to switch some things (un instead en).

The used interfaces should also support the translation with no backfiring effects