SQL Statements

The KCML ODBC driver does not permit updating of the database which might compromise database integrity. Consequentially the DDL and DML statements of the ODBC grammar will be rejected and only SELECT statements will be parsed. Within that constraint the driver's SQL engine supports the Minimum, Core and Extended grammars except for the Extended Grammar feature of procedure invocation which has no equivalent in KDB. Subqueries and unions in SELECT are supported.

KCML supports a ROWID keyword which uniquely identifies a row in a table. It can be used wherever a column name is valid. KISAM has no concept of user or qualifier modifiers. If they are used they will be ignored.