DB2 11 for z/OS Application Programming Workshop

• DB2 Concepts
• Program Structure I
• Program Preparation
• Program Structure II
• Recovery and Locking Concepts
• Dynamic SQL Introduction
• Managing Test Data
• Performance Considerations

This intermediate course is for application programmers who need to write embedded SQL programs in COBOL or PL/I (on z/OS).

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.

\n
• Incorporate static SQL statements in an application program
\n
• Prepare the program for execution
\n
• Validate execution results are correct
\n
• Produce code to support multiple rows being returned from the database manager using cursors
\n
• Identify considerations regarding units of work, concurrency, and restart of programs
\n
• Identify differences between static and dynamic SQL
\n
• Provide test data for applications
\n
• Discuss program and DB2 options relative to performance of static SQL
\n