1 Intro to Mainframe
2 Subsystems, Emulator Configuration
3 Differences between Batch & Online Application
4 Introduction to ISPF,ISPF options
5 Dataset types (NON-VSAM & VSAM datasets)
6 TSO commands
7 ISPF options 3.1, 3.2, 3.3
8 Intro to SPOOL

1 Introduction to JCL
2 How to write JCL segment
3 JCL components, JCL statements(JOB,EXEC and DD)
4 IBM utilities: IEFBR14, IEBGENER, IEBCOPY,IDCAMS,SORT & ICETOOL
5 PS and PDS file creations
6 Differences between positional and keyword parameters
7 GDG
8 PROCEDURES: Instream, cataloged procedures
9 COND, SET,RESTART,SYMOBLIC and override parameters
10 Checking JCL errors and fixing the JCL syntax errors
11 Differences between JOBLIB, STEPLIB and JCLLIB
12 SPOOL options and Parameters

1 Introduction to VSAM, Cluster, CI and CA
2 Differences between ESDS,KSDS and RRDS
3 VSAM datasets: ESDS, KSDS, RRDS and LDS
4 IDCAMS utility: DEFINE, REPRO, ALTER, PRINT, DELETE, IMPORT, EXPORT and verify
5 * Alternate index, Build index and Path entry [ Recorded video ]
6 File Manager/File Aid

1 Intro to COBOL
2 How to write COBOL
3 COBOL Language rules
4 Level numbers (01 – 49, 66, 77, 88)
5 Data types in COBOL
6 Value clause, MOVE, OF clause, Reference modification, Redefines and Renames
7 *Editing picture clauses [Recorded video ]
8 Arithmetic verbs(ADD, SUBTRACT, MULTIPLE, DIVIDE and COMPUTE)
9 Compilation process and compiler options and Checking the errors
10 Relational operators
11 Logical operators
12 Conditional statements (IF and Evaluate)
13 Sign and class conditions
14 *String, Unstring and Inspect [Recorded video ]
15 Perform: Inline and Outline Perform
16 Next sentence and Continue verbs
17 Differences between STOP RUN, EXIT PROGRAM and GOBACK
18 File Handling in COBOL:
PS: Read, write, Update
KSDS: Read( Sequential, Random and Dynamic)
Write, Update and Delete
ESDS: Read, Write, update
19 *AIX handling in COBOL [ Recorded video ]
20 Sub programs
21 COMP types
22 Arrays/Occurs, Subscript, Index and Linear search and Binary search
23 Error handling/File Handling
24 Abends: S806, S0C4, SOC7, S013, S722 and etc…
25 Report generation – Assignment for participants

1 Intro to DB2
2 DB2 Architecture and components
3 DB2 Objects: System and User defined objects
4 Intro to SPUFI and QMF tool
5 Executing SQL queries in SPUFI
6 SQL Commands: CREATE, INSERT, UPDATE, GRANT and Revoke PRIMARY KEY, FOREIGN KEY and Referential integrity and On cascade
7 SELECT Command: [ Recorded video ]
o Selecting few columns
o Selecting all the rows
o Where Condition
o Between Operator
o Like operator
o In Operator
JOINS: [ Recorded video ]
• INNER JOIN
• LEFT OUTER JOIN
• RIGHT OUTER JOIN
• FULL OUTER JOIN
Subquery: [ Recorded video ]
• Correlated queries
• No Correlated queries
8 DCLGEN
9 COBOL+DB2 Programs( SELECT, INSERT, UPDATE and DELETE commands)
10 Pre- compilation process, Compile, Link-edit and Bind Plan & Run jcl
11 Null Handling
12 Varchar Handling
13 Cursor handling
14 COBOL + PS + DB2 program(s)
15 SQL error handling (-805, -811 , -204, -206, -803, -818 and etc..)
16 *Mini case study (COBOL + DB2 + PS) – [ Recorded video ] and Assignment to participants

1 Intro to CICS
2 Differences between Online Application and Batch Application
3 BMS Macros: DFHMSD, DFHMDI and DFHMDF
Maps/Screens creation( 5 Maps will be created during training)
4 Maps Compilation process
5 IBM supplied tables (PPT, PCT, RCT, FCT, DCT and etc..)
IBM supplied transactions (CEDA, CEMT, CECI, CEBR, CESN and CESF and etc..)
6 Intro to COBOL & CICS programs
7 Translator, Compile and Link edit
8 Non-Conversational Programs
9 Conversation programs
10 Pseudo conversation programs
11 Function keys handling in online application programs
12 Exception handling( Handle condition, No handle, Resp, ignore)
13 XCTL and LINK
14 File handling in online application program
15 * DB2 in Online application program[ Recorded video ]
16 *TSQ and TDQ [ Recorded video ]
17 *Paging logic [ Recorded video ]
18 Debugging process in CICS region