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.

Course information: G-563 / 1 Day   These Materials © Copyright 2007 by Hunter Cobb    V2.x

Topical outline
Course description
Home page

this page last updated: 11 February, 2007
this page copyright © 2007 by The Trainer's Friend, Inc.