topic SAS DB2 libname in SAS Enterprise Guide

SAS DB2 libname

Sir_Lancelot — Mon, 11 Jun 2018 12:35:43 GMT

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.

Re: SAS DB2 libname

RW9 — Mon, 11 Jun 2018 13:08:45 GMT

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

Re: SAS DB2 libname

Sir_Lancelot — Mon, 11 Jun 2018 13:12:38 GMT

Is there a way to pass server name or host?

Re: SAS DB2 libname

RW9 — Mon, 11 Jun 2018 13:19:53 GMT

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