DB2 Application Programming (PL/1) (Rel 2.3)

Outline

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Topics Include
6. Duration
7. Minimum Requirements
8. Media

Description

This course teaches students how to use embedded SQL in their applications to retrieve and update information contained in DB2.

Audience

Application Developers and Programmers.

Prerequisites

Knowledge of DB2 and programming concepts.

Topics Include

DB2 Overview Relational Database Characteristics; DB2 Structure; DB2 Features; DB2 Access; Data Retrieval with SQL SELECT Statement SELECT FROM; SELECT DISTINCT FROM; SELECT using Calculations; SELECT FROM...WHERE...; SELECT AND/OR; SELECT IN…; SELECT BETWEEN...AND...; SELECT LIKE; SELECT...ORDER BY [ASC.DESC]; Joining Two Tables in a SELECT; More Data Retrieval with SQL SELECTing a Group Function (AVG, SUM, MIN, MAX, COUNT); Simple Grouping; Groups HAVING certain Conditions; Filter before Selecting; Sub-queries; SQL Data Manipulation INSERTing new Rows; INSERTing from Another Table; UPDATE of Row Information; DELETE Rows; DB2 Application Program Structure Embedded SQL Statements; SQL Statement Format; Using Host Variables; Include Statements; SQL Communications Area (SQLCA); Steps to Program Execution Pre-compile; Compile and Link-Edit; BIND: (creating the DB2 Plan); Execution; Simple Data Modification Programming Global UPDATE; Unique Record UPDATE; Global DELETE; Unique Record DELETE; INSERTing a Row; INSERTing Multiple Rows using SELECT; Data Retrieval Programming Using Cursors Review Simple SELECT; Multiple Record SELECT; Using DISTINCT to Prevent Duplicate Rows; Data Modification Programming Using Cursors Rationale Explained; UPDATE a Fetched Record; DELETE a Fetched Record; Application Program Performance BIND Considerations; Commit/Rollback; Use of Dynamic SQL;

© Copyright Serebra Learning Corp., 2002