13.4 ODBC functions provided by HiRDB

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

ClassificationODBC functionsODBC2.0 driverODBC3.0 driver
Provided?Expansion levelProvided?Expansion level
Connection to data sourceSQLAllocEnvYCore[Figure][Figure]
SQLAllocHandle[Figure][Figure]YCore
SQLAllocConnectYCore[Figure][Figure]
SQLConnectYCoreYCore
SQLDriverConnectY1YCore
SQLBrousConnectY2Y1
Driver and data source information acquisitionSQLDataSourcesY12Y1Core
SQLDrivers[Figure][Figure]Y1Core
SQLGetInfoY1YCore
SQLGetFunctions[Figure][Figure]Y1Core
SQLGetTypeInfoY1YCore
Driver option setting and acquisitionSQLSetConnectOptionY1[Figure][Figure]
SQLGetConnectOptionY1[Figure][Figure]
SQLSetStmtOptionY1[Figure][Figure]
SQLGetStmtOptionY1[Figure][Figure]
SQLSetConnectAttr[Figure][Figure]YCore
SQLGetConnectAttr[Figure][Figure]YCore
SQLSetEnvAttr[Figure][Figure]YCore
SQLGetEnvAttr[Figure][Figure]YCore
SQLSetStmtAttr[Figure]1YCore
SQLGetStmtAttr[Figure]1YCore
Descriptor value setupSQLGetDescField[Figure][Figure]YCore
SQLGetDescRec[Figure][Figure]YCore
SQLSetDescField[Figure][Figure]YCore
SQLSetDescRec[Figure][Figure]YCore
SQLCopyDesc[Figure][Figure]YCore
SQL request creationSQLAllocStmtYCore[Figure][Figure]
SQLPrepareYCoreYCore
SQLBindParameterY11YCore
SQLSetParam2Y1[Figure][Figure]
SQLGetCursorNameYCoreYCore
SQLSetCursorNameYCoreYCore
SQLDescribeParamY2[Figure][Figure]
SQLNumParamY2[Figure][Figure]
SQLParamOptionsN2[Figure][Figure]
SQLSetScrollOptionsN32N2
SQL executionSQLExecuteYCoreYCore
SQLExecDirectYCoreYCore
SQLNativeSqlY2YCore
SQLDescribeParams[Figure][Figure]Y2
SQLNumParams[Figure][Figure]YCore
SQLParamDataY1YCore
SQLPutDataY1YCore
Execution result and execution result information acquisitionSQLRowCountYCoreYCore
SQLNumResultColsYCoreYCore
SQLDescribeColYCoreYCore
SQLColAttributesYCoreYCore
SQLBindColYCoreYCore
SQLFetchYCoreYCore
SQLFetchScroll[Figure][Figure]Y4Core
SQLExtendedFetchN32YCore
SQLGetDataY1YCore
SQLSetPosN32Y41
SQLBulkOperations[Figure][Figure]N1
SQLMoreResultsY2Y1
SQLErrorYCore[Figure][Figure]
SQLGetDiagField[Figure][Figure]YCore
SQLGetDiagRec[Figure][Figure]YCore
Data source system information acquisitionSQLColumnPrivilegesY2Y2
SQLColumnsY1YCore
SQLForeignKeysY2Y2
SQLPrimaryKeysY2Y1
SQLProcedureColumnsY2Y1
SQLProcedureY2Y1
SQLSpecialColumnsY1YCore
SQLStatisticsY1YCore
SQLTablePrivilegesY2Y2
SQLTablesY1YCore
SQL execution terminationSQLFreestmtYCoreYCore
SQLCloseCursor[Figure][Figure]YCore
SQLCancelYCoreYCore
SQLTransactYCoreYCore
SQLEndTran[Figure][Figure]YCore
DisconnectionSQLDisconnectYCoreYCore
SQLFreeConnectYCore[Figure][Figure]
SQLFreeEnvYCore[Figure][Figure]
SQLFreeHandle[Figure][Figure]YCore
Legend:
Y: The applicable ODBC function is provided.
N: The applicable ODBC function is not provided.
[Figure]: Not applicable
1: Level 1
2: Level 2
Core: Core level
1 This function is provided by the drive manager.
2 Although the SQLSetParam function was included in SQLBindParameter beginning with ODBC 2.0, this function is provided to maintain compatibility with applications that do not support ODBC 2.0.
3 Because this function is installed in the ODBC2.0 cursor library, the range of functions specified by the cursor library can be used. To use SQLExtendedFetch, set up a cursor library. For details on setting up a cursor library, see 13.7 Setting cursor libraries.
4 To use these ODBC functions, you must use the cursor library provided by Microsoft.