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:

• The SQL data type returned when the column attribute is acquired is as follows:
  When the HiRDB data type is CHAR, MCHAR, or NCHAR: SQL_WCHAR
  When the HiRDB data type is VARCHAR, MVARCHAR, or NVARCHAR: SQL_WVARCHAR
  
• When the column attribute is acquired, if the HiRDB data type is character string system data type, the column definition length x 2 is set for the column length. For example, in case of char(10), 20 is returned for the column length.