Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

Support for SQL concepts on table functions

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

SQL concepts, such as Views, Joins, Unions, and so on, are supported on table functions. These concepts can be applied on table functions similar to the way they are applied to other SQL tables.

The standard index-related OpenAccess SDK engine APIs are used for optimizing the query execution on table functions.

Aliases must be used on table functions in the following format:

SELECT * from TF (‘A’,’B’) as Table_Function;

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