DB2 Dynamic SQL - Topical Outline

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

Optional Computer Exercise: Dynamic SQL in REXX

Parameter markers and SQLDAs

DESCRIBE INPUT

EXECUTE and OPEN USING DESCRIPTOR

Resource Limit Facility

Debugging tools

G563 / 1 Day

These Materials © Copyright 2011 by Hunter Cobb

Materials version: V2.x

Course Objectives
Course Description
Home page

This page last updated: 23 November, 2011
Copyright © 2011 by The Trainer's Friend, Inc.