| Oracle® TimesTen In-Memory Database C Developer's Guide Release 11.2.1 Part Number E13066-02 |
|
|
View PDF |
| Oracle® TimesTen In-Memory Database C Developer's Guide Release 11.2.1 Part Number E13066-02 |
|
|
View PDF |
This chapter covers the topics noted below, listing ODBC functions supported by TimesTen and options supported by TimesTen for set and get functions for statements and connections. For complete function definitions, refer to ODBC API reference documentation.
TimesTen supports ODBC 2.5, Extension Level 1, with additional features for Extension Level 2 as indicated in this chapter.
This section lists ODBC function supported by TimesTen, with special notes as applicable.
Table 10-1 Supported ODBC functions
| Function | Notes |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
In TimesTen, |
|
|
|
|
|
|
|
|
|
|
|
Available only to programs using a driver manager. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Available only to programs using a driver manager. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
See "Option support for SQLSetConnectOption and SQLGetConnectOption". |
|
|
You can set or get a cursor name but not reference it, such as in a WHERE CURRENT OF clause for a positioned update or delete. |
|
|
|
|
|
|
|
|
|
|
|
See "Option support for SQLSetStmtOption and SQLGetStmtOption". |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
In addition to its standard functionality, this has special usage with cache groups. See "Managing cache groups". |
|
|
See "Option support for SQLSetConnectOption and SQLGetConnectOption". |
|
|
You can set or get a cursor name but not reference it, such as in a WHERE CURRENT OF clause for a positioned update or delete. |
|
|
See "Option support for SQLSetStmtOption and SQLGetStmtOption". |
|
|
ODBC 1.0 function, replaced by |
|
|
|
|
|
|
|
|
|
|
|
This section discusses TimesTen option support for the ODBC functions SQLSetConnectOption, SQLGetConnectOption, SQLSetStmtOption, and SQLGetStmtOption.
Refer to ODBC API reference documentation for general information about these functions.
Table 10-2 and Table 10-3 document TimesTen support for standard and TimesTen-specific options for the ODBC SQLSetConnectOption and SQLGetConnectOption functions. These functions let you set connection options after the initial connection or retrieve those settings. Some of these correspond to connection attributes you can set during the connection process, as noted.
Note:
An option setting through
SQLSetConnectOption or SQLSetStmtOption overrides the setting of the corresponding connection attribute (as applicable).Table 10-2 Standard options: SQLSetConnectOption, SQLGetConnectOption
| Option | Support |
|---|---|
|
SQL_ACCESS_MODE |
No |
|
SQL_AUTOCOMMIT |
Yes |
|
SQL_CURRENT_QUALIFIER |
No |
|
SQL_LOGIN_TIMEOUT |
No |
|
SQL_MAX_ROWS |
Yes |
|
SQL_NOSCAN |
Yes |
|
SQL_ODBC_CURSORS |
Available only to programs using a driver manager. |
|
SQL_OPT_TRACE |
Available only to programs using a driver manager. |
|
SQL_OPT_TRACEFILE |
Available only to programs using a driver manager. |
|
SQL_PACKET_SIZE |
No |
|
SQL_QUIET_MODE |
No |
|
SQL_TRANSLATE_DLL |
No |
|
SQL_TRANSLATE_OPTION |
No |
|
Supported only if |
Table 10-3 TimesTen options: SQLSetConnectOption, SQLGetConnectOption
| Option | Comments |
|---|---|
|
TT_PREFETCH_CLOSE |
See "Enable TT_PREFETCH_CLOSE for serializable transactions" in Oracle TimesTen In-Memory Database Operations Guide. |
|
TT_CLIENT_TIMEOUT |
For client/server only. Same functionality as the |
|
TT_NLS_SORT |
See "Setting globalization options". Same functionality as the |
|
TT_NLS_LENGTH_SEMANTICS |
See "Setting globalization options". Same functionality as the |
|
TT_NLS_NCHAR_CONV_EXCP |
See "Setting globalization options". Same functionality as the |
|
TT_DYNAMIC_LOAD_ENABLE |
See "Disabling dynamic loading" in Oracle In-Memory Database Cache User's Guide. This has the same functionality as the |
|
TT_DYNAMIC_LOAD_ERROR_MODE |
See "Displaying dynamic load errors" in Oracle In-Memory Database Cache User's Guide. Same functionality as the |
|
TT_REGISTER_FAILOVER_CALLBACK |
Table 10-4 and Table 10-5 document TimesTen support for standard and TimesTen-specific options for the ODBC SQLSetStmtOption and SQLGetStmtOption functions, which let you set or retrieve statement option settings.
Note:
An option setting throughSQLSetConnectOption or SQLSetStmtOption overrides the setting of the corresponding connection attribute (as applicable).Table 10-4 Standard options: SQLSetStmtOption, SQLGetStmtOption
| Option | Support |
|---|---|
|
SQL_ASYNC_ENABLE |
No |
|
SQL_BIND_TYPE |
No |
|
SQL_CONCURRENCY |
No |
|
SQL_CURSOR_TYPE |
No |
|
SQL_KEYSET_SIZE |
No |
|
SQL_MAX_LENGTH |
No. SQL_MAX_LENGTH can be set, but any specified value will be overridden with 0 (return all available data). |
|
SQL_MAX_ROWS |
Yes |
|
SQL_NOSCAN |
Yes |
|
SQL_QUERY_TIMEOUT |
Yes. See "Setting a timeout or threshold for executing SQL statements". |
|
SQL_RETRIEVE_DATA |
No |
|
SQL_ROWSET_SIZE |
No |
|
SQL_SIMULATE_CURSOR |
No |
|
SQL_USE_BOOKMARKS |
No |
Table 10-5 TimesTen options: SQLSetStmtOption, SQLGetStmtOption
| Option | Comment |
|---|---|
|
TT_PREFETCH_COUNT |
|
|
TT_QUERY_THRESHOLD |
See "Setting a timeout or threshold for executing SQL statements". |
|
TT_PRIVATE_COMMANDS |
Commands are not shared with any other connection. See "PrivateCommands" in Oracle TimesTen In-Memory Database Reference. |
|
Determines whether a specific prepared statement will be passed through to Oracle by the passthrough feature of IMDB Cache. The value returned by Note: In TimesTen, this option is supported only with See "Determining the passthrough setting for a statement" in Oracle In-Memory Database Cache User's Guide. |
|
 Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|