Desktop productivity for business analysts and programmers

explicit pass-through facility library

Reply
Regular Contributor
Posts: 220

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

Thanks!

Respected Advisor
Posts: 3,156

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

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

Haikuo

Ask a Question
Discussion stats
  • 1 reply
  • 204 views
  • 3 likes
  • 2 in conversation