Date:         Fri, 15 Oct 2010 14:14:49 -0400
Reply-To:     Suzanne McCoy <Suzanne.McCoy@CATALINAMARKETING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Suzanne McCoy <Suzanne.McCoy@CATALINAMARKETING.COM>
Subject:      Re: Reading DB2 tables with SAS
Comments: To: Amrita Singh <amritas2@AOL.COM>
In-Reply-To:  <4B7D94293459DE418D902EFAF874C4A7085A5ECFFC@STPPEX.catmktg.com>
Content-Type: text/plain; charset="us-ascii"

and check the system level autoexec.sas file

-----Original Message-----
From: Suzanne McCoy
Sent: Friday, October 15, 2010 2:14 PM
To: 'Amrita Singh'; SAS-L@LISTSERV.UGA.EDU
Subject: RE: Reading DB2 tables with SAS

If you open interactive SAS and the DB2 libname is automatically showing up you should be able to get the userid from the properties values.  I hope the password is encrypted but you never know.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Amrita Singh
Sent: Friday, October 15, 2010 2:06 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Reading DB2 tables with SAS

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.

Thanks again for your help,
Regards, Amrita