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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

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