Contents

Title and Copyright Information

Preface

• Audience
• Related documents
• Conventions
• Documentation Accessibility
• Technical support

What's New

• New Features for Release 11.2.1

1 Working with TimesTen Data Stores

• Managing TimesTen data store connections
  • SQLConnect, SQLDriverConnect, SQLAllocConnect, SQLDisconnect functions
  • Connecting to and disconnecting from a data store
  • Setting connection attributes programmatically
  • Access control for connections
• Managing TimesTen data
  • TimesTen #include files
  • SQL statement execution within C applications
    • SQLExecDirect and SQLExecute functions
    • Executing a SQL statement
  • Preparing and executing queries and working with cursors
  • TimesTen deferred prepare
  • Binding parameters
    • ODBC to SQL or PL/SQL type mappings
    • SQLBindParameter function
    • Considerations for SQL parameter type assignments
    • Considerations for C parameters used in PL/SQL
    • Binding IN parameters
    • Binding OUT parameters
    • Binding IN OUT parameters
    • Binding duplicate parameters in SQL statements
    • Binding duplicate parameters in PL/SQL
    • Considerations for floating point data
  • Working with REF CURSORs
  • Working with rowids
  • Prefetching multiple rows of data
  • Making and committing changes to the database
  • Using DML returning (RETURNING INTO clause)
  • Calling TimesTen built-in procedures within C applications
  • Setting a timeout or threshold for executing SQL statements
    • Setting a timeout value for SQL statements
    • Setting a threshold value for SQL statements
  • Managing cache groups
  • Setting globalization options
    • TT_NLS_SORT
    • TT_NLS_LENGTH_SEMANTICS
    • TT_NLS_NCHAR_CONV_EXCP
  • ODBC 3.0 data types
• Considering TimesTen features for access control
• Managing error and failure conditions
  • Error handling
    • Checking for errors
    • Error and warning levels
    • Recovering after fatal errors
  • Automatic client failover
    • Features and functionality of automatic client failover
    • Failover callback functions

2 Compiling and Linking TimesTen Applications

• Setting environment variables
• Linking options
  • Linking directly with a TimesTen ODBC driver
  • Linking with a driver manager
• Compiling and linking applications on Windows
• Compiling and linking applications on UNIX
• Testing link options
• About the TimesTen C demos

3 TimesTen Support for Oracle Call Interface

• Overview of OCI
• Overview of TimesTen OCI support
  • OCI libraries and architecture
  • Globalization support
    • Character sets
    • Additional globalization features
  • TimesTen restrictions
  • The ttSrcScan utility
• Getting started with TimesTen OCI
  • Environment variables for TimesTen OCI
  • Compiling and linking OCI applications
  • Connecting to a TimesTen data store from OCI
    • Using the tnsnames naming method to connect
    • Using an easy connect string to connect
    • Configuring whether to use tnsnames.ora or easy connect
  • Error reporting
  • OCI demo programs
• Additional features of TimesTen OCI
  • TimesTen deferred prepare
  • Using IMDB Cache in OCI
    • Specifying the Oracle password in OCI for IMDB Cache
    • Determining the number of cache groups affected by an action
  • Duplicate parameter bindings in TimesTen OCI
• Call, handle, descriptor, SQL data type, and parameter attribute support

4 TimesTen Support for Oracle Pro*C/C++ Precompiler

• Overview of the Oracle Pro*C/C++ Precompiler
• Overview of TimesTen support for Pro*C/C++
  • TimesTen OCI support
  • Embedded SQL restrictions
  • Semantic checking restrictions
  • Embedded PL/SQL restrictions
  • Transaction restrictions
  • Connection restrictions
  • Summary of unsupported or restricted executable commands and clauses
  • The ttSrcScan utility
• Getting started with TimesTen Pro*C/C++
  • Building a Pro*C/C++ application
  • Connecting to a TimesTen data store from Pro*C/C++
    • Connection syntax and parameters
    • Using tnsnames or easy connect
    • Specifying the Oracle password in Pro*C/C++ for IMDB Cache
  • Error reporting and handling
  • Pro*C/C++ demo programs
• TimesTen Pro*C/C++ Precompiler options
  • Precompiler option support
  • Setting precompiler options

5 XLA and TimesTen Event Management

• XLA concepts
  • XLA persistent mode
  • How XLA reads records from the transaction log
  • About XLA and materialized views
  • About XLA bookmarks
    • Creating or reusing a bookmark
    • How bookmarks work
    • Replicated bookmarks
  • About XLA data types
  • Access control impact on XLA
  • XLA demo
• Writing an XLA event-handler application
  • Obtaining a data store 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
    • 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
    • Putting it all together: a PrintColValues() function
  • Handling XLA errors
  • Dropping a table that has an XLA bookmark
  • Deleting bookmarks
  • Terminating an XLA application
• Using XLA as a replication mechanism
  • Checking table compatibility between data stores
    • Checking table and column descriptions
    • Checking table and column versions
  • Replicating updates between data stores
  • Handling timeout and deadlock errors
  • Checking for update conflicts
  • Replicating updates to a non-TimesTen data store
