Course Description

DB2 Dynamic SQL

This course: course objectives; course outline;
DB2 curriculum; Topic list; Course list; Home page

Benefits

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.

Related IBM Materials

Classroom access to a set of DB2 Reference manuals is desirable but not essential.

• 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.

Note:
Lecture notes include examples in COBOL, PL/I, C, Assembler, and REXX. Currently the labs are set up only for COBOL (with one optional exercise in REXX). If desired, we can add labs in PL/I, C, or Assembler, but we need to know your requirements.