DB2 Universal Database

This is the only comprehensive reference available for DB2 Universal Database
application developers working with IBM's Call Level Interface. Perfect for intermediate- to advanced-level developers, it's your complete, time-saving, at-a-glance guide to mastering CLI, IBM's Call Level Interface for communicating with DB2 Universal Database databases.

Inside, you'll find full coverage of core concepts of CLI, including a frank discussion of the advantages and drawbacks of using CLI instead of SQL. This one-of-a-kind guide will also walk you through the basic steps of building, testing, and debugging executable applications that maximize CLI's flexibility. Then it delves deeply into the CLI API functions and offers tested C++ programming examples that will help you maximize the power of CLI without sacrificing hours of trial-and-error programming.

And because CLI is closely aligned with ODBC 3.0, this handbook also helps you sort out the differences between CLI, ODBC, and the international standards upon which both CLI and ODBC are based. Rich in practical examples and techniques you can put to work right away, the DB2 Universal Database Call Level Interface Developer's Guide is your shortcut to a new understanding of this incredibly useful interface.

Table of contents :

Foreword

Introduction

Part 1: Basic Database Concepts ..... 1

Chapter 1: DB2 Database Architecture ..... 3

Chapter 2: Database Consistency Mechanisms ..... 23

Part 2: Application Development Fundamentals ..... 43

Chapter 3: Getting Started with DB2 Application Development ..... 45

Chapter 4: Writing CLI Applications ..... 61

Chapter 5: Components that DB2 CLI Uses to Interact with Applications ..... 77

Chapter 6: SQL Statements and DB2 CLI ..... 95

Part 3: Call Level Interface (CLI) Functions ..... 117

Chapter 7: Initializing CLI/ODBC and Connecting to a Data Source ..... 119

Chapter 8: Data Source and Driver Capabilities ..... 165

Chapter 9: Preparing and Executing SQL Statements ..... 255

Chapter 10: Retrieving Results (Basic) ..... 339

Chapter 11: Retrieving Results (Advanced) ..... 399

Chapter 12: Working with Descriptors ..... 441

Chapter 13: Retrieving Status and Error Information ..... 503

Chapter 14: Querying the Data Source System Catalog ..... 533

Chapter 15: Working with Large Objects ..... 617

Appendix A: ODBC Scalar Functions ..... 643

Appendix B: SQLSTATE Reference ..... 651

Appendix C: Information Returned by SQLGetInfo() ..... 659

Appendix D: How The Example Programs Were Developed ..... 723

Bibliography ..... 732

Index ..... 733

API Index ..... 741