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

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

Hello,

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!
0
c9k9h
Asked:
c9k9h
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.

  http://support.sas.com/resources/papers/accessdb2.pdf


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

  http://support.sas.com/resources/papers/tnote/tnote_database.html


Good Luck,
Kent
0
 
c9k9hAuthor Commented:
Thank you!
0
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

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

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