IBM Mainframes training in Hyderabad
Mainframe 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
JCL(Job Control Language)
- Introduction to JCL – Batch Processing (JES2 & JES3)
- JOB, EXEC and DD statements – Parameters
- JOBLIB, STEPLIB and JCLLIB
- Symbolic & Overriding Parameters
- Instream & Cataloged Procedures
- Temporary Datasets
- RESTART, PARM, COND, Referback, DUMMY, TYPRUN
- GDG and its uses
- Sorting & Merging files
- Reformatting file data
- INCLUDE, OMIT
- JCL Errors and resolving abends
- Coding Realtime JCLs
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
CICS(Customer Information Control System)
- Introduction to CICS
- Batch vs Online systems
- CICS System tables
- Triggering CICS transactions
- Conversational and Pseudo-conversational programming
- BMS Macros – Maps and Mapsets
- CICS commands
- EIB
- Commarea
- Exceptional conditions
- Handle condition
- Ignore Condition
- RESP
- Control Operations
- TDQs and TSQs
- Return, XCTL and LINK
- ASKTIME, FORMATTIME, START, ATI, CANCEL
- CICS Abend codes and resolutions
- Coding Online programs using COBOL, CICS, VSAM and DB2
Tools
- File-Aid for files & DB2
- Changeman
- Xpeditor
Software Engineering
- Application development covering all phases of SDLC
- Quality Management
- Documentation