13.9 Executing a UAP in Unicode

This section explains the ODBC functions that can be used by a UAP in Unicode.

Organization of this section
(1) ODBC functions that can be used by a UAP in Unicode
(2) Notes

(1) ODBC functions that can be used by a UAP in Unicode

Table 13-6 shows the ODBC functions that can be used by a UAP in Unicode.

Table 13-6 ODBC functions that can be used by a UAP in Unicode

ClassificationFunction nameFunction
Connection with data sourceSQLConnectWConnects to a specific driver based on the data source name, authorization identifier, and password.
SQLDriverConnectWConnects 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.
SQLBrowseConnectWReturns the continuous level connection attributes and valid attribute values. If a value is specified for each connection attribute, connects to the data source.
SQLDriversWReturns the installed driver and a list of its attributes.
Driver and data source informationSQLDataSourcesReturns a list of data sources that can be used.
SQLGetInfoWReturns a specific driver and data source information.
Setting and acquisition of driver optionsSQLSetConnectAttrWSets the connection attributes.
SQLGetConnectAttrWReturns the connection attribute values.
SQLSetStmtAttrWSets the statement attribute.
SQLGetStmtAttrWReturns the statement attribute value.
Descriptor setting and acquisitionSQLSetDescFieldWSets one descriptor field.
SQLGetDescFieldWReturns one descriptor field value.
SQLSetDescRecWSets multiple descriptor fields.
SQLGetDescRecWReturns multiple descriptor field values.
SQLPrepareWPrepares an SQL statement to be executed later.
SQL request creationSQLSetCursorNameWSpecifies a cursor name.
SQLGetCursorNameWReturns the cursor name related to the statement handle.
SQL executionSQLExecDirectWExecutes a statement.
SQLNativeSqlWReturns the text of the SQL statement that the driver converted.
Acquisition of execution results and execution results informationSQLDescribeColWDescribes the results set columns.
SQLColAttributeWDescribes the attributes of the results set columns.
SQLGetDiagFieldWReturns additional diagnosis information (one field of the diagnosis data structure).
SQLGetDiagRecWReturns additional diagnosis information (multiple fields of the diagnosis data structure).
SQLColumnPrivilegesWReturns a list of columns and privileges related to one or more tables.
Acquisition of data source system informationSQLColumnsWReturns a list of column names of specified tables.
SQLForeignKeysWReturns a list of column names that compose an external key when there is an external key in a specified table.
SQLPrimaryKeysWReturns a list of column names that compose a main key of a specified table.
SQLProcedureColumnsWReturns a list of input or output parameters and columns that compose the results set of a specified procedure.
SQLProceduresWReturns a list of procedure names in a specified data source.
SQLSpecialColumnsWReturns the optimum column for identifing lines in a specified table or the column information that is corrected automatically when line values are changed by a transaction.
SQLStatisticsWReturns statistical information related to a single table and a list of indexes related to the table.
SQLTablePrivilegesWReturns a list of tables and the privileges related to each table.
SQLTablesWReturns a list of table names in the specified data source.

(2) Notes

The following notes apply when UCS2_UJIS or UCS2_UTF8 is set in PDCLTCNVMODE of the client environment definition: