topic explicit pass-through facility library in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/explicit-pass-through-facility-library/m-p/84495#M8095 <HTML><HEAD></HEAD><BODY><P>Just to know</P><P></P><P>How to define a library in metadata with the correct options (or what are the options need to select) so that library will be used specifically with the explicit pass-through all the time...</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 19 Jul 2013 22:32:37 GMT sas_9 2013-07-19T22:32:37Z explicit pass-through facility library https://communities.sas.com/t5/SAS-Enterprise-Guide/explicit-pass-through-facility-library/m-p/84495#M8095 <HTML><HEAD></HEAD><BODY><P>Just to know</P><P></P><P>How to define a library in metadata with the correct options (or what are the options need to select) so that library will be used specifically with the explicit pass-through all the time...</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 19 Jul 2013 22:32:37 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/explicit-pass-through-facility-library/m-p/84495#M8095 sas_9 2013-07-19T22:32:37Z Re: explicit pass-through facility library https://communities.sas.com/t5/SAS-Enterprise-Guide/explicit-pass-through-facility-library/m-p/84496#M8096 <HTML><HEAD></HEAD><BODY><P>I could be very wrong, but I believe maybe for the future release, for now (prior to 9.3), they are mutually exclusive, you either choose </P><P><SPAN style="margin: 1.4em 0 0; font-size: 13.600000381469727px;"><A name="a001381220" style="font-size: 13.600000381469727px; font-family: inherit;"> </A>a dynamic LIBNAME engine</SPAN></P><P><SPAN style="margin: 1.4em 0 0; font-size: 13.600000381469727px;">Or<BR /></SPAN><SPAN style="margin: 1.4em 0 0; font-size: 13.600000381469727px;"><A name="a001381221" style="font-size: 13.600000381469727px; font-family: inherit;"> </A>the SQL Pass-Through Facility</SPAN></P><P>.</P><P>They are running on different rules. The former gives you the comfort of using SAS library, and SAS takes lots underline efforts to make you feel that you are dealing regular SAS tables. The latter could get you some performance edge if the database is optimized, but it is nothing more than a straight portal for you to deliver your compatible SQL code.</P><P></P><P>Haikuo</P></BODY></HTML> Sat, 20 Jul 2013 00:35:24 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/explicit-pass-through-facility-library/m-p/84496#M8096 Haikuo 2013-07-20T00:35:24Z