IBM - DB2 for z/OS - Advanced Programming for DB2 z/OS

PROKODA Gmbh
In Düsseldorf

2.890 
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0221/... Mehr ansehen

Wichtige informationen

Beschreibung

IBM - DB2 for z/OS - Advanced Programming for DB2 z/OS: Zielgruppe This advanced course is for the classical COBOL or PL/I mainframe programmer and C, C++ programmer with an interest in advanced topics and recommended practices to code and prepare high performing programs in a DB2 for z/OS environment. The programs in the lab exercises are pre-coded using COBOL; the student must..
Gerichtet an: Zielgruppe This advanced course is for the classical COBOL or PL/I mainframe programmer and C, C++ programmer with an interest in advanced topics and recommended practices to code and prepare high performing programs in a DB2 for z/OS environment. The programs in the lab exercises are pre-coded using COBOL; the student must only supply the DB2/SQL specifics. Kursziele Develop high performing database applications that align with the organizations application growth plan and...

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Düsseldorf
Monschauer Str. 7, 40549, Nordrhein-Westfalen, NRW, Deutschland
auf Anfrage
Düsseldorf
Kanzlerstraße 4, 40472, Nordrhein-Westfalen, NRW, Deutschland
Plan ansehen

Häufig gestellte Fragen

· Voraussetzungen

You should have: DB2 SQL Workshop (CE12) or equivalent SQL knowledge DB2 SQL Workshop for Experienced Users (CE13) or equivalent SQL knowledge DB2 9 for z/OS Application Programming Workshop (CV72D1DE) or equivalent experience DB2 9 for z/OS Stored Procedures (CV73D3DE) or equivalent experience Java programmers should attend course DB2 9 for z/OS Programming...

Themenkreis

KURSZIEL
IBM - DB2 for z/OS - Advanced Programming for DB2 z/OS: Zielgruppe
This advanced course is for the classical COBOL or PL/I mainframe programmer and C, C++ programmer with an interest in advanced topics and recommended practices to code and prepare high performing programs in a DB2 for z/OS environment. The programs in the lab exercises are pre-coded using COBOL; the student must only supply the DB2/SQL specifics.
Kursziele
  • Develop high performing database applications that align with the organizations application growth plan and maintenance strategy
  • Process SQL statements using the DB2 Pre-compiler or DB2 Coprocessor
  • Code, prepare and run dynamic SQL programs
  • Code applications that coordinate updates across multiple servers
  • Debug applications using the DEBUG tool for z/OS
  • Describe some components and architectural characteristics of Web applications and the role that DB2 plays in the Web application environment
  • Describe how your program can interact with the Web
  • Manipulate large objects
  • Facilitate the exchange of large objects between DB2 and local data sets
  • Develop applications that minimize locks on resources to support concurrent programs
  • Use scrollable cursors efficiently
  • Use stored procedures
  • Consider using tools as an alternative to writing a program
  • Write applications that do not hinder other applications


ZIELGRUPPE
Zielgruppe
This advanced course is for the classical COBOL or PL/I mainframe programmer and C, C++ programmer with an interest in advanced topics and recommended practices to code and prepare high performing programs in a DB2 for z/OS environment. The programs in the lab exercises are pre-coded using COBOL; the student must only supply the DB2/SQL specifics.
Kursziele
  • Develop high performing database applications that align with the organizations application growth plan and maintenance strategy
  • Process SQL statements using the DB2 Pre-compiler or DB2 Coprocessor
  • Code, prepare and run dynamic SQL programs
  • Code applications that coordinate updates across multiple servers
  • Debug applications using the DEBUG tool for z/OS
  • Describe some components and architectural characteristics of Web applications and the role that DB2 plays in the Web application environment
  • Describe how your program can interact with the Web
  • Manipulate large objects
  • Facilitate the exchange of large objects between DB2 and local data sets
  • Develop applications that minimize locks on resources to support concurrent programs
  • Use scrollable cursors efficiently
  • Use stored procedures
  • Consider using tools as an alternative to writing a program
  • Write applications that do not hinder other applications


KURSINHALT
This is the classroom version of Instructor Led Online course Advanced Programming for DB2 z/OS - Instructor Led Online (3V770).
This course provides lectures and hands-on lab exercises for the advanced application developer in a DB2 for z/OS environment.
You are expected to apply the knowledge acquired in this course to code and prepare high performing concurrent, static and dynamic programs supporting a local, remote, or distributed DB2 environment. An array of topics are taught which facilitates the coding and the maintenance of programs to enable you to write multi-purpose flexible programs that process large objects, use stored procedures, scroll through result sets, interact with the web, improve the usability of an application, use tools verses writing an application, and debug an application using the IBM Debug Tool.
Themenübersicht
  • Application Architecture
  • Application Architecture Exercise
  • Program Preparation
  • Dynamic SQL
  • Dynamic SQL Exercise
  • Distributed Data Access
  • Distributed Data Access Exercise
  • DEBUG Tool for z/OS
  • DEBUG Tool for z/OS Exercise
  • DB2 and the Web
  • Large Objects
  • Large Objects Exercise
  • Locking
  • Locking Exercise
  • Scrollable Cursors
  • Scrollable Cursors Exercise
  • Using Stored Procedures
  • Using Stored Procedures Exercise
  • Tools versus Applications
  • Tools versus Applications Exercise
  • Performance
  • Performance Exercise


VORRAUSSETZUNG
You should have:
  • DB2 SQL Workshop (CE12)or equivalent SQL knowledge
  • DB2 SQL Workshop for Experienced Users (CE13)or equivalent SQL knowledge
  • DB2 9 for z/OS Application Programming Workshop (CV72D1DE)or equivalent experience
  • DB2 9 for z/OS Stored Procedures (CV73D3DE)or equivalent experience
  • Java programmers should attend course DB2 9 for z/OS Programming Using Java (CV14D1DE)

Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen