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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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
  • 797 views
  • 0 likes
  • 2 in conversation