11-03-2013 04:48 AM
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?
11-03-2013 09:06 AM
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