B. Function Property Differences

This appendix lists differences in function properties between the DBMaker ODBC API and the Microsoft ODBC 3.0 API. These differences include useful extended options for connection and statements supported by DBMaker that have slightly different behavior that the standard ODBC functions.

B.1 SQLPutData

ODBC 3.0 allows the SQLPutData function to send data in parts to a column with CHAR, BINARY, LONG VARCHAR and LONG VARBINARY data types. However, DBMaker restricts the data types that can be used with the SQLPutData function to LONG VARCHAR and LONG VARBINARY.

B.2 SQLColumns

DBMaker does not allow you to retrieve information from temporary tables by using the SQLColumns function.

B.3 SQLTables

DBMaker does not allow you to retrieve information from temporary tables by using the SQLTables function.

B.4 SQLDriverConnect

In the SQLDriverConnect function, the behavior of the prompt flags SQL_DRIVER_PROMPT and SQL_DRIVER_COMPLETE_REQUIRED is the same as the behavior or the prompt flag SQL_DRIVER_COMPLETE. (Prompt behaviour is controlled by the fDriverComplete argument of SQLDriverConnect.)

B.5 SQLBindParameter

In the SQLBindParameter function, the behavior when pcbValue is set to SQL_LEN_DATA_AT_EXEC(length) is the same as the behavior when pcbValue is set to SQL_DATA_AT_EXEC. The length value in SQL_LEN_DATA_AT_EXEC (length) will be ignored.

B.6 Positioned DELETE or UPDATE

An SQL statement containing a positioned DELETE or positioned UPDATE usually refers to a cursor name. If the cursor specified by the cursor name is not open, DBMaker will detect this situation and return error 34000 at execution time (not preparation time).

B.7 SQLSetConnectOption

In the SQLSetConnectOption function there are several extended connection options that are proprietary to DBMaker. These options allow you to set some of the advanced connection options available when using a DBMaker data source. The extended options are:

SQL_AUTOCOMMIT
SQL_TXN_ISOLATION
SQL_DB_MODE
SQL_JOURNAL_MODE
SQL_LOCK_TIMEOUT
SQL_BACKUP_MODE
SQL_DATE_INPUT_FORMAT
SQL_DATE_OUTPUT_FORMAT
SQL_TIME_INPUT_FORMAT
SQL_TIME_OUTPUT_FORMAT
SQL_SYSINFO_CLEAR
SQL_LOGIN_TIMEOUT
SQL_CB_MODE
SQL_INPUT_MODE

B.8 SQLGetConnectOption

In the SQLGetConnectOption function there are several extended connection options that are proprietary to DBMaker. These options allow you to get information on some of the advanced connection options available when using a DBMaker data source. The extended options are:

SQL_AUTOCOMMIT
SQL_TXN_ISOLATION
SQL_DB_MODE
SQL_JOURNAL_MODE
SQL_LOCK_TIMEOUT
SQL_BACKUP_MODE
SQL_DATE_INPUT_FORMAT
SQL_DATE_OUTPUT_FORMAT
SQL_TIME_INPUT_FORMAT
SQL_TIME_OUTPUT_FORMAT
SQL_LOGIN_TIMEOUT
SQL_CB_MODE
SQL_INPUT_MODE
SQL_ACCESS_MODE
SQL_CONNECT_ID