DB2 Dynamic SQL

Why take this course?

After completing this course, you will be able to
  • Develop and use DB2 Dynamic SQL in application programs to modify DB2 tables
  • Use parameter markers to allow flexible reuse of prepared dynamic SQL statements
  • Utilize fixed list SELECTs to retrieve data from DB2 tables
  • Understand and use SQLDAs to implement variable list SELECTs
  • Understand how SQLDAs can be used to implement dynamically specified parameter markers
  • Use Dynamic SQL in the REXX programming language
1 Day : Fee - $ 697.00 (CAD) : ? Multi-seat - $ 497.00 (CAD)
Mon Apr 11, 2016
Ottawa
Thu May 26, 2016
Ottawa
Thu Jun 30, 2016
Ottawa
Fri Aug 5, 2016
Ottawa
Contact us to arrange your preferred location and date
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.

Major topics covered?

  • 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
Copyright © 2014 by Hunter Cobb & Steve Comstock