Dear SAS-L-ers,

Amrita posted, in part, the following:

> .......... Now we want to try and use pass-thru to connect to the > db2 tables but no one seems to know the SSID, user name or password. The > person responsible is no longer with the company so we are trying to > see how we can get this information. >

<<Amrita's entire original posting can be found beneath the Sig line>>

Amrita, I would suggest finding out where that person ended up and then sending him a very nice Hallmark card with note explaining the situation and including a crisp, new $20 bill in it. I would bet that would do the trick!

But, seriously though; your friendly DB2 DBA should be able to provide that information to you. Of course, s/he would be even friendlier if you provided that nice Hallmark card with said contents along with your query:-)

Amrita, best of luck in all your SAS endeavors!

I hope that this suggestion proves helpful now, and in the future!

Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Michael A. Raithel "The man who wrote the book on performance" E-mail: MichaelRaithel@westat.com

Author: Tuning SAS Applications in the MVS Environment

Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172

Author: The Complete Guide to SAS Indexes http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ A day without sunshine is like, you know, night. - Steve Martin +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

<<Amrita's entire original posting >>

> Thanks so much for all your suggestions - it is so wonderful to get > such > support from the SAS community! I was going on follow up on some of > these > ideas but after some investigation it turns out we do have SAS/ACCESS. > We > can even access db2 tables by directly referencing them in the sas > code. > At some point a libname statement must have been set up somewhere > though > we dont see it. Now we want to try and use pass-thru to connect to the > db2 > tables but no one seems to know the SSID, user name or password. The > person responsible is no longer with the company so we are trying to > see > how we can get this information. >