HiRDB provides ODBC functions, and you can access HiRDB on a server from a UAP that utilizes these ODBC functions. Table 13-2 shows the ODBC functions provided by HiRDB.
Table 13-2 ODBC functions provided by HiRDB
Classification | ODBC functions | ODBC2.0 driver | ODBC3.0 driver | ||
---|---|---|---|---|---|
Provided? | Expansion level | Provided? | Expansion level | ||
Connection to data source | SQLAllocEnv | Y | Core | ![]() | ![]() |
SQLAllocHandle | ![]() | ![]() | Y | Core | |
SQLAllocConnect | Y | Core | ![]() | ![]() | |
SQLConnect | Y | Core | Y | Core | |
SQLDriverConnect | Y | 1 | Y | Core | |
SQLBrousConnect | Y | 2 | Y | 1 | |
Driver and data source information acquisition | SQLDataSources | Y1 | 2 | Y1 | Core |
SQLDrivers | ![]() | ![]() | Y1 | Core | |
SQLGetInfo | Y | 1 | Y | Core | |
SQLGetFunctions | ![]() | ![]() | Y1 | Core | |
SQLGetTypeInfo | Y | 1 | Y | Core | |
Driver option setting and acquisition | SQLSetConnectOption | Y | 1 | ![]() | ![]() |
SQLGetConnectOption | Y | 1 | ![]() | ![]() | |
SQLSetStmtOption | Y | 1 | ![]() | ![]() | |
SQLGetStmtOption | Y | 1 | ![]() | ![]() | |
SQLSetConnectAttr | ![]() | ![]() | Y | Core | |
SQLGetConnectAttr | ![]() | ![]() | Y | Core | |
SQLSetEnvAttr | ![]() | ![]() | Y | Core | |
SQLGetEnvAttr | ![]() | ![]() | Y | Core | |
SQLSetStmtAttr | ![]() | 1 | Y | Core | |
SQLGetStmtAttr | ![]() | 1 | Y | Core | |
Descriptor value setup | SQLGetDescField | ![]() | ![]() | Y | Core |
SQLGetDescRec | ![]() | ![]() | Y | Core | |
SQLSetDescField | ![]() | ![]() | Y | Core | |
SQLSetDescRec | ![]() | ![]() | Y | Core | |
SQLCopyDesc | ![]() | ![]() | Y | Core | |
SQL request creation | SQLAllocStmt | Y | Core | ![]() | ![]() |
SQLPrepare | Y | Core | Y | Core | |
SQLBindParameter | Y | 11 | Y | Core | |
SQLSetParam2 | Y | 1 | ![]() | ![]() | |
SQLGetCursorName | Y | Core | Y | Core | |
SQLSetCursorName | Y | Core | Y | Core | |
SQLDescribeParam | Y | 2 | ![]() | ![]() | |
SQLNumParam | Y | 2 | ![]() | ![]() | |
SQLParamOptions | N | 2 | ![]() | ![]() | |
SQLSetScrollOptions | N3 | 2 | N | 2 | |
SQL execution | SQLExecute | Y | Core | Y | Core |
SQLExecDirect | Y | Core | Y | Core | |
SQLNativeSql | Y | 2 | Y | Core | |
SQLDescribeParams | ![]() | ![]() | Y | 2 | |
SQLNumParams | ![]() | ![]() | Y | Core | |
SQLParamData | Y | 1 | Y | Core | |
SQLPutData | Y | 1 | Y | Core | |
Execution result and execution result information acquisition | SQLRowCount | Y | Core | Y | Core |
SQLNumResultCols | Y | Core | Y | Core | |
SQLDescribeCol | Y | Core | Y | Core | |
SQLColAttributes | Y | Core | Y | Core | |
SQLBindCol | Y | Core | Y | Core | |
SQLFetch | Y | Core | Y | Core | |
SQLFetchScroll | ![]() | ![]() | Y4 | Core | |
SQLExtendedFetch | N3 | 2 | Y | Core | |
SQLGetData | Y | 1 | Y | Core | |
SQLSetPos | N3 | 2 | Y4 | 1 | |
SQLBulkOperations | ![]() | ![]() | N | 1 | |
SQLMoreResults | Y | 2 | Y | 1 | |
SQLError | Y | Core | ![]() | ![]() | |
SQLGetDiagField | ![]() | ![]() | Y | Core | |
SQLGetDiagRec | ![]() | ![]() | Y | Core | |
Data source system information acquisition | SQLColumnPrivileges | Y | 2 | Y | 2 |
SQLColumns | Y | 1 | Y | Core | |
SQLForeignKeys | Y | 2 | Y | 2 | |
SQLPrimaryKeys | Y | 2 | Y | 1 | |
SQLProcedureColumns | Y | 2 | Y | 1 | |
SQLProcedure | Y | 2 | Y | 1 | |
SQLSpecialColumns | Y | 1 | Y | Core | |
SQLStatistics | Y | 1 | Y | Core | |
SQLTablePrivileges | Y | 2 | Y | 2 | |
SQLTables | Y | 1 | Y | Core | |
SQL execution termination | SQLFreestmt | Y | Core | Y | Core |
SQLCloseCursor | ![]() | ![]() | Y | Core | |
SQLCancel | Y | Core | Y | Core | |
SQLTransact | Y | Core | Y | Core | |
SQLEndTran | ![]() | ![]() | Y | Core | |
Disconnection | SQLDisconnect | Y | Core | Y | Core |
SQLFreeConnect | Y | Core | ![]() | ![]() | |
SQLFreeEnv | Y | Core | ![]() | ![]() | |
SQLFreeHandle | ![]() | ![]() | Y | Core |