TimesTen ODBC 2.5 Support

This section covers these topics for TimesTen 2.5 support.

Using ODBC 2.5 With TimesTen

An ODBC 2.5 application not using a driver manager will continue to work with the TimesTen ODBC driver through its call to SQLAllocEnv.

Tip:

Because TimesTen Release 22.1 is a major release, you should recompile and relink existing ODBC applications. Also see ODBC API Incompatibilities With Previous Versions of TimesTen.

It is also advisable to link your applications dynamically rather than statically.

ODBC 2.5 Function Support

TimesTen supports certain ODBC 2.5 functions.

Note:

The TimesTen ODBC driver supports wide-character (W) function versions for applications not using a generic driver manager, as indicated in Table 10-11.
In ODBC 2.5, TimesTen supports some ODBC 3.0 handle types (such as SQLHDBC and SQLHENV) as well as ODBC 2.0 handle types (such as HDBC and HENV). TimesTen recommends using ODBC 3.0 handle types. The FAR modifier that is mentioned in ODBC 2.0 documentation is not required.

Table 10-11 Supported ODBC 2.5 Functions

Function	Notes
`SQLAllocConnect`	No notes
`SQLAllocEnv`	No notes
`SQLAllocStmt`	No notes
`SQLBindCol`	No notes
`SQLBindParameter`	See SQLBindParameter Function.
`SQLCancel`	`SQLCancel` can cancel the following: An operation running on an `hstmt` on another thread An operation running on an `hstmt` that needs data `SQLCancel` cannot cancel the following: Cache administrative operations Do not call `SQLCancel` directly from a signal handler. Such code may not be portable.
`SQLColAttributes` and `SQLColAttributesW`	See Column Descriptor Support for ODBC 2.5 SQLColAttributes. Also see ODBC 2.5 Function Signatures That Have Changed.
`SQLColumnPrivileges`	Call returns "driver not capable".
`SQLColumns` and `SQLColumnsW`	For catalog functions, TimesTen supports only an empty string or `NULL` as the qualifier.
`SQLConnect` and `ttSQLConnectW`	Note the TimesTen name for the "W" function.
`SQLDataSources` and `SQLDataSourcesW`	Available only to programs using a driver manager.
`SQLDescribeCol` and `SQLDescribeColW`	No notes
`SQLDescribeParam`	No notes
`SQLDisconnect`	No notes
`SQLDriverConnect` and `SQLDriverConnectW`	No notes
`SQLDrivers` and `SQLDriversW`	Available only to programs using a driver manager.
`SQLError` and `SQLErrorW`	Native error codes are TimesTen errors. You may receive generic errors such as, "Execution at Oracle failed. Oracle error code `nnn`." When using `SQLError` or `SQLErrorW`: Use `TT_MAX_MESSAGE_LENGTH` (which is a higher limit) instead of `SQL_MAX_MESSAGE_LENGTH` (which is a limit of 512 bytes). Handle a possible return of `SQL_SUCCESS_WITH_INFO` (for example, in case the message length exceeded the input buffer size).
`SQLExecDirect`	See `SQLExecute`.
`SQLExecute`	TimesTen does not support asynchronous statement execution. (TimesTen does not support the `SQL_ASYNC_ENABLE` statement option, as noted later in this chapter.)
`SQLFetch`	The return code is defined as `SQL_NO_DATA_FOUND` when no more rows are returned. `SQL_NO_DATA_FOUND` is defined in `sqlext.h`, which is included by `timesten.h`.
`SQLForeignKeys` and `SQLForeignKeysW`	For catalog functions, TimesTen supports only an empty string or `NULL` as the qualifier.
`SQLFreeConnect`	No notes
`SQLFreeEnv`	No notes
`SQLFreeStmt`	No notes
`SQLGetConnectOption` and `SQLGetConnectOptionW`	See Option Support for ODBC 2.5 SQLSetConnectOption and SQLGetConnectOption. Also see ODBC 2.5 Function Signatures That Have Changed. Support is added for the TimesTen driver manager (TTDM). This is documented in Attribute Support for ODBC 3.5 SQLSetConnectAttr and SQLGetConnectAttr.
`SQLGetCursorName` and `SQLGetCursorNameW`	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. TimesTen does not support positioned update or delete statements.
`SQLGetData`	See Avoid SQLGetData.
`SQLGetFunctions`	No notes
`SQLGetInfo` and `SQLGetInfoW`	See Information Type Support for ODBC 2.5 SQLGetInfo. Also see ODBC 2.5 Function Signatures That Have Changed.
`SQLGetStmtOption`	See Option Support for ODBC 2.5 SQLSetStmtOption and SQLGetStmtOption. Also see ODBC 2.5 Function Signatures That Have Changed.
`SQLGetTypeInfo` and `SQLGetTypeInfoW`	For catalog functions, TimesTen supports only an empty string or `NULL` as the qualifier.
`SQLNativeSql` and `SQLNativeSqlW`	No notes
`SQLNumParams`	No notes
`SQLNumResultCols`	No notes
`SQLParamData`	No notes
`SQLParamOptions`	See ODBC 2.5 Function Signatures That Have Changed.
`SQLPrepare` and `SQLPrepareW`	No notes
`SQLPrimaryKeys` and `SQLPrimaryKeysW`	For catalog functions, TimesTen supports only an empty string or `NULL` as the qualifier.
`SQLProcedureColumns` and `SQLProcedureColumnsW`	For catalog functions, TimesTen supports only an empty string or `NULL` as the qualifier.
`SQLProcedures` and `SQLProceduresW`	For catalog functions, TimesTen supports only an empty string or `NULL` as the qualifier.
`SQLPutData`	No notes
`SQLRowCount`	In addition to its standard functionality, this is used with TimesTen cache groups. See Retrieving Information About Cache Groups.
`SQLSetConnectOption` and `SQLSetConnectOptionW`	See Option Support for ODBC 2.5 SQLSetConnectOption and SQLGetConnectOption under the next section. Also see ODBC 2.5 Function Signatures That Have Changed.
`SQLSetCursorName` and `SQLSetCursorNameW`	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.
`SQLSetParam`	This is an ODBC 1.0 function, replaced by `SQLBindParameter` in ODBC 2.0. Retained for backward compatibility.
`SQLSetPos`	Call returns "driver not capable".
`SQLSetStmtOption`	See Option Support for ODBC 2.5 SQLSetStmtOption and SQLGetStmtOption. Also see ODBC 2.5 Function Signatures That Have Changed.
`SQLSpecialColumns` and `SQLSpecialColumnsW`	TimesTen supports only the `SQL_BEST_ROWID` option. For catalog functions, TimesTen supports only an empty string or `NULL` as the qualifier.
`SQLStatistics` and `SQLStatisticsW`	For catalog functions, TimesTen supports only an empty string or `NULL` as the qualifier.
`SQLTablePrivileges`	Call returns "driver not capable".
`SQLTables` and `SQLTablesW`	For catalog functions, TimesTen supports only an empty string or `NULL` as the qualifier.
`SQLTransact`	No notes

