skip to main content
ODBC API and scalar functions : API functions
  

Try DataDirect Drivers Now

API functions

Progress DataDirect for ODBC drivers are Level 1 compliant, and support ODBC Core and Level 1 functions. As described in the following table, a limited set of Level 2 functions are also supported.
Table 4. Function Conformance for ODBC 2.x Applications
Core Functions
Level 1 Functions
Level 2 Functions
SQLAllocConnect1
SQLAllocEnv2
SQLAllocStmt3
SQLBindCol
SQLBindParameter
SQLCancel
SQLColAttributes
SQLConnect
SQLDescribeCol
SQLDisconnect
SQLDrivers
SQLError
SQLExecDirect
SQLExecute
SQLFetch
SQLFreeConnect4
SQLFreeEnv5
SQLFreeStmt
SQLGetCursorName
SQLNumResultCols
SQLPrepare
SQLRowCount
SQLSetCursorName
SQLTransact6
SQLColumns
SQLDriverConnect
SQLGetConnectOption
SQLGetData
SQLGetFunctions
SQLGetInfo
SQLGetStmtOption7
SQLGetTypeInfo
SQLParamData
SQLPutData
SQLSetConnectOption
SQLSetStmtOption8
SQLSpecialColumns
SQLStatistics
SQLTables
SQLBrowseConnect
SQLDataSources
SQLDescribeParam9
SQLExtendedFetch (forward scrolling only)
SQLMoreResults
SQLNativeSql
SQLNumParams
SQLParamOptions10
SQLSetScrollOptions
1 For macOS, this function is not supported by the iODBC driver manager; therefore, it cannot currently be executed by the driver.

2 For macOS, this function is not supported by the iODBC driver manager; therefore, it cannot currently be executed by the driver.

3 For macOS, this function is not supported by the iODBC driver manager; therefore, it cannot currently be executed by the driver.

4 For macOS, this function is not supported by the iODBC driver manager; therefore, it cannot currently be executed by the driver.

5 For macOS, this function is not supported by the iODBC driver manager; therefore, it cannot currently be executed by the driver.

6 For macOS, this function is not supported by the iODBC driver manager; therefore, it cannot currently be executed by the driver.

7 For macOS, this function is not supported by the iODBC driver manager; therefore, it cannot currently be executed by the driver.

8 For macOS, this function is not supported by the iODBC driver manager; therefore, it cannot currently be executed by the driver.

9 For macOS, this function is not supported by the iODBC driver manager; therefore, it cannot currently be executed by the driver.

10 For macOS, this function is not supported by the iODBC driver manager; therefore, it cannot currently be executed by the driver.

The functions for ODBC 3.x Applications that the drivers support are listed in the following table. For any additions to these supported functions or differences in the support of specific functions, refer to "ODBC compliance" or "ODBC conformance" in the user's guide for your driver.
Table 5. Function Conformance for ODBC 3.x Applications
SQLAllocHandle
SQLBindCol
SQLBindParameter
SQLBrowseConnect (except for Progress)
SQLBulkOperations
SQLCancel
SQLCloseCursor
SQLColAttribute
SQLColumns
SQLConnect
SQLCopyDesc
SQLDataSources
SQLDescribeCol
SQLDisconnect
SQLDriverConnect
SQLDrivers
SQLEndTran
SQLError
SQLExecDirect
SQLExecute
SQLExtendedFetch
SQLFetch
SQLFetchScroll (forward scrolling only)
SQLFreeHandle
SQLFreeStmt
SQLGetConnectAttr
SQLGetCursorName
SQLGetData
SQLGetDescField
SQLGetDescRec
SQLGetDiagField
SQLGetDiagRec
SQLGetEnvAttr
SQLGetFunctions
SQLGetInfo
SQLGetStmtAttr
SQLGetTypeInfo
SQLMoreResults
SQLNativeSql
SQLNumParens
SQLNumResultCols
SQLParamData
SQLPrepare
SQLPutData
SQLRowCount
SQLSetConnectAttr
SQLSetCursorName
SQLSetDescField
SQLSetDescRec
SQLSetEnvAttr
SQLSetStmtAttr
SQLSpecialColumns
SQLStatistics
SQLTables
SQLTransact