topic Re: SAS ACCESS TO DB2 in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/SAS-ACCESS-TO-DB2/m-p/132069#M1838 <HTML><HEAD></HEAD><BODY><P>Probably it is encoding. As you can read most of the data there is not technical issue in connecting.</P><P>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</P><P>see: <A href="http://support.sas.com/documentation/cdl/en/nlsref/64811/HTML/default/viewer.htm#n0882t2muy4l94n19cno6z40xmuz.htm" title="http://support.sas.com/documentation/cdl/en/nlsref/64811/HTML/default/viewer.htm#n0882t2muy4l94n19cno6z40xmuz.htm">SAS(R) 9.4 National Language Support (NLS): Reference Guide</A> (Common Encoding Methods)</P><P></P><P>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).</P><P>The used interfaces should also support the translation with no backfiring effects </P></BODY></HTML> Sun, 03 Nov 2013 14:06:30 GMT jakarman 2013-11-03T14:06:30Z SAS ACCESS TO DB2 https://communities.sas.com/t5/SAS-Data-Management/SAS-ACCESS-TO-DB2/m-p/132068#M1837 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>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?</P><P></P><P>thanks,</P></BODY></HTML> Sun, 03 Nov 2013 09:48:49 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-ACCESS-TO-DB2/m-p/132068#M1837 MSaber 2013-11-03T09:48:49Z Re: SAS ACCESS TO DB2 https://communities.sas.com/t5/SAS-Data-Management/SAS-ACCESS-TO-DB2/m-p/132069#M1838 <HTML><HEAD></HEAD><BODY><P>Probably it is encoding. As you can read most of the data there is not technical issue in connecting.</P><P>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</P><P>see: <A href="http://support.sas.com/documentation/cdl/en/nlsref/64811/HTML/default/viewer.htm#n0882t2muy4l94n19cno6z40xmuz.htm" title="http://support.sas.com/documentation/cdl/en/nlsref/64811/HTML/default/viewer.htm#n0882t2muy4l94n19cno6z40xmuz.htm">SAS(R) 9.4 National Language Support (NLS): Reference Guide</A> (Common Encoding Methods)</P><P></P><P>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).</P><P>The used interfaces should also support the translation with no backfiring effects </P></BODY></HTML> Sun, 03 Nov 2013 14:06:30 GMT https://communities.sas.com/t5/SAS-Data-Management/SAS-ACCESS-TO-DB2/m-p/132069#M1838 jakarman 2013-11-03T14:06:30Z