• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3478
  • Last Modified:

How to add DB2 (via odbc) to SAS library in Enterprise Guide 4.1


I'm trying to figure out how to add a DB2 environment/database to my SAS Enterprise Guide library. I have done this successfully with Teradata but for some reason cannot figure out how to do it with DB2.

For the Teradata environment I used tdpid=TDPROD database=LTC_P in "Other Options" for the connection. I've tried something like  tdpid=DB2PSN database=PROD and that does not seem to work. Any ideas? I can connect to the DB2 environment via odbc (which brings lists thousands of tables and eventually crashes).

I'm just curious as to why this connection won't work in EG.

Any suggestions would be greatly appreciated. Thanks!
1 Solution
Kent OlsenData Warehouse Architect / DBACommented:
Hi c9k9h,

I know nothing about using SAS to connect to DB2, however I have been able to find some SAS documentation about it.  Page 11 of the following link may help.


If not, there's quite a repository of information on SAS and DB2 here:


Good Luck,
c9k9hAuthor Commented:
Thank you!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now