Desktop productivity for business analysts and programmers

SAS DB2 libname

Reply
New Contributor
Posts: 2

SAS DB2 libname

Hi All

 

I need to connect SAS to a DB2 database on the mainframe. I have a user and password, database and table name as well as the ip address. Can someone assist with the syntax.

 

Thanks in advance.

Super User
Super User
Posts: 9,402

Re: SAS DB2 libname

Posted in reply to Sir_Lancelot

In what sense, if pass-through then;

proc sql;
  connect to db (user=... database=... password=...);
  execute('...');
  disconnect from db;
quit;

Libname is similar, from the docs:

http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a001361103.htm

New Contributor
Posts: 2

Re: SAS DB2 libname

Is there a way to pass server name or host?

Super User
Super User
Posts: 9,402

Re: SAS DB2 libname

Posted in reply to Sir_Lancelot

Not used db2 in a very long time, so can't remember.  I think there is a: server= ,option. 

Ask a Question
Discussion stats
  • 3 replies
  • 97 views
  • 0 likes
  • 2 in conversation