Oracle® TimesTen In-Memory Database C Developer's Guide Release 11.2.1 Part Number E13066-08 |
|
|
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 |
|
|
|
|
|
|
|
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 |
|
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.
Also see "Option support for SQLSetStmtOption and SQLGetStmtOption". Those options can also be set using SQLSetConnectOption
, in which case the value serves as a default for all statements on the connection.
Note:
An option setting throughSQLSetConnectOption
or SQLSetStmtOption
overrides the setting of the corresponding connection attribute (as applicable).Table 10-2 Standard options: SQLSetConnectOption, SQLGetConnectOption
Option | Support |
---|---|
|
No |
|
Yes |
|
No |
|
No |
|
Yes |
|
Yes |
|
Available only to programs using a driver manager. |
|
Available only to programs using a driver manager. |
|
Available only to programs using a driver manager. |
|
No |
|
No |
|
No |
|
No |
Supported only if |
Table 10-3 TimesTen options: SQLSetConnectOption, SQLGetConnectOption
Option | Comments |
---|---|
|
For client/server only. Same functionality as the |
|
See "Disabling dynamic loading" in Oracle In-Memory Database Cache User's Guide. This has the same functionality as the |
|
See "Displaying dynamic load errors" in Oracle In-Memory Database Cache User's Guide. Same functionality as the |
|
See "Setting globalization options". Same functionality as the |
|
See "Setting globalization options". Same functionality as the |
|
See "Setting globalization options". Same functionality as the |
|
See "Enable TT_PREFETCH_CLOSE for Serializable transactions" in Oracle TimesTen In-Memory Database Operations Guide. |
|
|
|
See "Setting up user-specified parallel replication". Same functionality as the |
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.
To set an option default value for all statements associated with a connection, use SQLSetConnectOption
.
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 |
---|---|
|
No |
|
No |
|
No |
|
No |
|
No |
|
No. |
|
Yes |
|
Yes |
|
Yes. See "Setting a timeout or threshold for executing SQL statements". |
|
No |
|
No |
|
No |
|
No |
Table 10-5 TimesTen options: SQLSetStmtOption, SQLGetStmtOption
Option | Comment |
---|---|
|
|
|
See "Setting a threshold value for SQL statements". This is to specify a time threshold for SQL statements, in seconds, after which TimesTen will write a warning to the support log and throw an SNMP trap. |
|
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 passthrough status". Also see "Setting a passthrough level" in Oracle In-Memory Database Cache User's Guide. |