c9k9h
asked on
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER