Libname with/without quotes

david27 — Tue, 02 Oct 2018 21:20:43 GMT

Hello,

I want to create a single libname statement that works for my database(via authdomain) and also on my unix server.

I have this:

This works:
%let x=DB2 dsn="ABCDEF" authdomain='abc_d_efg' schema="nameofschema";

libname input &x.; /* No quotes*/

I can also have:

%let x=/path/on/unix/server/directory;

The above libname(WITHOUT) quotes will not work.

For this i will have to ADD the quotes.

This will work for second example:

libname input "&x.";

I need help with handling quotes.

Please advise, in what way i should code this. So that a single libname works for both.

Thanks

Re: Libname with/without quotes

ChrisNZ — Wed, 03 Oct 2018 23:02:08 GMT

Simple answer:

%let x="/path/on/unix/server/directory";

More complex and but much more flexible answer as you can tweak ad infinitum:

libname %sysfunc(ifc(%index(%superq(x),DB2),%superq(x),"&x")) ;