DB2 Dynamic SQL - Course Objectives

On successful completion of this course, the student, with the aid of the appropriate reference materials, should be able to:

1. Develop and use DB2 Dynamic SQL in application programs to modify DB2 tables
2. Use parameter markers to allow flexible reuse of prepared dynamic SQL statements
3. Utilize fixed list SELECTs to retrieve data from DB2 tables
4. Understand and use SQLDAs to implement variable list SELECTs
5. Understand how SQLDAs can be used to implement dynamically specified parameter markers
6. Use Dynamic SQL in the REXX programming language.

G563 / 1 Day

These Materials © Copyright 2011 by Hunter Cobb

Materials version: V2.x

Topical Outline
Course Description
Home page

This page last updated: 23 November, 2011
Copyright © 2011 by The Trainer's Friend, Inc.