How can I ensure that a query only runs if full implicit pass-through is achieved?

1 vues

Réponse

You can use the 'cntl' parameter list and set 'requireFullPassThrough' to TRUE. This stops processing if FedSQL implicit pass-through of the full query cannot be achieved, preventing data loading into CAS.
Did this answer help you?
execDirect

fedSql

See technical action
Other questions about execDirect
What is the default behavior for implicit pass-through in the execDirect action? How can I validate a FedSQL query without executing it? Which parameter is mandatory when using the execDirect action? What options are available to view the FedSQL query plan? What does the 'dynamicCardinality' control parameter do?
Copyright © WeAreCAS 2014-2026
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.