Skip to main content


developerWorks  >  Information Management  >

DB2 9 Application Development exam 733 prep, Part 5: CLI/ODBC programming

developerWorks

Level: Intermediate

Roger E. Sanders (rsanders@netapp.com), Senior Manager - IBM Alliance Engineering, Network Appliance, Inc.

15 Feb 2007

Register now or sign in using your IBM ID and password.

This tutorial introduces you to DB2 Call-Level Interface (CLI)/ODBC programming and walks you through the basic steps used to construct a CLI/ODBC application. This tutorial also introduces you to the process used to convert one or more high-level programming language source code files containing CLI/ODBC function calls into an executable application. This is the fifth tutorial in a series of nine tutorials that are designed to help you prepare for the DB2 UDB V9.1 Application Developer Certification exam (Exam 733).

In this tutorial

This is the fifth in a series of nine tutorials that are designed to help you prepare for the DB2 V9.1 Application Developer Certification exam (Exam 733). The material in this tutorial covers the objectives in Section 5 of the exam, entitled "CLI/ODBC Programming".


Objectives

  • Learn what environment, connection, statement, and descriptor handles are, and how they are used by CLI/ODBC applications

  • Learn about the steps involved in developing a CLI/ODBC application

  • Learn the correct sequence to use when calling CLI/ODBC functions

  • Learn how to establish a database connection from a CLI/ODBC application

  • Learn how to configure a CLI/ODBC driver

  • Learn how to evaluate CLI/ODBC function return codes and obtain diagnostic information when errors occur

  • Learn how to convert source code files containing CLI/ODBC function calls into an executable application

Prerequisites

To take the DB2 9 Family Application Development exam, you must have already passed the DB2 9 Family Fundamentals exam (Exam 730). You can use the "DB2 Family Fundamentals tutorial series" to prepare for that exam. It is a very popular series that has helped many people understand the fundamentals of the DB2 family of products.


System requirements

You do not need a copy of DB2 9 to complete this tutorial. However, if you wish, you can download a free copy of DB2 Express-C 9 from the DB2 Express-C downloads page.



Duration

Less than two hours


Formats

html, pdf


Share this....

digg Digg this story del.icio.us del.icio.us Slashdot Slashdot it!


Back to top


Document options

Document options requiring JavaScript are not displayed

Discuss


More in this series:
DB2 9 Application Development exam 733 prep