Option Support for ODBC 2.5 SQLSetConnectOption and SQLGetConnectOption

The ODBC 2.5 SQLSetConnectOption and SQLGetConnectOption functions enable you to 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.

Table 10-12 lists standard options supported by TimesTen for The ODBC 2.5 SQLSetConnectOption and SQLGetConnectOption functions.

For TimesTen-specific connection options, see Table 10-4. These options are supported for both ODBC 2.5 and ODBC 3.5.

Also see Option Support for ODBC 2.5 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 through SQLSetConnectOption or SQLSetStmtOption overrides the setting of the corresponding connection attribute (as applicable).
The documentation here also applies to SQLSetConnectOptionW and SQLGetConnectOptionW.
Where TimesTen connection attributes are mentioned as being equivalent to ODBC connection options, see Connection Attributes in Oracle TimesTen In-Memory Database Reference.

Table 10-12 Standard connection options (ODBC 2.5)

Option	Notes
`SQL_AUTOCOMMIT`	No notes
`SQL_MAX_ROWS`	See ODBC 2.5 Function Signatures That Have Changed (refer to `SQLGetStmtOption` or `SQLSetStmtOption` there).
`SQL_NOSCAN`	No notes
`SQL_ODBC_CURSORS`	Supported for programs using a driver manager
`SQL_OPT_TRACE`	Supported for programs using a driver manager
`SQL_OPT_TRACEFILE`	Supported for programs using a driver manager
`SQL_TXN_ISOLATION`	Supported for `vParam` is `SQL_TXN_READ_COMMITTED` or `SQL_TXN_SERIALIZABLE` See Prefetching Multiple Rows of Data for information about the relationship between prefetching and isolation level. Also see Concurrency Control Through Isolation and Locking in Oracle TimesTen In-Memory Database Operations Guide and Isolation in Oracle TimesTen In-Memory Database Reference.

