htalogo2.gif

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.

 

These Materials © Copyright 2013 by Hunter Cobb

Materials version: V2.x

 

Topical Outline
Course Description
Home page