DB2 for z/OS Application Programming (CV720G)

Course Description Schedule
 

Who should attend

Please refer to Course Overview for description information.

Prerequisites

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

Duration 2 days

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

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

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


Digital courseware Dates and Booking
 
Click on town name to bookSchedule
Germany
27/02/2017 - 28/02/2017 Hamburg
02/05/2017 - 03/05/2017 Munich
19/06/2017 - 20/06/2017 Düsseldorf
14/08/2017 - 15/08/2017 Berlin
09/10/2017 - 10/10/2017 Frankfurt
Austria
02/05/2017 - 03/05/2017 Vienna (iTLS)