topic Re: How to retrieve Server id from libref for Database in New SAS User

How to retrieve Server id from libref for Database

Aswin_K — Wed, 14 Nov 2018 20:06:14 GMT

Hi,

In one of my programs, i know the library reference associated with the Database. But i need to find the Server id that has been provided for server=option while creating the libname statement. I checked Dictionary tables and couldn't find the field which holds the server information.

For example,

libname mydata informix server=year16; --> my libname statement.

But from the programs, i know only the libref name "mydata". how to retrieve the server value "year16" using the libref "mydata"

Thanks for you help!

Re: How to retrieve Server id from libref for Database

SASKiwi — Thu, 15 Nov 2018 00:04:38 GMT

You are correct. You won't find the the server name in the SAS dictionary tables. A simple solution to this problem would be to use a macro variable to define your server name then you can use it anywhere in your program:

%let MyServer = year16; 

libname mydata informix server=&MyServer;

%put My Server is called: &MyServer;

Re: How to retrieve Server id from libref for Database

Aswin_K — Fri, 23 Nov 2018 09:37:07 GMT

Thanks for the response @SASKiwi , my problem is that i am working on a macro that can be added to any program and the macro need to identify the server of the libname passed into it. The libname could have been declared anywhere in the program.

Thanks,

Aswin K

Re: How to retrieve Server id from libref for Database

Tom — Sat, 24 Nov 2018 08:47:30 GMT

Query the metadata tables. You can use SASHELP.VLIBNAM view. Or with SQL you can reference it directly as DICTIONARY.LIBNAMES.

Here is a link to macro that will return the Engine type, Hostname and schema/database name from that table.

https://github.com/sasutils/macros/blob/master/dblibchk.sas