![[Contents]](FIGURE/CONTENT.GIF)
Nonstop Database, HiRDB Version 9 UAP Development Guide
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
HiRDB provides ODBC functions, and you can access HiRDB on a server from a UAP that utilizes these ODBC functions. The following table shows the ODBC functions provided by HiRDB.
Table 14-3 ODBC functions provided by HiRDB
| Classification | ODBC functions | ODBC2.0 driver | ODBC 3.5 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 | |
| SQLBrowseConnect | Y | 2 | Y | 1 | |
| Driver and data source information acquisition | SQLDataSources | Y#1 | 2 | Y#1 | Core |
| SQLDrivers | -- | -- | Y#1 | Core | |
| SQLGetInfo | Y | 1 | Y | Core | |
| SQLGetFunctions | -- | -- | Y | 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 | |
| SQLSetParam#2 | Y | 1 | -- | -- | |
| SQLGetCursorName | Y | Core | Y | Core | |
| SQLSetCursorName | Y | Core | Y | Core | |
| SQLDescribeParam | Y | 2 | -- | -- | |
| SQLNumParam | Y | 2 | -- | -- | |
| SQLDescribeParams | -- | -- | Y | 2 | |
| SQLNumParams | -- | -- | Y | Core | |
| SQLParamOptions | N | 2 | -- | -- | |
| SQLSetScrollOptions | N#3 | 2 | N | 2 | |
| SQL execution | SQLExecute | Y | Core | Y | Core |
| SQLExecDirect | Y | Core | Y | Core | |
| SQLNativeSql | Y | 2 | 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 | -- | -- | |
| SQLColAttribute | -- | -- | Y | Core | |
| SQLBindCol | Y | Core | Y | Core | |
| SQLFetch | Y | Core | Y | Core | |
| SQLFetchScroll | -- | -- | Y#4 | Core | |
| SQLExtendedFetch | N#3 | 2 | Y | Core | |
| SQLGetData | Y | 1 | Y | Core | |
| SQLSetPos | N#3 | 2 | Y#4 | 1 | |
| SQLBulkOperations | -- | -- | N | 1 | |
| SQLMoreResults#5 | 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#6 | 2 | Y#6 | 2 | |
| SQLPrimaryKeys | Y#6 | 2 | Y#6 | 1 | |
| SQLProcedureColumns | Y | 2 | Y | 1 | |
| SQLProcedure | Y | 2 | Y | 1 | |
| SQLSpecialColumns | Y#6 | 1 | Y#6 | 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 | |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.