Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

Sequence of key constraints

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

One of the most common queries is of the form:

SELECT * FROM CURVALUE WHERE name IN(T1,T2,T3, ...)

This query should only retrieve rows that match the name specified in the name list. In this case if the IP reported that it could handle equality constraints and the column name is marked as an indexed column in the schema, then the OpenAccess SDK SQL engine passes to the IP a list that contains the values T1, T2 and T3. The IP can use this list to retrieve the matching rows and pass them to the OpenAccess SDK SQL engine for processing.

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