• Other XLA features
  • Changing the location of a bookmark
  • Passing application context
  • Using XLA in non-persistent mode
    • How non-persistent mode differs from persistent mode
    • Initializing XLA in non-persistent mode
    • Configuring the staging buffer
    • Retrieving and resetting the buffer status

6 Distributed Transaction Processing: XA

• Overview of XA
  • X/Open DTP model
  • Two-phase commit
• Using XA in TimesTen
  • TimesTen data store requirements for XA
  • Global transaction recovery in TimesTen
  • Considerations in using standard XA functions with TimesTen
    • xa_open()
    • xa_close()
    • Transaction id (XID) parameter
  • TimesTen tt_xa_context function to obtain ODBC handle from XA connection
  • Considerations in calling ODBC functions over XA connections in TimesTen
    • AUTOCOMMIT
    • Local transaction COMMIT and ROLLBACK
    • Closing open cursors
  • XA resource manager switch
    • xa_switch_t
    • tt_xa_switch
  • XA error handling in TimesTen
• XA support through the Windows ODBC driver manager
  • Issues to consider
  • Linking to the TimesTen ODBC XA driver manager extension library
• Configuring Tuxedo to use TimesTen XA
  • Update the $TUXDIR/udataobj/RM file
  • Build the Tuxedo transaction manager server
  • Update the GROUPS section in the UBBCONFIG file
  • Compile the servers

7 Application Tuning

• Bypass driver manager if appropriate
• Using arrays of parameters for batch execution
• Avoid excessive binds
• Avoid SQLGetData
• Avoid data type conversions
• Bulk fetch rows of TimesTen data

8 TimesTen Utility API

• ttBackup
• ttDestroyDataStore
• ttDestroyDataStoreForce
• ttRamGrace
• ttRamLoad
• ttRamPolicy
• ttRamUnload
• ttRepDuplicateEx
• ttRestore
• ttUtilAllocEnv
• ttUtilFreeEnv
• ttUtilGetError
• ttUtilGetErrorCount
• ttXactIdRollback

9 XLA Reference

• About XLA functions
  • About return codes
  • About parameter types (input, output, input-output)
  • About results output by functions
  • About required privileges
• Summary of XLA functions by category
  • XLA core functions including data type conversion functions
  • XLA persistent mode functions
  • XLA non-persistent mode functions
  • XLA replication functions
• XLA function reference
  • ttXlaAcknowledge
  • ttXlaApply
  • ttXlaClose
  • ttXlaCommit
  • ttXlaConfigBuffer
  • ttXlaConvertCharType
  • ttXlaDateToODBCCType
  • ttXlaDecimalToCString
  • ttXlaDeleteBookmark
  • ttXlaError
  • ttXlaErrorRestart
  • ttXlaGenerateSQL
  • ttXlaGetColumnInfo
  • ttXlaGetLSN
  • ttXlaGetTableInfo
  • ttXlaGetVersion
  • ttXlaLookup
  • ttXlaNextUpdate
  • ttXlaNextUpdateWait
  • ttXlaNumberToBigInt
  • ttXlaNumberToCString
  • ttXlaNumberToDouble
  • ttXlaNumberToInt
  • ttXlaNumberToSmallInt
  • ttXlaNumberToTinyInt
  • ttXlaNumberToUInt
  • ttXlaOpenTimesTen
  • ttXlaOraDateToODBCTimeStamp
  • ttXlaOraTimeStampToODBCTimeStamp
  • ttXlaPersistOpen
  • ttXlaResetStatus
  • ttXlaRollback
  • ttXlaRowidToCString
  • ttXlaSetLSN
  • ttXlaSetVersion
  • ttXlaStatus
  • ttXlaTableByName
  • ttXlaTableCheck
  • ttXlaTableStatus
  • ttXlaTimeToODBCCType
  • ttXlaTimeStampToODBCCType
  • ttXlaTableVersionVerify
  • ttXlaVersionColumnInfo
  • ttXlaVersionCompare
  • ttXlaVersionTableInfo
• C data structures used by XLA
  • ttXlaNodeHdr_t
  • ttXlaUpdateDesc_t
    • Special update data formats
    • Locating the row data following a ttXlaUpdateDesc_t header
  • ttXlaStatus_t
  • ttXlaVersion_t
  • ttXlaTblDesc_t
  • ttXlaTblVerDesc_t
  • ttXlaColDesc_t
  • tt_LSN_t
  • tt_XlaLsn_t

10 TimesTen ODBC Functions and Options

• Supported ODBC functions
• Option support for ODBC connection and statement functions
  • Option support for SQLSetConnectOption and SQLGetConnectOption
  • Option support for SQLSetStmtOption and SQLGetStmtOption

11 ODBC for UNIX

• Inapplicable chapters in the Microsoft ODBC manual
• Minor inconsistencies
• Microsoft ODBC 2.5

Index