02-23-2015 09:00 PM
I am very new to SAS and am having difficulties connecting to a DB2 library from Base SAS.
We have recently installed the SAS/ACCESS Interface to DB2, so can successfully connect in EG by using the following code:
LIBNAME XXXXXXXX DB2 DATASRC=XXXXXXXX USER=XXXXXXXX PASSWORD=XXXXXXXX
I am thinking I could use something similar in Base SAS but I would probably need to remotely connect or submit first, which I am not very familiar with.
Is someone out there able to assist me or send through the syntax I should be using? I have tried some of the suggestions out there in forums, but no luck as yet.
Thanks in advance,
02-23-2015 09:27 PM
Try the following, I think it follows this structure but not 100% sure. You need to know your server name
*set up on server;
LIBNAME TEST DB2 DATASRC=XXXXXXXX USER=XXXXXXXX PASSWORD=XXXXXXXX
*add local reference to server library;
libname test slibref=test server=serverName;