Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

Selective SQL pass-through

  • Last Updated: May 12, 2026
  • 1 minute read
    • OpenAccess SDK
    • Version 9.0
    • Documentation

The IP can be written to select between row-based mode or SQL pass-through query execution modes on a query-by-query basis. To use this flexibility, the IP is registered as a row-based IP but it can examine the query and before execution starts switch the OpenAccess SDK SQL engine to Pass-Through mode. The ability to first look at the query is useful in cases where the data source can handle a limited set of queries but must rely on the OpenAccess SDK SQL engine to handle other queries.

Note: Only SELECT queries are supported for selective pass-through.

TitleResults for “How to create a CRG?”Also Available inAlert