This chapter explains the processing you must implement in your IP to support the various features of SQL: SELECT, UPDATE, INSERT, scalar functions, privileges, stored procedures, data management, dynamic schema, and others.
Note: You can skip this chapter if you are using OpenAccess SDK to develop an IP using the SQL Pass-Through mode in which the IP handles the execution and the OpenAccess SDK SQL engine handles the SQL parsing. For instructions on developing an IP using the SQL Pass-Through mode, see Implementing SQL pass-through mode.
For each topic, this chapter provides an overview, details of the processing, and the API calls to use. The API is the set of functions that IPs use to interact with the OpenAccess SDK SQL engine. For more detailed information on the OpenAccess SDK SQL engine API, refer to the OpenAccess SDK SQL Engine Programmer’s Reference for C/C++, Java, or .NET.
The examples in this chapter use the C/C++ calling convention but the semantics of the function are the same for Java and .NET. Refer to OpenAccess SDK SQL Engine Programmer’s Reference for C/C++, Java, or .NET for details on using the functions or methods in that environment.
