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!
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!