Mainframe Db2 Developer Training By Anil Polsani

DB2- Pre-compilation - Cursor - Restart logic - sqlcode - Load & Unload

What you'll learn

11 Hours of DB2 Developer Training

15 sessions Covered in theory and Practical's

Best concept explained in simple by Anil Polsani - Check my Youtube channel for more

Practical Environment will be given for a price contact me for the same

Requirements

You should have basic knowledge on COBOL and Doing Mainframe Practical's

Description

Hello Friends, This is me Anil Polsani.This Course is Intend to provide deeper knowledge on the Mainframe DB2 database with good amount theory and best practical's with excellent explanation. In this course we will be Covering Topics like Pre-compilation , Package Plan , SQL all query thru COBOL programs, Cursor concept , SQL query with Main program and Sub-Programs and Many things like.Bulk Update Process , Handling of SQLCODEs -803 -811 -305 -904, DB2 Restart Logic , Load and Unload Concepts , How to code SQL Select query , Joins , ViewsYou can also See my demo videos in Youtube channel as well. You can Search for any Mainframe Module and you can find our channel video, More easy you can search by name as well.This Course is only on COBOL-DB2, There are other video that will be placed in next month. You Can also contact me for the Mainframe software so that you can do the Practice the Training Programs that are explained in the course.You can also join my live training session in here or you can contact me for more details of the training course. We have training thru batch/in group and we provide 1 to 1 training as well. Thanks,Anil Polsani

Overview

Section 1: Mainframe DB2 Course Theory and Practical's

Lecture 1 Introduction to Mainframe DB2

Lecture 2 Mainframe DB2 Understanding DB2 Table and Constraints

Lecture 3 How to Code COBOL-DB2 Program

Lecture 4 COBOL-DB2 Pre-compilation and bind Process

Lecture 5 COBOL-DB2 Create Table and Code Program

Lecture 6 COBOL-DB2 Insert Program

Lecture 7 COBOL-DB2 Select - Cursor Concept

Lecture 8 COBOL-DB2 Select - Cursor Programs

Lecture 9 COBOL-DB2 Cursor Programs

Lecture 10 COBOL-DB2 Update with Cursor Programs

Lecture 11 COBOL-DB2 Update Mainpgm - Subpgm Update

Lecture 12 COBOL-DB2 Update Restart Logic Programs

Lecture 13 COBOL-DB2 Load and Unload Concept

Lecture 14 COBOL-DB2 Load and SQLCODE Error codes

Lecture 15 COBOL-DB2 SQL Select Query

Beginner's and Expert who want to re-fresh and get deeper knowledge on DB2