Nonstop Database, HiRDB Version 9 UAP Development Guide
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.