> > CV720G

DB2 for z/OS Application Programming (CV720G)

Course Description Schedule

Who should attend

Please refer to Course Overview for description information.


Prior to attending this course, you should already have experience with one of the supported programming languages, COBOL or PL/I for z/OS. You are also expected to already be able to construct and use SQL statements.

Course Objectives

  • 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

Course Content

  • Unit 1 - DB2 Concepts
    • Exercise 1: DDL
  • Unit 2 - Program Structure - Part 1
    • Exercise 2: Program Structure I
  • Unit 3 - Program Preparation
    • Exercise 3: Program Preparation
  • Unit 4 - Program Structure - Part 2
    • Exercise 4: Program Structure II
  • Unit 5 - Recovery and Locking Concepts
    • Exercise 5: Cursor Restart
  • Unit 6 - Dynamic SQL Introduction
    • Exercise 6: Dynamic SQL
  • Unit 7 - Managing Test Data
    • Exercise 7: Loading Data
  • Unit 8 - Performance Considerations
    • Exercise 8: Performance
Classroom Training
Modality: C

Duration 2 days

Price (excl. tax)
  • Germany: 1,490.- €
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.

Digital courseware Dates and Booking

Currently there are no training dates scheduled for this course.  Enquire a date


Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!