Date: Fri, 15 Oct 2010 14:46:17 -0400
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Amrita Singh <amritas2@AOL.COM>
Subject: Re: Reading DB2 tables with SAS
Content-Type: text/plain; charset="us-ascii"
Thanks Suzanne!! This is very helpful.
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
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.
rom: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Amrita
ent: Friday, October 15, 2010 2:06 PM
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,