skip to main content
Reference : ODBC API and Scalar Functions : API Functions
  

Try DataDirect Drivers Now

API Functions

Your Progress DataDirect for ODBC driver is Level 1 compliant, that is, it supports all ODBC Core and Level 1 functions. It also supports a limited set of Level 2 functions, as described in the following table.
Table 13. 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 driver supports are listed in the following table. Any additions to these supported functions or differences in the support of specific functions are listed in "ODBC Compliance".
Table 14. 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