BookmarkSubscribeRSS Feed
Edie
Calcite | Level 5
We have the SAS Server on a UNIX box and we're connecting to DB2 thru ODBC. Can I register these DB2 tables in SAS? If so, how do I do it or where can I find out how to do it? Thanks.
1 REPLY 1
LinusH
Tourmaline | Level 20
Quite odd combination...
Using SAS/ACCESS to DB2 sounds more straightforward.
I know that there is a possibility to use ODBC in UNIX, but the instructions to make it work seems a bit tricky.
Nevertheless, by registering, do you mean in a Metadata server?
And, can you access these DB2 tables outside SAS on that UNIX box (that is, have you completed the necessary steps in the ODBC setup)?
If so, there are a lot of documentation and papers that describes similar scenarios.
On this site, search for "management console odbc server".

/Linus
Data never sleeps

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Health and Life Sciences Learning

 

Need courses to help you with SAS Life Sciences Analytics Framework, SAS Health Cohort Builder, or other topics? Check out the Health and Life Sciences learning path for all of the offerings.

LEARN MORE

Discussion stats
  • 1 reply
  • 1158 views
  • 0 likes
  • 2 in conversation