 | Level: Intermediate Roger E. Sanders (rsanders@netapp.com), Senior Manager - IBM Alliance Engineering, Network Appliance, Inc.
15 Feb 2007 This tutorial introduces you to embedded SQL programming and walks you through how to construct an embedded SQL application. This tutorial introduces the process for converting one or more high-level programming language source code files containing embedded SQL into an executable application. This is the fourth in a series of nine tutorials designed to help you prepare for the DB2 Application Developer Certification exam (Exam 733).
In this tutorial
This is the fourth 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 4 of the exam, entitled "Embedded SQL Programming".
Objectives - Learn how SQL statements are embedded in a high-level programming language source code file
- Learn the steps involved in developing an embedded SQL application
- Learn what host variables are, how they are created, and how they are used
- Learn what indicator variables are, how they are created, and when they are used
- Learn how to analyze the contents of an SQL Communications Area (SQLCA) data structure variable
- Learn how to establish a database connection from an embedded SQL application
- Learn how to capture and process errors when they occur
- Learn how to convert source code files containing embedded SQL 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
| | | |
