Dynamic SQL Concepts

• Computer Exercise:  Course setup

EXECUTE IMMEDIATE
PREPARE
Parameter Markers
EXECUTE

• Computer Exercise:  Dynamic SQL – Parameter Markers

Dynamic Data Retrieval
Fixed List SELECT statements
DECLARE CURSOR
OPEN, FETCH, CLOSE
Dynamic SQL Bind Options
Special Registers and Dynamic SQL

• Computer Exercise:  Dynamic SQL – Fixed List SELECT

Variable List SELECT statements
SQLDA
Dynamic memory management
DESCRIBE INTO
SQLTYPE

• Computer Exercise:  Dynamic SQL – Variable List SELECT

REXX and Dynamic SQL

• Computer Exercise:  Dynamic SQL in REXX

Parameter markers and SQLDAs

• DESCRIBE INPUT
• EXECUTE and OPEN USING DESCRIPTOR

Resource Limit Facility
Debugging tools