Build specialized database programming skills with the DB2 11 for z/OS Application Programming Workshop, a practical training program designed for professionals who develop and maintain applications in IBM z/OS environments. The workshop focuses on the techniques required to build applications that efficiently interact with Db2 databases and apply structured database programming practices.
Course Overview:
The DB2 11 for z/OS Application Programming Workshop provides practical, hands-on training for professionals who need to develop and execute application programs that interact with DB2 databases. Participants will learn how to integrate Structured Query Language (SQL) into application programs, retrieve and manipulate DB2 data, and prepare applications for successful execution in a mainframe environment.
The course focuses on the essential techniques required for DB2 application programming, including writing embedded SQL statements, handling database operations, preparing programs for execution, and applying best practices for reliable database-driven applications. Through practical exercises, participants will strengthen their ability to develop programs that efficiently access and manage data in IBM DB2 for z/OS environments.
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
Pre-requisites:
To get the most out of this DB2 11 for z/OS Application Programming Workshop, participants should have a working knowledge of mainframe programming and SQL. The following experience is recommended:
- COBOL or PL/I Programming Experience – Participants should have practical experience developing programs using COBOL or PL/I on z/OS.
- SQL Knowledge – Participants should be able to write, understand, and execute basic SQL statements for querying and manipulating database data.
- Basic DB2 Knowledge – Familiarity with fundamental DB2 database concepts, such as tables, columns, rows, and database operations, is recommended.
- Mainframe Environment Familiarity – Previous experience working in an IBM z/OS environment is beneficial for understanding the application development and execution process.
Target Audience:
This intermediate-level DB2 11 for z/OS Application Programming Workshop is designed for professionals who develop, maintain, or support database-driven applications in IBM z/OS environments, particularly those working with embedded SQL.
- Application Programmers – Professionals who need to develop application programs that access and manipulate DB2 databases using embedded SQL.
- COBOL Programmers – Mainframe developers who want to strengthen their skills in writing and executing embedded SQL programs using COBOL on z/OS.
- PL/I Programmers – Developers who work with PL/I and need practical experience integrating SQL statements into DB2 applications.
- Mainframe Developers – IT professionals developing and maintaining enterprise applications within IBM z/OS environments.
- DB2 Application Developers – Developers seeking to improve their ability to design, code, and execute applications that interact with DB2 databases.
- Database and IT Professionals – Professionals who support application development and database operations and want to enhance their understanding of DB2 application programming.
Recommended Experience: Participants should have an intermediate understanding of COBOL or PL/I programming and basic familiarity with DB2 and SQL concepts.
Course Duration:
- 21 hours – 3 days
Course Content:
- DB2 Concepts
- Program Structure I
- Program Preparation
- Program Structure II
- Recovery and Locking Concepts
- Dynamic SQL Introduction
- Managing Test Data
- Performance Considerations
