How to retrieve Server id from libref for Database

[Aswin_K]

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!

[SASKiwi]

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;

[Aswin_K]

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

[Tom]

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