Table of Contents
- Title and Copyright Information
- About This Content
- What's New
- 1 C Development Environment
-
2
Working With TimesTen Databases in ODBC
- Management of TimesTen Database Connections
- Database Operations in ODBC
-
TimesTen Features and Operations in Your Application
- TimesTen Include Files
- TimesTen Deferred Prepare
- Prefetching Multiple Rows of Data
- Optimizing Query Performance
-
Parameter Binding and Statement Execution
- SQLBindParameter Function
- Parameter Type Assignments and Type Conversions
- ODBC SQL to TimesTen SQL or PL/SQL Type Mappings
- Binding Input Parameters
- Binding Output Parameters
- Binding Input/Output Parameters
- Binding of Duplicate Parameters in SQL Statements
- Binding of Duplicate Parameters in PL/SQL Statements
- Considerations for Floating Point Data
- Using SQL_WCHAR and SQL_WVARCHAR With a Driver Manager
- Working With REF CURSORs
- Working With DML Returning (RETURNING INTO Clause)
- Working With rowids
- Large Objects (LOBs)
- Using CALL to Execute Procedures and Functions
- Timeouts and Thresholds for Executing SQL Statements
- Configuring the Result Set Buffer Size in Client/Server Using ODBC
- Features for Cache
- Error Handling
- ODBC Support for Automatic Client Failover
- Client Routing API for TimesTen Scaleout
-
3
TimesTen Support for OCI
- Overview of TimesTen OCI Support
- Getting Started With TimesTen OCI
-
TimesTen Features With OCI
- TimesTen Deferred Prepare
- Parameter Binding Features in TimesTen OCI
- Using Cache Operations With TimesTen OCI
-
LOBs in TimesTen OCI
- LOB Locators in OCI
- Temporary LOBs in OCI
- Differences Between TimesTen LOBs and Oracle Database LOBs in OCI
- Using the LOB Simple Data Interface in OCI
- About Using the LOB Locator Interface in OCI
- Creating a Temporary LOB in OCI
- Accessing the Locator of a Persistent LOB in OCI
- Reading and Writing LOB Data Using the OCI LOB Locator Interface
- OCI Client-Side Buffering
- LOB Prefetching in OCI
- Passthrough LOBs in OCI
- Configuring the Result Set Buffer Size in Client/Server Using OCI
- Use of PL/SQL in OCI to Call a TimesTen Built-In Procedure
- TimesTen OCI Support Reference
- 4 TimesTen Support for Pro*C/C++
-
5
XLA and TimesTen Event Management
- Overview of TimesTen XLA
-
Writing an XLA Event-Handler Application
- Obtaining a Database Connection Handle
- Initializing XLA and Obtaining an XLA Handle
- Specifying Which Tables to Monitor for Updates
- Retrieving Update Records From the Transaction Log
- Inspecting Record Headers and Locating Row Addresses
-
Inspecting Column Data
- Data Returned in an Update Record
- Obtaining Column Descriptions
- Reading Fixed-Length Column Data
- Reading NOT INLINE Variable-Length Column Data
- Null-Terminating Returned Strings
- Converting Complex Data Types
- Detecting Null Values
- XLA Data Type Conversion Functions
- Putting It All Together With a PrintColValues() Function
- XLA Error Handling
- Dropping a Table That Has an XLA Bookmark
- Deleting Bookmarks
- Terminating an XLA Application
- Using XLA as a Replication Mechanism
- Other XLA Features
-
6
Distributed Transaction Processing: XA
- Overview of XA
-
XA in TimesTen
- Introduction to the TimesTen XA Implementation and Limitations
- TimesTen Database Requirements for XA
- Global Transaction Recovery in TimesTen
- Considerations in Using Standard XA Functions With TimesTen
- TimesTen tt_xa_context Function to Obtain ODBC Handle From XA Connection
- Considerations in Calling ODBC Functions Over XA Connections in TimesTen
- XA Resource Manager Switch
- XA Error Handling in TimesTen
- XA Support Through the Windows ODBC Driver Manager
- Configuring Tuxedo to Use TimesTen XA
- 7 ODBC Application Tuning
- 8 TimesTen Utility API
-
9
XLA Reference
- Overview of XLA Functions
- Summary of XLA Functions by Category
-
XLA Function Reference
- ttXlaAcknowledge
- ttXlaClose
- ttXlaConvertCharType
- ttXlaDateToODBCCType
- ttXlaDecimalToCString
- ttXlaDeleteBookmark
- ttXlaError
- ttXlaErrorRestart
- ttXlaGetColumnInfo
- ttXlaGetLSN
- ttXlaGetTableInfo
- ttXlaGetVersion
- ttXlaNextUpdate
- ttXlaNextUpdateWait
- ttXlaNumberToBigInt
- ttXlaNumberToCString
- ttXlaNumberToDouble
- ttXlaNumberToInt
- ttXlaNumberToSmallInt
- ttXlaNumberToTinyInt
- ttXlaNumberToUInt
- ttXlaOraDateToODBCTimeStamp
- ttXlaOraTimeStampToODBCTimeStamp
- ttXlaPersistOpen
- ttXlaRowidToCString
- ttXlaSetLSN
- ttXlaSetVersion
- ttXlaTableByName
- ttXlaTableStatus
- ttXlaTableVersionVerify
- ttXlaTimeToODBCCType
- ttXlaTimeStampToODBCCType
- ttXlaVersionColumnInfo
- ttXlaVersionCompare
- ttXlaVersionTableInfo
- XLA Replication Function Reference
-
C Data Structures Used by XLA
- ttXlaNodeHdr_t
-
ttXlaUpdateDesc_t
-
Special Update Data Formats
- CREATE TABLE
- ALTER TABLE
- ttXlaDropTableTup_t
- ttXlaTruncateTableTup_t
- ttXlaCreateIndexTup_t
- ttXlaDropIndexTup_t
- ttXlaAddColumnTup_t
- ttXlaDropColumnTup_t
- ttXlaCreateSeqTup_t
- ttXlaDropSeqTup_t
- ttXlaViewDesc_t
- ttXlaDropViewTup_t
- ttXlaCreateSynTup_t
- ttXlaDropSynTup_t
- ttXlaSetTableTup_t
- ttXlaSetColumnTup_t
- ttXlaSetStatusTup_t
- Locating the Row Data Following a ttXlaUpdateDesc_t Header
-
Special Update Data Formats
- ttXlaVersion_t
- ttXlaTblDesc_t
- ttXlaTblVerDesc_t
- ttXlaColDesc_t
- tt_LSN_t
- tt_XlaLsn_t
-
10
TimesTen ODBC Support
-
TimesTen ODBC 3.5 Support
- Using ODBC 3.5 With TimesTen
- Client/Server Cross-Release Restrictions With ODBC 3.5
- ODBC 3.5 New and Replacement Function Support
- ODBC 3.5 Data Type Support Notes
- Environment Attribute Support for ODBC 3.5
- Attribute Support for ODBC 3.5 SQLSetConnectAttr and SQLGetConnectAttr
- Attribute Support for ODBC 3.5 SQLSetStmtAttr and SQLGetStmtAttr
- Attribute Support for ODBC 3.5 SQLGetEnvAttr
- TimesTen Field Identifiers for ODBC 3.5 SQLColAttribute
- Information Type Support for ODBC 3.5 SQLGetInfo
- TimesTen SQL Keywords for ODBC 3.5
-
TimesTen ODBC 2.5 Support
- Using ODBC 2.5 With TimesTen
- ODBC 2.5 Function Support
- Option Support for ODBC 2.5 SQLSetConnectOption and SQLGetConnectOption
- Option Support for ODBC 2.5 SQLSetStmtOption and SQLGetStmtOption
- Column Descriptor Support for ODBC 2.5 SQLColAttributes
- Information Type Support for ODBC 2.5 SQLGetInfo
- TimesTen SQL Keywords for ODBC 2.5
- ODBC API Incompatibilities With Previous Versions of TimesTen
-
TimesTen ODBC 3.5 Support