DB2 Dynamic SQL - Topical Outline

Dynamic SQL concepts
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
    Optional Computer Exercise: Dynamic SQL in REXX

Parameter markers and SQLDAs
   DESCRIBE INPUT
   EXECUTE USING DESCRIPTOR
   OPEN USING DESCRIPTOR
Resource Limit Facility
Debugging Tools

Course information: G-563 / 1 Day   These Materials © Copyright 2007 by Hunter Cobb    V2.x

Course Objectives
Course description
Home page

this page last updated: 11 February, 2007
this page copyright © 2007 by The Trainer's Friend, Inc.