How to add DB2 (via odbc) to SAS library in Enterprise Guide 4.1
Posted on 2008-06-24
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!