You need to determine which of the SQL SELECT, INSERT, UPDATE, or DELETE functions you want to support for each of the tables and the operators that you want to support while optimizing on conditions on columns (for example, =, <, >).
In each IP that you develop, you must implement a GETSUPPORT function to allow the OpenAccess SDK SQL engine to determine what functionality you have implemented in the IP. The information that is returned by GETSUPPORT provides the default function support for every table and the default operator support for every column. It can be overridden in the definitions of the table and the columns. For example, GETSUPPORT may return false for DELETE support but a table’s support value may override this and allow DELETE.
The OpenAccess SDK SQL engine uses the information that is returned by GETSUPPORT, and the settings in the definitions of the tables and the columns, to determine what type of requests to pass to the IP. See Schema definition and management for details on specifying the capabilities at table and column levels.
The IP reports its capabilities to the OpenAccess SDK SQL engine, indicating whether it supports the following:
• SELECT, INSERT, UPDATE, and DELETE
• CREATE TABLE, DROP TABLE, CREATE INDEX, and DROP INDEX
• Stored Procedures
• Schema management
• =, >, <, BETWEEN, LIKE and other operations in search restrictions
• Privileges
• Block joins or join push down
For details on GETSUPPORT, refer to the specific OpenAccess SDK SQL Engine Programmer’s Reference for your programming language.
