DB2 Dynamic SQL

Course Number:  617-TF
Recommended Duration:  1 day

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

Course Overview
This course shows how to build and execute SQL statements on the fly, for the ultimate flexibility in working with DB2 tables.

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

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

Topics

• 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