Option Support for ODBC 2.5 SQLSetStmtOption and SQLGetStmtOption

The ODBC 2.5 SQLSetStmtOption and SQLGetStmtOption functions enable you to set or retrieve statement option settings.

Table 10-13 lists standard options supported by TimesTen for the ODBC 2.5 SQLSetStmtOption and SQLGetStmtOption functions, with notes about the support.

For TimesTen-specific statement options, see Table 10-6. These options are supported for both ODBC 2.5 and ODBC 3.5.

To set an option default value for all statements associated with a connection, use SQLSetConnectOption.

Note:

An option setting through SQLSetConnectOption or SQLSetStmtOption overrides the setting of the corresponding connection attribute (as applicable).

Table 10-13 Standard Statement Options (ODBC 2.5)

Option	Notes
`SQL_MAX_ROWS`	See ODBC 2.5 Function Signatures That Have Changed.
`SQL_NOSCAN`	No notes
`SQL_QUERY_TIMEOUT`	See Setting a Timeout Duration for SQL Statements.

Note:

The SQL_MAX_LENGTH option can be set, but any specified value is overridden with 0 (return all available data).

Column Descriptor Support for ODBC 2.5 SQLColAttributes

The SQLColAttributes function returns descriptor information for a column in a result set.

Refer to ODBC API reference documentation for complete information about this function and standard column descriptors.

Table 10-14 describes TimesTen-specific column descriptors.

Table 10-14 TimesTen Column Descriptors: SQLColAttributes

Descriptor Comment/Description

Descriptor	Comment/Description
`TT_COLUMN_INLINE`	Returns `TRUE` for columns with inline data, or `FALSE` otherwise. This is returned in the `SQLColAttributes` `pfDesc` parameter.
`TT_COLUMN_LENGTH_SEMANTICS`	For character-type columns, this returns "BYTE" for columns with byte length semantics and "CHAR" for columns with character length semantics. For non-character columns, it returns "". The information is returned in the `SQLColAttributes` `rgbDesc` parameter. This information refers to whether data length is measured in bytes or characters. Length semantics in TimesTen are the same as in Oracle Database. See Length Semantics in Oracle Database Globalization Support Guide.

TT_COLUMN_INLINE

Returns TRUE for columns with inline data, or FALSE otherwise. This is returned in the SQLColAttributes pfDesc parameter.

TT_COLUMN_LENGTH_SEMANTICS

For character-type columns, this returns "BYTE" for columns with byte length semantics and "CHAR" for columns with character length semantics. For non-character columns, it returns "". The information is returned in the SQLColAttributes rgbDesc parameter.

This information refers to whether data length is measured in bytes or characters. Length semantics in TimesTen are the same as in Oracle Database. See Length Semantics in Oracle Database Globalization Support Guide.

Information Type Support for ODBC 2.5 SQLGetInfo

There is support in the TimesTen ODBC 2.5 implementation for information types for the ODBC function SQLGetInfo.

Table 10-15 documents TimesTen support for standard information types introduced in ODBC 1.0 and 2.0, as well as ODBC 3.0 information types supported by the TimesTen ODBC 2.5 implementation (as indicated), noting the TimesTen-specific correct value or values returned.

See Information Type Support for ODBC 3.5 SQLGetInfo for TimesTen-specific information types, which are supported for both ODBC 3.5 and ODBC 2.5.

Table 10-15 TimesTen Support for Standard Information Types: SQLGetInfo (ODBC 2.5)

