Call Level Interface Guide and Reference

Chapter 3. Using Advanced Features

Partial Table-of-Contents

  • Environment, Connection, and Statement Attributes
  • Writing Multi-Threaded Applications
  • When to Use Multiple Threads
  • Programming Tips
  • Multisite Updates (Two Phase Commit)
  • DB2 as Transaction Monitor
  • Microsoft Transaction Server (MTS) as Transaction Monitor
  • Process-based XA-Compliant Transaction Program Monitor (XA TP)
  • Host and AS/400 Database Servers
  • Querying System Catalog Information
  • Input Arguments on Catalog Functions
  • Catalog Functions Example
  • Scrollable Cursors
  • Static, Read-Only Cursor
  • Keyset-Driven Cursor
  • Deciding on Which Cursor Type to Use
  • Specifying the Rowset Returned from the Result Set
  • Typical Scrollable Cursors Application
  • Using Bookmarks with Scrollable Cursors
  • Sending/Retrieving Long Data in Pieces
  • Specifying Parameter Values at Execute Time
  • Fetching Data in Pieces
  • Piecewise Input and Retrieval Example
  • Using Arrays to Input Parameter Values
  • Column-Wise Array Insert
  • Row-Wise Array Insert
  • Retrieving Diagnostic Information
  • Parameter Binding Offsets
  • Array Input Example
  • Retrieving a Result Set into an Array
  • Returning Array Data for Column-Wise Bound Data
  • Returning Array Data for Row-Wise Bound Data
  • Column Binding Offsets
  • Column-Wise, Row-Wise Binding Example
  • Using Descriptors
  • Descriptor Types
  • Values Stored in a Descriptor
  • Allocating and Freeing Descriptors
  • Getting, Setting, and Copying Descriptor Fields
  • Descriptor Sample
  • Using Compound SQL
  • ATOMIC and NOT ATOMIC Compound SQL
  • Compound SQL Error Handling
  • Compound SQL Example
  • Using Large Objects
  • LOB Examples
  • Using LOBs in ODBC Applications
  • Using User Defined Types (UDT)
  • User Defined Type Example
  • Using Stored Procedures
  • Calling Stored Procedures
  • Registering Stored Procedures
  • Handling Stored Procedure Arguments (SQLDA)
  • Returning Result Sets from Stored Procedures
  • Writing a Stored Procedure in CLI
  • Stored Procedure Example
  • Mixing Embedded SQL and DB2 CLI
  • Mixed Embedded SQL and DB2 CLI Example
  • Asynchronous Execution of CLI
  • Typical Asynchronous Application
  • Sample Asynchronous Application
  • Using Vendor Escape Clauses
  • Escape Clause Syntax
  • ODBC Date, Time, Timestamp Data
  • ODBC Outer Join Syntax
  • LIKE Predicate Escape Clauses
  • Stored Procedure Call Syntax
  • ODBC Scalar Functions

    • This section covers a series of advanced tasks.

    This section does not cover features that are provided generally by dynamic SQL, such as User Defined Functions or Triggers. Refer to the SQL Reference for a complete description of SQL language supported.

    [ Top of Page | Previous Page | Next Page ]