Profile

e-Catalog

Contact

Search

Cart

IBM DB2 Universal Database 5.0: Advanced 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 and SQL; knowledge of a programming language; completion of the courses IBM DB2 Universal Database 5.0: Database Objects and Data Manipulation and IBM DB2 Universal Database 5.0: Embedded SQL Programming.

Course Aim

To provide the student with a detailed understanding of DB2 programming methods

Learning Objectives

Utilize dynamic SQL. Analyze the contents of the SQLDA. Implement stored procedures. Identify user-defined functions. Use the CLI and ODBC in applications. Use the EXPLAIN tool.

Topics Covered

Dynamic SQL programming - Dynamic SQL - Dynamic SQL phases - Package caching - The SQL Descriptor Area Stored procedures - Implementing stored procedures - Creating a stored procedure - Calling a stored procedure Other programming options - User-defined functions - Compound SQL - The Call Level Interface - ODBC Using the Explain facility - How the Explain facility works - Querying access plans - Hands-on: Using Visual Explain - Analyzing access paths - Using Explain effectively