The FEDSQL procedure might not pass down a query to an SQL Server database


The FEDSQL procedure, when accessing a SQL Server table via CASLIB, might not push the entire query to the database. As a result, some of the processing is done in CAS. This issue occurs when the schema that is specified with the SCHEMA= option differs from the userid that was used to authenticate.

Including the CNTL=(requireFullPassThrough) option results in the FEDSQL query failing with the following message:

NOTE: Failure of <table_name> prevents full pass-through.
NOTE: Full pass-through to the underlying data source was not possible. Stopping execution.

The only workaround is to use explicit pass-through.