ODBC API Functions

The driver implements all of the Core and Level 1 API functions as well as most of the Level 2 API. Functions from the Level 2 API not currently supported are SQLExtendedFetch, SQLSetScrollOptions, SQLMoreResults and SQLSetPos. Certain other Level 2 functions pertain to functionality not relevant to a KCML database and are implemented as functions returning empty result sets. These are SQLForeignKeys, SQLTablePrivileges, SQLColumnPrivileges, SQLProcedures and SQLProcedureColumns.

Core API functions

SQLCancel supported
SQLColAttributes supported
SQLConnect supported
SQLDescribeCol supported
SQLDisconnect supported
SQLError supported
SQLExecDirect supported
SQLExecute supported
SQLFetch supported
SQLFreeConnect supported
SQLFreeEnv supported
SQLFreeStmt supported
SQLGetCursorName supported
SQLNumResultCols supported
SQLPrepare supported
SQLRowCount supported
SQLSetCursorName supported
SQLTransact supported

Level 1 API functions

SQLColumns supported
SQLDriverConnect supported
SQLGetConnectOption supported
SQLGetData supported
SQLGetFunctions supported
SQLGetInfo supported
SQLGetStmtOption supported
SQLGetTypeInfo supported
SQLParamData supported
SQLPutData supported
SQLSetConnectOption supported
SQLSetStmtOption supported
SQLSpecialColumns supported
SQLStatistics supported
SQLTables supported
SQLBindParameter supported

Level 2 API functions

SQLBrowseConnect not supported
SQLColumnPrivileges supported but not relevant to KCML databases
SQLDescribeParam supported
SQLExtendedFetch not supported
SQLForeignKeys supported but not relevant to KCML databases
SQLMoreResults not supported
SQLNativeSql supported
SQLNumParams supported
SQLParamOptions not supported
SQLPrimaryKeys supported
SQLProcedureColumns supported but not releveant to KCML databases
SQLProcedures supported but not relevant to KCML databases
SQLSetPos not supported
SQLSetScrollOptions not supported
SQLTablePrivileges supported but not relevant to KCML databases