Advanced Programming for DB2 z/OS  (CV770)

Compétences acquises

• 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

Qui peut en profiter

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.

Préalables

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 (CV72) or equivalent experience
• DB2 9 for z/OS Stored Procedures (CV73) or equivalent experience
• Java programmers should attend course DB2 9 for z/OS Programming Using Java (CV14)

Abstract

IBM Education Advantage Program eligibility:

• Yes - IBM Education Pack - online account