Course Title: DB2 Dynamic SQL
Course#: DB09T
Duration: 1 day
Overview:The student will learn how to carry out Dynamic SQL statements in DB2.
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
Exercises:There are three standard machine exercises and one optional machine exercise.
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.