DB2 for z/OS Application Programming (CV720G)

Kursbeschreibung Kurstermine
 

Zielgruppe

Please refer to Course Overview for description information.

Voraussetzungen

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.

Kursziele

  • 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

Kursinhalt

  • 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

Dauer 2 Tage

Preis (exkl. MwSt.)
  • Deutschland: 1.490,- €
inkl. Verpflegung
Verpflegung umfasst:

  • Kaffee, Tee, Saft, Wasser, Cola
  • Gebäck und Süßigkeiten
  • Belegte Brötchen
  • Frisches Obst
  • Mittagessen in einem der naheliegenden Restaurants

Gilt nur bei Durchführung durch Fast Lane. Termine, die von unseren Partnern durchgeführt werden, beinhalten ggf. ein abweichendes Verpflegungsangebot.


Digitale Kursunterlagen Termine und Buchen
 
Zum Buchen bitte auf den Ortsnamen klickenKurstermine
Deutschland
27.02. - 28.02.2017 Hamburg
02.05. - 03.05.2017 München
19.06. - 20.06.2017 Düsseldorf
14.08. - 15.08.2017 Berlin
09.10. - 10.10.2017 Frankfurt
Österreich
02.05. - 03.05.2017 Wien (iTLS)