Advanced Database Feature Guide


Table of Contents

Notices

  • Trademarks
  • About this book

  • Who this book is for
  • Conventions used in this book
  • Tell us what you think
  • Introduction

  • Approach
  • What's supported
  • Supported versions of DB2
  • DB2 data types
  • DB2 CLI features
  • What's not supported
  • DB2 CAE features
  • DB2 CLI features
  • Other information sources
  • Writing an application

  • Initialization and termination
  • Connecting to one or more data sources
  • Object Termination
  • Transaction Processing
  • Preparation and Execution
  • Using parameter markers
  • Using named parameters
  • Processing Results
  • Commit or Rollback
  • Exception Handling
  • Retrieving Diagnostic Information
  • Advanced Features

  • Environment, Connection and Statement Attributes
  • Writing Multi-Process Applications
  • When to Use Multiple Processes
  • Application Deadlocks
  • Querying System Catalog Information
  • Public Catalog Classes
  • Catalog Examples
  • Unsupported Catalog Queries
  • Using Multiple Value Sets
  • Using Result Sets
  • Using Column/Row-Wise Binding
  • Optimizing Row Retrieval
  • Using Compound SQL
  • Compound SQL Example
  • Using Large Objects
  • LOB Locator Example
  • Using User Defined Types (UDT)
  • UDT Example
  • Using Stored Procedures
  • Calling Stored Procedures
  • Registering Stored Procedures
  • Using Vendor Escape Clauses
  • Escape Clause Syntax
  • The AbtDbm Compatibility Layer

  • Compatibility Layer Limitations
  • Loading the Compatibility Layer
  • Migrating to the Advanced Database Feature
  • Guidelines for Migrating from AbtDbm to UtyDB2
  • Connections (AbtDatabaseConnection -> UtyDB2Connection)
  • Statements and Statement Descriptors (AbtQuerySpec -> UtyDB2SqlDescriptor)
  • Host Variable Shapes (AbtCompoundType -> Dictionary)
  • Index


    [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]