Thanks Suzanne!! This is very helpful.

Regards, Amrita

-----Original Message----- From: Suzanne McCoy <Suzanne.McCoy@catalinamarketing.com> To: Suzanne McCoy <Suzanne.McCoy@catalinamarketing.com>; 'Amrita Singh' <amritas2@AOL.COM>; 'SAS-L@LISTSERV.UGA.EDU' <SAS-L@LISTSERV.UGA.EDU> Sent: Fri, Oct 15, 2010 2:14 pm Subject: RE: Reading DB2 tables with SAS

and check the system level autoexec.sas file -----Original Message----- rom: Suzanne McCoy ent: Friday, October 15, 2010 2:14 PM o: 'Amrita Singh'; SAS-L@LISTSERV.UGA.EDU ubject: RE: Reading DB2 tables with SAS If you open interactive SAS and the DB2 libname is automatically showing up you hould be able to get the userid from the properties values. I hope the assword is encrypted but you never know. -----Original Message----- rom: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Amrita ingh ent: Friday, October 15, 2010 2:06 PM o: SAS-L@LISTSERV.UGA.EDU ubject: Re: Reading DB2 tables with SAS Thanks so much for all your suggestions - it is so wonderful to get such upport from the SAS community! I was going on follow up on some of these deas but after some investigation it turns out we do have SAS/ACCESS. We an even access db2 tables by directly referencing them in the sas code. t some point a libname statement must have been set up somewhere though e dont see it. Now we want to try and use pass-thru to connect to the db2 ables but no one seems to know the SSID, user name or password. The erson responsible is no longer with the company so we are trying to see ow we can get this information. Thanks again for your help, egards, Amrita