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

Overview

This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution.

Skills Covered

  • 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

Prerequisites

  • 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.

Target Audience

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

Course Curriculum

Module 1: DB2 Concepts
Module 2: Program Structure I
Module 3: Program Preparation
Module 4: Program Structure II
Module 5: Recovery and Locking Concepts
Module 6: Dynamic SQL Introduction
Module 7: Managing Test Data
Module 8: Performance Considerations

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

x Clear all selections
Trainocate exam and cert

Exam & Certification

Yes

Training & Certification Guide

Frequently Asked Questions

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes