Profile

e-Catalog

Contact

Search

Cart

IBM DB2 Universal Database 5.0: Embedded SQL Programming

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Application developers involved in creating applications on DB2 databases

Prerequisites

A basic understanding of relational databases, SQL, and third- or fourth-generation languages

Course Aim

To provide the student with a detailed understanding of embedded SQL programming

Learning Objectives

Understand the use of static embedded SQL and where it can be used. Understand the SQLCA. Handle errors in SQL programs. Utilize host variables. Use cursors for data query and data modification. Incorporate the transaction or unit of work in programs.

Topics Covered

Embedded SQL guidelines - Static embedded SQL - The SQL Communications Area - Checking SQLCODE and error handling - Host variables Programming with cursors - Using cursors in SQL programming - Cursor operations - Data modification using cursors Programming guidelines - Units of work - Restartable programs - Modifying data using embedded SQL