Pre-requisites
The participant should be familiar with Basic programming Concepts

Description

• Course designed to provide system administration skills needed for developing and maintenance applications in mainframe platform
• Course includes MVS, JCL, VSAM, COBOL, CICS and DB2/UDB
  
• Lab equipped with IBM S/390 Mainframe

Duration
8 weeks (Full time)

Course Contents

Large Systems Overview

• TSO, ISPF/ PDF
  
  • Logon process
    
  • TSO Commands

Job Control Language (JCL)

• Introduction
  
• JCL statements
  
• SDSF
  
• JCL utilities
  
• Procedures - Instream and Catalogued

VSAM

•  Access Methods
  
•  VSAM datasets
  
•  VSAM commands
  
•  Define, Listcat, Delete, Repro, Verify, Export, Import
  
•  Dataset Sharing Options

Programming using COBOL

•  Introduction to COBOL
  
•  Divisions
  
•  Data names, data types, Clauses
  
•  Level numbers and Special level numbers
  
•  Procedure division
  
•  Arithmetic verbs
  
•  Data movements
  
•  Conditional and unconditional transfers
  
•  Perform statements
  
•  Array handling
  
•  File Handling - (VSAM and Non-VSAM)
  
•  Static and Dynamic calls

DB2 application programming

•  DB2 Overview
  
•  Database design
  
•  Objective
  
•  Data types
  
•  Referential Integrity
  
•  Structured Query Language (SQL)
  
•  Creating and altering Tables, Views and Indexes
  
•  DDL, DCL and DML
  
•  DB2 application programming concepts
  
•  Embedded SQLs
  
•  SQLCA
  
•  Host variables and indicator variables
  
•  Using Cursors
  
•  Dynamic SQLS

CICS application programming

•  CICS Fundamentals
  
•  CICS application programming
  
•  Structure
  
•  Conversation and Pseudo conversation techniques
  
•  CICS commands
  
•  Maps and Displays
  
•  Reading External data
  
•  Updating External data
  
•  CICS-VSAM, CICS-DB2
  
•  Queuing Facilities