DB2 UDB Programming Fundamentals

start > courses and registration > training feature sheet

code.

CF104

length.

3 days

type.

Instructor-Led

partner.

IBM

price.

$1,950

Acquire the skills you need to produce application programs that manipulate DB2 databases. Learn to embed SQL statements in C programs and prepare programs for execution.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

Application programmers who need to write embedded SQL programs in C language.

This course addresses the use of static and simple dynamic embedded SQL. It also addresses coding of stored procedures.

If your programming needs include the use of User Defined Functions (UDF), Application Programming Interfaces (API), or Call Level Interface (CLI), you should also complete:

	DB2 UDB Advanced Programming (CF114)
	If you are a programmer with static SQL coding experience on another platform, such as DB2 for z/OS, you should not attend this course, but you may be interested in attending CF114.

prerequisites

You should complete:

	DB2 Family Fundamentals (CE030)
	DB2 SQL Workshop (CE120) or
	Introduction to C Programming - AIX/UNIX (Q1070)
	or have equivalent knowledge. You should have experience with SQL and C programming languages and be able to complete skeleton programs in C and construct and use SQL statements.

skills gained

	Incorporate static SQL statements in an application program
	Prepare the program for execution
	Validate execution results are correct
	Produce code to support multiple rows being returned from the database manager using cursors
	Identify considerations regarding units of work, concurrency, and restart of programs
	Identify differences between static and dynamic SQL
	Provide test data for applications
	Discuss program and DB2 options relative to performance of static SQL

ibm education advantage program eligibility:

Yes - IBM Education Pack - online account

related courses, exams and materials

	before related training and products

CF114 DB2 UDB Advanced Programming

course content details

	DB2 concepts

	identify DB2 family products
	explain DB2 workstation component functions
	identify DB2 objects
	identify the key differences between static SQL and other application alternatives for accessing DB2 data

	Program structure I

	embed INSERT, UPDATE, DELETE and single-row SELECT statements in application programs
	effectively communicate with DB2 when processing NULL values and determining the success of statement execution
	demonstrate use of DB2 coding aids
	code CONNECT statements within an application program
	identify connection types and impacts on a unit of work

	Program preparation

	identify the additional steps necessary to prepare a program that contains embedded SQL for execution
	describe the functions of the DB2 PRECOMPILE and BIND processes
	describe factors relevant to the BIND process, including RUNSTATS positioning, package status, parameters, and authorization requirements

	Program structure II

	use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle select criteria that may return multiple rows in application programs
	issue positioned UPDATE and DELETE statements
	use compound SQL

	Recovery and locking concepts

	define a unit of recovery
	identify the basic locking strategies used by DB2

	Dynamic SQL introduction

	describe the difference between static and dynamic SQL
	list the types of dynamic statements
	code dynamic SQL in a program

	Managing test data

	identify methods to insert data into a table
	use the LOAD or IMPORT utility
	identify the purpose of the RUNSTATS utility
	identify the purpose of the REORG utility

	Performance considerations

	use programming techniques that enhance DB2 application performance by following general guidelines, using indexable predicates, and avoiding unnecessary sorts
	identify the access paths available to DB2
	list common causes of deadlocks and avoid such causes when possible
	use the EXPLAIN tools as aids to develop applications that emphasize performance

	Daily Agenda - Day 1

	Welcome
	Unit 1 - DB2 Concepts
	Lab - DDL
	Unit 2 - Program Structure - Part 1
	Lab - Program Structure I

	Day 2

	Unit 3 - Program Preparation
	Lab - Program Preparation
	Unit 4 - Program Structure - Part 2
	Lab - Program Structure II
	Unit 5 - Recovery and Locking Concepts
	Lab - Cursor Restart

	Day 3

	Unit 6 - Dynamic SQL Introduction
	Lab - Dynamic SQL
	Unit 7 - Managing Test Data
	Lab - Loading Data
	Unit 8 - Performance Considerations
	Lab - Performance