Desktop productivity for business analysts and programmers

explicit pass-through facility library

Regular Contributor
Posts: 225

explicit pass-through facility library

Just to know

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...


Respected Advisor
Posts: 3,185

Re: explicit pass-through facility library

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

a dynamic LIBNAME engine

the SQL Pass-Through Facility


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.


Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation