SAS DB2 libname

[Sir_Lancelot]

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.

[RW9]

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

[Sir_Lancelot]

Is there a way to pass server name or host?

[RW9]

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