SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SAS ACCESS TO DB2

Reply
Occasional Contributor
Posts: 9

SAS ACCESS TO DB2

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,

Valued Guide
Posts: 3,208

Re: SAS ACCESS TO DB2

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

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 1 reply
  • 272 views
  • 0 likes
  • 2 in conversation