Chapter 11. ODBC/CLI Programming

  • Embedded Dynamic SQL Versus Call-Level Interface

  • The DB2 ODBC Environment

  • Handles

  • Database Connections

  • Transaction Control

  • Executing SQL Statements

  • Retrieving Results

  • ODBC Stored Procedures

  • Error Handling and Problem Determination

  • Sample Program

DB2 Open Database Connectivity (ODBC) is IBM's callable SQL interface for the DB2 family of products. It is a C and C++ application programming interface (API) for relational database access, and it uses function calls to pass dynamic SQL statements as function arguments. Other languages can use the ODBC API, but it is usually defined using the C language.

ODBC is an alternative to embedded dynamic SQL, but unlike embedded SQL, it does not require that a program be precompiled. ...

Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.