The OpenAccess SDK SQL engine handles the parsing and the execution of the SQL DML (Data Manipulation Language), DDL (Data Definition Language), and DCL (Data Control Language) statements summarized below.
The OpenAccess SDK SQL engine supports all of the basic DML, DDL, and DCL SQL syntax, including:
• SELECT
• INSERT
• UPDATE
• DELETE
• SELECT FOR UPDATE
• CREATE TABLE, DROP TABLE
• CREATE INDEX, DROP INDEX
• Expressions
• Stored procedure calling
• Nested queries
• Scalar functions
• Views
• Rights (Privileges)
The OpenAccess SDK SQL engine supports the SQL grammar as defined in the OpenAccess SDK SQL Reference.
