Level 2 API

Overview of the functions that are defined in the MaxDB ODBC driver for the Level 2 API

Function

Remark

SQLBrowseConnect

SQLColumnPrivileges

SQLDataSources (*)

SQLDescribeParam

SQLExtendedFetch

You can only insert rows using the function with the dynamic cursor model (SQL_CURSOR_DYNAMIC). This is not possible with any other cursor models.

UPDATE and DELETE statements are possible both with the static (SQL_CURSOR_STATIC) and with the keyset-driven cursor (SQL_CURSOR_KEYSETDRIVEN) models.

SQLFetchScroll

SQLForeignKeys

SQLMoreResults

The function calls SQLFreeStmt with the attribute SQL_CLOSE to close the previous result set and then returns SQL_NO_DATA_FOUND.

SQLNativeSql

SQLNumParams

SQLParamOptions

SQLPrimaryKeys

SQLProcedureColumns

SQLProcedures

SQLSetPos

All attributes are valid.
The attribute SQL_ADD is only possible in the dynamic cursor model (
SQL_CURSOR_DYNAMIC).
Only the attribute SQL_LOCK_NO_CHANGE is permissible for the fLock argument.

SQLSetScrollOptions

SQLTablePrivileges