You can use the following supported ODBC functions and
grammar to query and select data.
ODBC API
- SQLAllocHandle
- SQLDriverConnect
- SQLBindCol
- SQLEndTran
- SQLBindParameter
- SQLExecDirect (Refer to SELECT Statement Syntax)
- SQLBrowseConnect
- SQLExecute
- SQLBulkOperations (always returns HYC00; HYC00 is
the SQL state for “Optional feature not implemented”)
- SQLExtendedFetch (only FETCH_NEXT supported)
- SQLCancel
- SQLFetch
- SQLCloseCursor
- SQLFetchScroll (only FETCH_NEXT supported)
- SQLColAttribute
- SQLForeignKeys
- SQLColumns
- SQLFreeHandle
- SQLConnect
- SQLFreeStmt
- SQLCopyDesc
- SQLGetConnectAttr
- SQLDescribeCol
- SQLGetCursorName
- SQLDescribeParam
- SQLGetData
- SQLDisconnect
- SQLGetDescField
- SQLGetDescRec
- SQLPrimaryKeys
- SQLGetDiagField
- SQLPutData
- SQLGetDiagRec
- SQLRowCount
- SQLGetEnvAttr
- SQLSetConnectAttr
- SQLGetFunctions
- SQLSetCursorName
- SQLGetInfo
- SQLSetDescField
- SQLGetStmtAttr
- SQLSetDescRec
- SQLGetTypeInfo
- SQLSetEnvAttr
- SQLMoreResults
- SQLSetPos (always returns HYC00)
- SQLNativeSql
- SQLSetStmtAttr
- SQLNumParams
- SQLSpecialColumns
- SQLNumResultCols
- SQLStatistics
- SQLParamData
- SQLTables
- SQLPrepare (Refer to SELECT Statement Syntax)