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