Contents

Title and Copyright Information

Preface

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

What's New

• New features in Release 11.2.1.7.0
• New features in Release 11.2.1.6.0
• New features in Release 11.2.1.4.0
• New features in Release 11.2.1.1.0

1 C Development Environment

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

2 Working with TimesTen Databases

• Managing TimesTen database connections
  • SQLConnect, SQLDriverConnect, SQLAllocConnect, SQLDisconnect functions
  • Connecting to and disconnecting from a database
  • 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
  • Prefetching multiple rows of data
  • Binding parameters and executing statements
    • SQLBindParameter function
    • Determination of parameter type assignments and type conversions
    • 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
    • Using SQL_WCHAR and SQL_WVARCHAR with a driver manager
  • Working with REF CURSORs
  • Working with DML returning (RETURNING INTO clause)
  • Working with rowids
  • Working with synonyms
  • Making and committing changes to the database
• Using additional TimesTen data management features
  • Using CALL to execute procedures and functions
  • Setting a timeout or threshold for executing SQL statements
    • Setting a timeout value for SQL statements
    • Setting a threshold value for SQL statements
  • Features for use with IMDB cache
    • Setting temporary passthrough level with the ttOptSetFlag built-in procedure
    • Determining passthrough status
    • Managing cache groups
  • Setting globalization options
    • TT_NLS_SORT
    • TT_NLS_LENGTH_SEMANTICS
    • TT_NLS_NCHAR_CONV_EXCP
  • Setting up user-specified parallel replication
  • ODBC 3.0 data types
• Considering TimesTen features for access control
• Handling Errors
  • Checking for errors
  • Error and warning levels
    • Fatal errors
    • Non-fatal errors
    • Warnings
  • Recovering after fatal errors
• Using automatic client failover
  • Features and functionality of automatic client failover
  • Failover callback functions

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 and differences
    • Oracle Database features not supported
    • Additional TimesTen OCI restrictions
    • Additional TimesTen OCI differences
  • The ttSrcScan utility
• Getting started with TimesTen OCI
  • Environment variables for TimesTen OCI
  • Compiling and linking OCI applications
  • Connecting to a TimesTen database 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
    • Connecting as an externally identified user in OCI
  • Error reporting
  • Signal handling and diagnostic framework considerations
  • 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 support and 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 database from Pro*C/C++
    • Connection syntax and parameters
    • Using tnsnames or easy connect
    • Specifying the Oracle password in Pro*C/C++ for IMDB Cache
    • Connecting as an externally identified user in Pro*C/C++
  • 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 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
    • 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 databases
    • Checking table and column descriptions
    • Checking table and column versions
  • Replicating updates between databases
  • Handling timeout and deadlock errors
  • Checking for update conflicts
  • Replicating updates to a non-TimesTen database
• 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 database 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

Index