EncartaLabs

DB2 UDB Programming

( Duration: 3 Days )

In DB2 UDB Programming training course, attendees acquire the skills needed to produce application programs that manipulate DB2 databases. They also learn to embed SQL statements in C programs and prepare programs for execution.

By attending DB2 UDB Programming workshop, attendees will learn to:

  • 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

  • Have experience with SQL and C programming languages and be able to complete skeleton programs in C and construct and use SQL statements.

  • Application programmers

COURSE AGENDA

1

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
2

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
3

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
4

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
5

Recovery and locking concepts

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

Dynamic SQL introduction

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

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
8

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top