When a UAP uses ODBC functions to access the HiRDB system in the server, not all HiRDB facilities are available to the UAP. Table 13-4 lists the facilities that can be used by such a UAP.

Table 13-4 Available facilities

Facility	Availability
Obtaining special column information
Obtaining index information	U
Using date and time data types	U1
Using repetition columns	NU3
Using array columns
Obtaining table and column headers
Asynchronous processing	NU
Using the escape character for the LIKE predicate	U
Obtaining an updated row count	U
Setting the timeout value for logging in	NU
Using Japanese data types	U2
Executing definition SQL statements	U

U: Can be used.

NU: Cannot be used.

: Not a DBMS function

¹ The INTERVAL YEAR TO DAY data type cannot be used.

² The database data types are reported without change.

³ A repetition column can be accessed if it has a simple structure without repeated ? parameters.

Example

Column C1 of table T1 is a repetition column.

SELECT C1[1],C1[2] FROM T1             A
SELECT C1 FROM T1                      
INSERT INTO T1 VALUES(ARRAY[?,?])      A
INSERT INTO T1 VALUES(?)               

A: Can be accessed

: Cannot be accessed

The SQLGetCursorName function obtains the user cursor name that was set with the SQLSetCursorName function. If no cursor name has been set, the SQLGetCursorName function cannot obtain a system-defined cursor. Therefore, set an appropriate user cursor name to update or delete an item with a cursor.

The options that can be set with the SQLSetConnectOption or SQLGetConnectOption function are limited. Table 13-5 shows the options that can be set.

Table 13-5 Options that can be set with the SQLSetConnectOption and SQLGetConnectOption functions

Option	Setting
SQL_ACCESS_MODE	SQL_MODE_READ_WRITE
SQL_AUTOCOMMIT	SQL_AUTOCOMMIT_OFF or SQL_AUTOCOMMIT_ON
SQL_LOGIN_TIMEOUT
SQL_TRANSLATE_DLL
SQL_TRANSLATE_OPTION
SQL_TXN_ISOLATION

: Cannot be set