TTFlogo2.gif (2585 bytes)

Course Description

DB2 Dynamic SQL

This course: course objectives; course outline
Other links: DB2 curriculum; Topic list; Course list; Home page

Course Code: G-563
Recommended Duration: 1 Day

Benefits

The student will learn how to carry out Dynamic SQL statements in DB2.

Audience

Application developers who need to write programs that utilize Dynamic SQL.

Prerequisites

The student should have experience with basic SQL, as well as experience in doing DB2 application development.

Related IBM Materials

Classroom access to a set of DB2 Reference manuals is desirable, but not required.

Major Topics Include

EXECUTE IMMEDIATE
PREPARE
EXECUTE
Parameter Markers
Fixed-list SELECT statements
BIND options that affect Dynamic SQL
Special Registers that affect Dynamic SQL
Variable-list SELECT statements
SQLDA
DESCRIBE
SQLTYPES
Dynamic memory management
SQLDAs for parameter markers
Resource Limit Facility
Debugging Dynamic SQL programs
Dynamic SQL in REXX

Exercises

There are four machine exercises, and one optional machine exercise.

Course Objectives
Topical Outline
DB2 curriculum
Complete topics list
Home page

This page last updated: 17 November, 2011
This page copyright © 2011 by The Trainer's Friend, Inc.
This course copyright © 2011 by Hunter Cobb