DB2 11 for z/OS Application Programming Workshop

IBM Training for DB2 11 for z/OS Application Programming Workshop

Skill Level: Intermediate

Modality: CR - Classroom based Trainng or ILO - Instructor Led Online Class

Duration: 3 Day/s

Starting Price: $ - 3,946

Overview:

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

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.

Cyber Retaliator Solutions

CRS is the Top Global Training Provider for some of the world’s biggest brands.
Authorized Training delivered to you by the global leader in IBM Training.

Request a Quote

Target Audience:

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

.

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

Topic: DB2 Concepts

Program Structure I

Program Preparation

Program Structure II

Recovery and Locking Concepts

Dynamic SQL Introduction

Managing Test Data

Performance Considerations

IBM Training

Objective: _x000D_

Incorporate static SQL statements in an application program

_x000D_

Prepare the program for execution

_x000D_

Validate execution results are correct

_x000D_

Produce code to support multiple rows being returned from the database manager using cursors

_x000D_

Identify considerations regarding units of work, concurrency, and restart of programs

_x000D_

Identify differences between static and dynamic SQL

_x000D_

Provide test data for applications

_x000D_

Discuss program and DB2 options relative to performance of static SQL

_x000D_

Category: Data, Analytics, and AI

Product Name:

Db2 for z/OS

Badge and Certification Info:

Badge Title: DB2 11 for z/OS Application Programming Workshop - Code: CV722G

Badge ID: 8c45cf09-67a0-4bb2-b9fa-d4da44f80056

Brand: Analytics

IBM Training is available now.

Cyber Retaliator Solutions (CRS) is a Cyber Security Distributor, Authorized IBM Training Center, Red Hat and SUSE Training Partner, and a CompTIA Training Delivery Partner, operating throughout the Globe. Our Head Office is in Centurion South Africa, with IBM Training Centers in Centurion, Midrand, Sandton, Cape Town, California CA, Florida FL, New York NY, Washington DC, Georgia GA, Texas TX.

CRS is the Top Global Training Provider for some of the world's biggest brands.

Authorized Training delivered to you by the global leader in IBM Training.

Select courses in:

IBM Cloud

DataPower

IBM Automation

IBM Rational

Watson

IBM Tivoli

IBM Systems

Cognos

IBM Storage

Mainframe

IBM Security

System Z

IBM Industry

IBM Asset Management

Websphere

IBM Data and AI

Get the Best IBM Training from CRS. As an IBM Training Provider, we've partnered with IBM through Arrow ECS to deliver training that covers the full portfolio of IBM systems and software.

Authorized IBM Training

RedHat Training

SUSE Training

Agile SAFe Training

Cyber Awareness Training

Cyber Security

Get the Best IBM Training from CRS. As an IBM Training Provider, we've partnered with IBM through Arrow ECS to deliver training that covers the full portfolio of IBM systems and software.

Authorized IBM Training

RedHat Training

SUSE Training

Cyber Awareness Training

Agile SAFe Training

Cyber Security

Cyber Data IT Network Security - The bug stops here - Cyber Retaliator Solutions

Cyber Retaliator Solutions - IBM Training - IBM Certification Training -