Main Frames Training

Main Frames Online Training

Introduction to the Mainframe Concepts

  • Introduction to IBM Mainframe Systems
  • IBM Mainframe Architecture
  • Data and Job Management
  • Operating Systems
  • TSO, ISPF

COBOL (Common Business Oriented Language)

  • Introduction to COBOL and its versions
  • COBOL Program Structure
  • Field Declaration – Data Types
  • COBOL Statements
  • ACCEPT
  • DISPLAY
  • MOVE
  • INITIALIZE
  • IF Statement
  • EVALUATE
  • STRING and UNSTRING
  • COPY
  • COMPUTE
  • PERFORM
  • REDEFINES
  • RENAMES
  • Computational Usages
  • STOP RUN, GOBACK, EXIT PROGRAM
  • EXAMINE, INSPECT
  • COBOL programming using Sequential, Indexed and Relative files
  • COBOL Report generation programming
  • Real-time Programs using files
  • COBOL programming with arrays
  • Using arrays in programs with SEARCH & SEARCH ALL
  • Subscripting & Indexing
  • Sorting & Merging
  • Resolving File Status codes and abends
  • Coding Real-time Programs

JCL (Job Control Language)

  • JCL – Batch Processing (JES2 & JES3)
  • JOB, EXEC and DD statements – Parameters
  • JOBLIB, STEPLIB and JCLLIB
  • Symbolic & Overriding parameters
  • In stream & Cataloged Procedures
  • RESTART, PARM, COND, Refer back, DUMMY, and
  • TYPRUN
  • Temporary Datasets
  • IBM Utilities
  • GDG and its uses
  • Sorting & Merging files
  • Reformatting file data
  • INCLUDE, OMIT
  • JCL Errors and resolving abends
  • Coding Real-time JCLs

Db2 (Database2)

  • Db2-Database concepts
  • Db2 Organization
  • Table spaces, Tables, Views, Indexes,
  • Synonyms, Aliases
  • Using SQL Queries
  • DDL (CREATE, ALTER, DROP)
  • DML (SELECT, INSERT, UPDATE, DELETE)
  • DCL (GRANT & REVOKE)
  • Group By, Having, Order By
  • Joins & Unions
  • Sub-queries
  • DCLGEN, SPUFI and QMF
  • Db2 Utilities
  • NULLS – Null Indicators
  • Cursors and Types
  • SQLCA
  • Db 2 Program Preparation
  • Pre-compilation
  • BIND – Packages & Plans
  • Db2 Locking and Concurrency
  • Locking Modes
  • Isolation Levels
  • Commit & Rollback
  • Constraints
  • Db2 Performance issues and tuning techniques
  • SQLCODES and resolving abends
  • COBOL – Db2 Real-time Programming
  •  File status codes and abends codes
  • Coding Programs using VSAM files

Tools

  • File-Aid for files & Db2
  • Changeman / Endeavors

Expeditor


Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message