Course concepts

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

COBOL

• 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

 File Handling

• How to use files in COBOL Program?
• File Programming using Sequential, Indexed and Relative files
• Realtime programs using files

Table Handling

• Array Declaration
• Using arrays in programs with
• SEARCH & SEARCH ALL
• Subscripting & Indexing
• Sorting & Merging
• Resolving File Status codes and abends
• Coding Realtime Programs

DB2(RDBMS)

• DB2 – Database concepts
• DB2 Organization
• Tablespaces, Tables, Views, Indexes, Synonyms, Aliases
• Using SQL Queries
• DDL(CREATE, ALTER and DROP COMMANDS)
• DML(SELECT, INSERT, UPDATE and DELETE)
• DCL(GRANT & REVOKE)
• Group By, Having, Order By
• Joins
• Subqueries vs Correlated subqueries
• Unions
• DCLGEN, SPUFI and QMF
• DB2 Utilities
• NULLS – Null Indicators
• Cursors and Types
• SQLCA
• DB2 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 Realtime Programming

VSAM (File concept)

• Introduction to VSAM
• VSAM Datasets – ESDS, KSDS, RRDS
• Space management
• Alternate Indexes
• Dataset structures
• Defining Clusters
• IDCAMS – Repro, Print, Alter, Delete
• START, INVALID KEY
• Accessing VSAM files from COBOL
• File status codes and abend codes
• Coding programs using VSAM files

Tools

• File-Aid for files & DB2
• Changeman
• Xpeditor

Software Engineering

• Application development covering all phases of SDLC
• Quality Management
• Documentation