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

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