Nonstop Database, HiRDB Version 9 UAP Development Guide
This section explains the ODBC functions that can be used by a UAP in Unicode.
The following table shows the ODBC functions that can be used by a UAP in Unicode.
Table 14-24 ODBC functions that can be used by a UAP in Unicode
Classification | Function name | Function |
---|---|---|
Connection with data source | SQLConnectW | Connects to a specific driver based on the data source name, authorization identifier, and password. |
SQLDriverConnectW | Connects to a specific driver based on the connection character string. Also, requests to the driver manager and driver that a connection dialog box be displayed for the user. | |
SQLBrowseConnectW | Returns the continuous level connection attributes and valid attribute values. If a value is specified for each connection attribute, connects to the data source. | |
SQLDriversW | Returns the installed driver and a list of its attributes. | |
Driver and data source information | SQLDataSources | Returns a list of data sources that can be used. |
SQLGetInfoW | Returns a specific driver and data source information. | |
Setting and acquisition of driver options | SQLSetConnectAttrW | Sets the connection attributes. |
SQLGetConnectAttrW | Returns the connection attribute values. | |
SQLSetStmtAttrW | Sets the statement attribute. | |
SQLGetStmtAttrW | Returns the statement attribute value. | |
Descriptor setting and acquisition | SQLSetDescFieldW | Sets one descriptor field. |
SQLGetDescFieldW | Returns one descriptor field value. | |
SQLSetDescRecW | Sets multiple descriptor fields. | |
SQLGetDescRecW | Returns multiple descriptor field values. | |
SQLPrepareW | Prepares an SQL statement to be executed later. | |
SQL request creation | SQLSetCursorNameW | Specifies a cursor name. |
SQLGetCursorNameW | Returns the cursor name related to the statement handle. | |
SQL execution | SQLExecDirectW | Executes a statement. |
SQLNativeSqlW | Returns the text of the SQL statement that the driver converted. | |
Acquisition of execution results and execution results information | SQLDescribeColW | Describes the results set columns. |
SQLColAttributeW | Describes the attributes of the results set columns. | |
SQLGetDiagFieldW | Returns additional diagnosis information (one field of the diagnosis data structure). | |
SQLGetDiagRecW | Returns additional diagnosis information (multiple fields of the diagnosis data structure). | |
SQLColumnPrivilegesW | Returns a list of columns and privileges related to one or more tables. | |
Acquisition of data source system information | SQLColumnsW | Returns a list of column names of specified tables. |
SQLForeignKeysW | Returns a list of column names that compose an external key when there is an external key in a specified table. | |
SQLPrimaryKeysW | Returns a list of column names that compose a main key of a specified table. | |
SQLProcedureColumnsW | Returns a list of input or output parameters and columns that compose the results set of a specified procedure. | |
SQLProceduresW | Returns a list of procedure names in a specified data source. | |
SQLSpecialColumnsW | Returns the optimum column for identifying lines in a specified table or the column information that is corrected automatically when line values are changed by a transaction. | |
SQLStatisticsW | Returns statistical information related to a single table and a list of indexes related to the table. | |
SQLTablePrivilegesW | Returns a list of tables and the privileges related to each table. | |
SQLTablesW | Returns a list of table names in the specified data source. |
The following notes apply when UCS2_UJIS or UCS2_UTF8 is set in PDCLTCNVMODE of the client environment definition:
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.