Information Type	Notes and Correct Values Returned by TimesTen
`SQL_ACCESSIBLE_PROCEDURES`	"Y"
`SQL_ACCESSIBLE_TABLES`	"Y"
`SQL_ACTIVE_CONNECTIONS`	`sb_DbConnMaxUser`: Daemon connections limited to this value.
`SQL_ACTIVE_STATEMENTS`	0: Allocated from heap, no limit on concurrency.
`SQL_AGGREGATE_FUNCTIONS`	ODBC 3.0 information type supported by TimesTen ODBC 2.5 implementation. See Information Type Support for ODBC 3.5 SQLGetInfo.
`SQL_ALTER_TABLE`	`SQL_AT_ADD_COLUMN, SQL_AT_DROP_COLUMN`
`SQL_BOOKMARK_PERSISTENCE`	0: Bookmarks persist through none of the operations.
`SQL_COLUMN_ALIAS`	"Y"
`SQL_CONCAT_NULL_BEHAVIOR`	`SQL_CB_NON_NULL`: Result is concatenation of column or columns with non-null values.
`SQL_CONVERT_FUNCTIONS`	`SQL_FN_CVT_CAST`
`SQL_CONVERT_xxxx`	0: `CONVERT` function not supported.
`SQL_CONVERT_WCHAR`	ODBC 3.0 information type supported by TimesTen ODBC 2.5 implementation. See Information Type Support for ODBC 3.5 SQLGetInfo.
`SQL_CONVERT_WLONGVARCHAR`	ODBC 3.0 information type supported by TimesTen ODBC 2.5 implementation. See Information Type Support for ODBC 3.5 SQLGetInfo.
`SQL_CONVERT_WVARCHAR`	ODBC 3.0 information type supported by TimesTen ODBC 2.5 implementation. See Information Type Support for ODBC 3.5 SQLGetInfo.
`SQL_CORRELATION_NAME`	`SQL_CN_ANY`: Correlation names are supported and can be any valid user-defined name.
`SQL_CREATE_VIEW`	ODBC 3.0 information type supported by TimesTen ODBC 2.5 implementation. See Information Type Support for ODBC 3.5 SQLGetInfo.
`SQL_CURSOR_COMMIT_BEHAVIOR`	`SQL_CB_CLOSE`: Close cursors. For prepared statements, the application can call `SQLExecute` on the statement without calling `SQLPrepare` again.
`SQL_CURSOR_ROLLBACK_BEHAVIOR`	`SQL_CB_CLOSE`: Close cursors. For prepared statements, the application can call `SQLExecute` on the statement without calling `SQLPrepare` again.
`SQL_DATA_SOURCE_NAME`	"": Empty string.
`SQL_DATA_SOURCE_READ_ONLY`	"N"
`SQL_DATETIME_LITERALS`	ODBC 3.0 information type supported by TimesTen ODBC 2.5 implementation. See Information Type Support for ODBC 3.5 SQLGetInfo.
`SQL_DEFAULT_TXN_ISOLATION`	`SQL_TXN_READ_COMMITTED`: Dirty reads are not possible. Non-repeatable reads and phantoms are possible. `SQL_TXN_SERIALIZABLE`: Transactions are serializable. Dirty reads, non-repeatable reads, or phantoms are now allowed.
`SQL_DRIVER_HDBC`	Pointer to driver connection handle.
`SQL_DRIVER_HENV`	Pointer to driver environment handle.
`SQL_DRIVER_HLIB`	`NULL` Note: If you use a driver manager, this returns the pointer to the TimesTen library.
`SQL_DRIVER_HSTMT`	Pointer to driver statement handle.
`SQL_DRIVER_NAME`	The file name of the TimesTen ODBC driver library for your platform.
`SQL_DRIVER_ODBC_VER`	"3.51" for ODBC 3.5; "2.50" for ODBC 2.5.
`SQL_DRIVER_VER`	A string indicating the TimesTen version. For example, "22.01.0001.0001 Oracle TimesTen version 22.1.1.1.0".
`SQL_DROP_VIEW`.	ODBC 3.0 information type supported by TimesTen ODBC 2.5 implementation. See Information Type Support for ODBC 3.5 SQLGetInfo.
`SQL_EXPRESSIONS_IN_ORDERBY`	"Y"
`SQL_FETCH_DIRECTION`	`SQL_FD_FETCH_NEXT`
`SQL_FILE_USAGE`	`SQL_FILE_NOT_SUPPORTED`: Driver is not a single-tier driver.
`SQL_GETDATA_EXTENSIONS`	`SQL_GD_ANY_COLUMN`: `SQLGetData` can be called for any unbound column, including those before the last bound column. The columns must be called in order of ascending column number unless `SQL_GD_ANY_ORDER` is also returned. `SQL_GD_ANY_ORDER`: `SQLGetData` can be called for unbound columns in any order. Note that `SQLGetData` can be called only for columns after the last bound column unless `SQL_GD_ANY_COLUMN` is also returned. `SQL_GD_BOUND`: `SQLGetData` can be called for bound columns in addition to unbound columns. A driver cannot return this value unless it also returns `SQL_GD_ANY_COLUMN`.
`SQL_GROUP_BY`	`SQL_GB_GROUP_BY_CONTAINS_SELECT`: `GROUP BY` clause must contain all nonaggregated columns in the select list, but can also contain columns that are not in the select list. For example: SELECT dept, MAX(salary) FROM employee GROUP BY dept, age;
`SQL_IDENTIFIER_CASE`	`SQL_IC_UPPER`: SQL identifiers are not case-sensitive and are stored in uppercase in system catalog.
`SQL_IDENTIFIER_QUOTE_CHAR`	""": A string with one quote mark, which is the quote character.
`SQL_KEYWORDS`	`TT_SQL_KEYWORDS`: A character string that contains a comma-separated list of TimesTen-specific SQL keywords. See TimesTen SQL Keywords for ODBC 2.5.
`SQL_LIKE_ESCAPE_CLAUSE`	"Y"
`SQL_MAX_BINARY_LITERAL_LEN`	16384
`SQL_MAX_CHAR_LITERAL_LEN`	`YY_BUF_SIZE`
`SQL_MAX_COLUMN_NAME_LEN` Alias `SQL_MAXIMUM_COLUMN_NAME_LENGTH`	`sb_ObjNameLenMax`
`SQL_MAX_COLUMNS_IN_GROUP_BY` Alias `SQL_MAXIMUM_COLUMNS_IN_GROUP_BY`	`MAX_COLUMNS_IN_GB`
`SQL_MAX_COLUMNS_IN_INDEX`	`MAX_COLUMNS_IN_IDX`
`SQL_MAX_COLUMNS_IN_ORDER_BY` Alias `SQL_MAXIMUM_COLUMNS_IN_ORDER_BY`	`MAX_COLUMNS_IN_OB`
`SQL_MAX_COLUMNS_IN_SELECT` Alias `SQL_MAXIMUM_COLUMNS_IN_SELECT`	`MAX_COLUMNS_IN_SELECT`
`SQL_MAX_COLUMNS_IN_TABLE` Alias `SQL_MAXIMUM_COLUMNS_IN_TABLE`	`MAX_COLUMNS_IN_TBL`
`SQL_MAX_CURSOR_NAME_LEN` Alias `SQL_MAXIMUM_CURSOR_NAME_LENGTH`	18
`SQL_MAX_INDEX_SIZE`	4194304
`SQL_MAX_OWNER_NAME_LEN`	`sb_ObjNameLenMax`
`SQL_MAX_PROCEDURE_NAME_LEN`	`sb_NameLenMax - 1`
`SQL_MAX_QUALIFIER_NAME_LEN`	0: No specific maximum length.
`SQL_MAX_ROW_SIZE`	4194304
`SQL_MAX_STATEMENT_LEN` Alias `SQL_MAXIMUM_STATEMENT_LENGTH`	`sb_SqlStringLenMax`
`SQL_MAX_TABLE_NAME_LEN` Alias `SQL_MAXIMUM_TABLE_NAME_LENGTH`	`sb_ObjNameLenMax`
`SQL_MAX_TABLES_IN_SELECT` Alias `SQL_MAXIMUM_TABLES_IN_SELECT`	`sb_SqlCorrMax`
`SQL_MAX_USER_NAME_LEN` Alias `SQL_MAXIMUM_USER_NAME_LENGTH`	`sb_ObjNameLenMax`
`SQL_MULT_RESULT_SETS`	"N"
`SQL_MULTIPLE_ACTIVE_TXN`	"Y"
`SQL_NEED_LONG_DATA_LEN`	"N"
`SQL_NON_NULLABLE_COLUMNS`	`SQL_NNC_NON_NULL`: Columns cannot be nullable. (The data source supports the `NOT NULL` column constraint in `CREATE TABLE` statements.)
`SQL_NULL_COLLATION`	`SQL_NC_HIGH`: Null values are sorted at the high end of the result set, depending on the `ASC` or `DESC` keyword.
`SQL_NUMERIC_FUNCTIONS`	`SQL_FN_NUM_ABS, SQL_FN_NUM_CEILING, SQL_FN_NUM_FLOOR, SQL_FN_NUM_MOD, SQL_FN_NUM_POWER, SQL_FN_NUM_ROUND, SQL_FN_NUM_SIGN, SQL_FN_NUM_SQRT`
`SQL_ODBC_SQL_OPT_IEF`	"N"
`SQL_ODBC_VER`	N/A, implemented by the driver manager.
`SQL_OJ_CAPABILITIES` Alias `SQL_OUTER_JOIN_CAPABILITIES`	`SQL_OJ_LEFT`: Left outer joins supported. `SQL_OJ_RIGHT`: Right outer joins supported. `SQL_OJ_NOT_ORDERED`: Column names in the `ON` clause of the outer join do not have to be in the same order as their respective table names in the `OUTER JOIN` clause. `SQL_OJ_INNER`: Inner table (right table in a left outer join or left table in a right outer join) can also be used in an inner join. This does not apply to full outer joins, which do not have an inner table. `SQL_OJ_ALL_COMPARISON_OPS`: Comparison operator in the `ON` clause can be any of the ODBC comparison operators. If this bit is not set, only the equals (=) comparison operator can be used in outer joins.
`SQL_ORDER_BY_COLUMNS_IN_SELECT`	"Y"
`SQL_OUTER_JOINS`	"Y"
`SQL_OWNER_TERM`	"owner"
`SQL_OWNER_USAGE`	`SQL_OU_DML_STATEMENTS`: Schemas supported in all DML statements. `SQL_OU_PROCEDURE_INVOCATION`: Schemas supported in the ODBC procedure invocation statement. `SQL_OU_TABLE_DEFINITION`: Schemas supported in `CREATE TABLE`, `CREATE VIEW`, `ALTER TABLE`, `DROP TABLE`, and `DROP VIEW` statements. `SQL_OU_INDEX_DEFINITION`: Schemas supported in `CREATE INDEX` and `DROP INDEX` statements. `SQL_OU_PRIVILEGE_DEFINITION`: Schemas are supported in `GRANT` and `REVOKE` statements.
`SQL_PARAM_ARRAY_ROW_COUNTS`	ODBC 3.0 information type supported by TimesTen ODBC 2.5 implementation. See Information Type Support for ODBC 3.5 SQLGetInfo.
`SQL_PARAM_ARRAY_SELECTS`	ODBC 3.0 information type supported by TimesTen ODBC 2.5 implementation. See Information Type Support for ODBC 3.5 SQLGetInfo.
`SQL_POS_OPERATIONS`	0: Scrollable cursors not supported.
`SQL_PROCEDURE_TERM`	"procedure"
`SQL_PROCEDURES`	"Y"
`SQL_QUALIFIER_LOCATION`	0: Catalog names as qualifiers not supported.
`SQL_QUALIFIER_NAME_SEPARATOR`	`NULL`: Not supported.
`SQL_QUALIFIER_TERM`	"data store"
`SQL_QUALIFIER_USAGE`	0: Catalogs not supported.
`SQL_QUOTED_IDENTIFIER_CASE`	`SQL_IC_SENSITIVE`: Quoted identifiers in SQL are case-sensitive and stored in mixed-case in the system catalog.
`SQL_ROW_UPDATES`	"N"
`SQL_SCROLL_OPTIONS`	`SQL_SO_FORWARD_ONLY`: Cursors can scroll only forward.
`SQL_SEARCH_PATTERN_ESCAPE`	"\\"
`SQL_SERVER_NAME`	"": Empty string.
`SQL_SPECIAL_CHARACTERS`	"@#$": A string indicating the special characters.
`SQL_SQL92_RELATIONAL_JOIN_OPERATORS`	ODBC 3.0 information type supported by TimesTen ODBC 2.5 implementation. See Information Type Support for ODBC 3.5 SQLGetInfo.
`SQL_SQL92_VALUE_EXPRESSIONS`	ODBC 3.0 information type supported by TimesTen ODBC 2.5 implementation. See Information Type Support for ODBC 3.5 SQLGetInfo.
`SQL_STRING_FUNCTIONS`	`SQL_FN_STR_CHAR, SQL_FN_STR_CONCAT, SQL_FN_STR_LCASE, SQL_FN_STR_LEFT, SQL_FN_STR_LENGTH, SQL_FN_STR_LOCATE, SQL_FN_STR_LOCATE_2, SQL_FN_STR_LTRIM, SQL_FN_STR_REPLACE, SQL_FN_STR_RIGHT, SQL_FN_STR_RTRIM, SQL_FN_STR_SOUNDEX, SQL_FN_STR_SPACE, SQL_FN_STR_SUBSTRING, SQL_FN_STR_UCASE`
`SQL_SUBQUERIES`	`SQL_SQ_CORRELATED_SUBQUERIES, SQL_SQ_COMPARISON, SQL_SQ_EXISTS, SQL_SQ_IN, SQL_SQ_INSQL_SQ_QUANTIFIED`
`SQL_SYSTEM_FUNCTIONS`	`SQL_FN_SYS_IFNULL, SQL_FN_SYS_USERNAME`
`SQL_TABLE_TERM`	"table"
`SQL_TIMEDATE_ADD_INTERVALS`	`SQL_FN_TSI_FRAC_SECOND, SQL_FN_TSI_SECOND, SQL_FN_TSI_MINUTE, SQL_FN_TSI_HOUR, SQL_FN_TSI_DAY, SQL_FN_TSI_WEEK, SQL_FN_TSI_MONTH, SQL_FN_TSI_QUARTER, SQL_FN_TSI_YEAR`
`SQL_TIMEDATE_DIFF_INTERVALS`	`SQL_FN_TSI_FRAC_SECOND, SQL_FN_TSI_SECOND, SQL_FN_TSI_MINUTE, SQL_FN_TSI_HOUR, SQL_FN_TSI_DAY, SQL_FN_TSI_WEEK, SQL_FN_TSI_MONTH, SQL_FN_TSI_QUARTER, SQL_FN_TSI_YEAR`
`SQL_TIMEDATE_FUNCTIONS`	`SQL_FN_TD_TIMESTAMPADD, SQL_FN_TD_NOW, SQL_FN_TD_TIMESTAMPDIFF`
`SQL_TXN_CAPABLE` Alias `SQL_TRANSACTION_CAPABLE`	`SQL_TC_DDL_COMMIT`: According to the ODBC 2.0 standard, this indicates that transactions can contain only DML statements, and that DDL statements encountered in a transaction cause the transaction to be committed. TimesTen implements Oracle Database semantics, which allow both DML and DDL in a transaction, but a DDL statement causes the transaction to commit.
`SQL_TXN_ISOLATION_OPTION` Alias `SQL_TRANSACTION_ISOLATION_OPTION`	`SQL_TXN_READ_COMMITTED, SQL_TXN_SERIALIZABLE`
`SQL_UNION`	`SQL_U_UNION`: Data source supports `UNION` clause. `SQL_U_UNION_ALL`: Data source supports `ALL` keyword in the `UNION` clause. (`SQLGetInfo` returns both `SQL_U_UNION` and `SQL_U_UNION_ALL` in this case.)
`SQL_USER_NAME`	At runtime, returns a string containing the user name.

Note:

If you use InfoType value SQL_DRIVER_HDBC, SQL_DRIVER_HENV, or SQL_DRIVER_HSTMT, refer to ODBC 2.5 Function Signatures That Have Changed.

TimesTen SQL Keywords for ODBC 2.5

This section lists the TimesTen SQL keywords returned for SQL_KEYWORDS in a SQLGetInfo call.

This is different from the list of TimesTen reserved words. See Reserved Words in Oracle TimesTen In-Memory Database SQL Reference.

ABS, ACCOUNT, ACTIVE, ADDMONTHS, ADMIN, AFFINITY, AGENT, AGING, ALLOW, ASCIISTR, ASYNCHRONOUS, AUTHID, AUTOREFRESH, AWT, BATCH, BIG, BIGINT, BINARY, BINARY_DOUBLE, BINARY_DOUBLE_INFINITY, BINARY_DOUBLE_NAN, BINARY_FLOAT, BINARY_FLOAT_INFINITY, BINARY_FLOAT_NAN, BITAND, BITMAP, BITNOT, BITOR, BITXOR, BLOB, BODY, BYTE, BYTES, CACHE, CACHEONLY, CACHE_MANAGER, CALL, CHECKING, CHR, CLOB, COLUMNAR, COMMITTED, COMPILE, COMPLETE, COMPRESS, CONCAT, CONFLICT, CONFLICTS, CS, CUBE, CURRENT_SCHEMA, CURRVAL, CYCLE, DATASTORE, DATASTORE_OWNER, DAYS, DEBUG, DECODE, DEFINED, DEFINER, DEFINITION, DELETE_FT, DESTROY, DICTIONARY, DIRECTORY, DISABLE, DISTRIBUTE, DUPLICATE, DURABLE, DURATION, DYNAMIC, ELEMENT, ENABLE, ENCRYPTED, ENDSEQ, EVERY, EXACT, EXCLUDE, EXIT, EXPIRE, EXTERNALLY, FACTOR, FAILTHRESHOLD, FAST, FIRST_VALUE, FLUSH, FOLLOWING, FORCE, FORMAT, FUNCTION, GETDATE, GRID, GROUPING, GROUPING_ID, GROUP_ID, HASH, HEARTBEAT, HIERARCHY, HOURS, ID, IDENTIFIED, IGNORE, INCREMENT, INCREMENTAL, INFINITE, INLINE, INSERTONLY, INSTANCE, INSTR, INSTR4, INSTRB, LAST_VALUE, LATENCY, LENGTH, LENGTH4, LENGTHB, LIBRARY, LIFETIME, LIMIT, LIMIT_FT, LOAD, LOAD_FT, LOCK, LOG, LONG, LRU, MASTER, MASTERIP, MATCHED, MATERIALIZED, MAXVALUE, MAXVALUES, MERGE, MIGRATORY, MILLISECOND, MILLISECONDS, MINUS, MINUTES, MINVALUE, MOD, MODE, MODIFY, MULTI, NAME, NAN, NCHAR_CS, NCHR, NCLOB, NEXTVAL, NLSSORT, NOBATCH, NOCACHE, NOCYCLE, NOMAXVALUE, NOMINVALUE, NONDURABLE, NOORDER, NOWAIT, NULLS, NUMBER, NUMTODSINTERVAL, NUMTOYMINTERVAL, NVARCHAR, NVARCHAR2, NVL, OFF, OPTIMIZED, ORACLE, ORA_CHAR, ORA_DATE, ORA_FLOAT, ORA_NCHAR, ORA_NVARCHAR2, ORA_SYSDATE, ORA_TIMESTAMP, ORA_VARCHAR2, OUT, OVER, PACKAGE, PAGES, PAIR, PARALLEL, PARTITION, PASSWORD, PAUSED, PLSQL_WARNINGS, PORT, PRECEDING, PRIORITY, PRIVATE, PROPAGATE, PROPAGATOR, PUBLICREAD, PUBLICROW, QUIT, RANGE, RC, READERS, READONLY, RECEIPT, REFERENCE, REFRESH, REFRESH_FT, RELAXED, RELEASE, RENAME, REPLACE, REPLICATION, REPORT, REPORTING, REQUEST, RESUME, RETURN, RETURNING, REUSE, RLE, ROLLUP, ROUTE, ROW, ROWID, ROWIDONLY, ROWNUM, RR, RTRIM, RU, SECONDS, SELF, SEQBATCH, SEQCACHE, SEQUENCE, SERVICES, SETS, SETTINGS, SPECIFICATION, SQL_TSI_DAY, SQL_TSI_FRAC_SECOND, SQL_TSI_HOUR, SQL_TSI_MINUTE, SQL_TSI_MONTH, SQL_TSI_QUARTER, SQL_TSI_SECOND, SQL_TSI_WEEK, SQL_TSI_YEAR, STANDARD, STANDBY, START, STARTSEQ, STATE, STATIC, STOPPED, STORE, SUBSCRIBER, SUBSCRIBERIP, SUBSTR, SUBSTR4, SUBSTRB, SUSPEND, SYNCHRONOUS, SYNONYM, SYSDATE, SYSDBA, SYSTEM, TAG, TIMEOUT, TIMESTAMPADD, TIMESTAMPDIFF, TINYINT, TO_BLOB, TO_CHAR, TO_CLOB, TO_DATE, TO_LOB, TO_NCLOB, TO_NUMBER, TO_TIMESTAMP, TRAFFIC, TRANSMIT, TREE, TRUNC, TRUNCATE, TRUSTED, TT_BIGINT, TT_BINARY, TT_CHAR, TT_DATE, TT_DECIMAL, TT_HASH, TT_INT, TT_INTEGER, TT_INTERVAL, TT_NCHAR, TT_NVARCHAR, TT_SMALLINT, TT_SYSDATE, TT_TIME, TT_TIMESTAMP, TT_TINYINT, TT_VARBINARY, TT_VARCHAR, TWOSAFE, UID, UNBOUNDED, UNISTR, UNLOAD, UNLOCK, USE, USERMANAGED, VARBINARY, VARCHAR2, WAIT, WRAPPED, WRITETHROUGH, XLA, XML, XYZZY