|
IBM Mainframes Course Contents
- Mainframe concepts
- Introduction to IBM Mainframes
- Why Mainframes
- TSO/ISPF
COBOL(Common Business Oriented Language)
- Introduction to COBOL
- COBOL Coding Sheet
- DATA Types & Variable Declaration
COBOL STATEMENTS
- DISPLAY
- ACCEPT
- MOVE
- ARITHMETIC (ADD/SUBTRACT/MULTIPLY/DIVIDE)
- STRINGS (STRING/UNSTRING/INSPECT)
- USAGE clause
- IF statement
- EVALUATE
- Inline PERFORM
- PERFORM WITH TEST BEFORE/AFTET
- GO TO
- COP
- COMPUTE
- RENAMES( level 66)
- REDEFINES
- Condition names (level 88)
- STOP RUN, GOBACK, EXIT, EXIT PROGRAM
FILE HANDLING
- File descriptions/definitions/types
- Coding INPUT-OUTPUT SECTION and FILE SECTION
- Implementation differences for SEQUENTIAL, INDEXED and RELATIVE FILES
- READ,WRITE,REWRITE,DELETE
- START
- > SORT
- MERGE
- FILE STATUS codes/meaning/Error Handling
- Realtime exercises will all the above file types
TABLE HANDLING
- Array declaration using OCCURS clause
- Coding arrays in programs
- INDEX and SUBSCRIPT
- SET command
- SEARCH & SEARCH ALL
JCL(Job Control Language)
- Introduction to Batch processing
- JCL fundamentals, JES2 & JES3
- JOB statement
- EXEC statement
- DD statement
- CLASS
- MSGCLASS
- NOTIFY
- TYPERUN
- REGION
- COND
- TIME
- PARM
- AMP
- RESTART
- DISP,SPACE,UNIT,DCB Parameters
- GDGs
- Referback
- DATA & DUMMY
- JOBLIB, STEPLIB & JCLLIB
- Instream data & data thru control cards
- PROCEDURES(Instream & Cataloged)
- Temporary Datasets
- Symbolic & Overriding Parameters
- IF – ELSE in JCL
- MAXCC checking
- JCL abends & Resolution
- Coding Realtime JCLs
JCL UTILITIES
- IEFBR14
- IEBGENER
- IDBCOPY
- IEBCOMPR
- IEBEDIT
- IEBUPDTE
- IEHLIST
- IEHPROGM
- IDCAMS
- SORT(advanced concepts with 15+ scenarios)
- MERGE
- ICETOOL
VSAM(Virtual Storage Access Method)
- Introduction to VSAM
- Types of VSAM Datasets-ESDS,KSDS,RRDS
- Control Interval/Control Area
- CI Split/CA Split
- Define VSAM files using IDCAMS
- IDCAMS-REPRO, PRINT, ALTER, DELETE
- Defining ALTERNATE INDEX
- Building Alternate Index
- DEFINE PATH
- Accessing VSAM files from COBOL
- VSAM Status codes/Meaning/Resolution
SQL(Structured Query Language)
- SQL basics
- SQL queries
- DDL(CREATE,ALTER,DELETE) statements
- DML(SELECT,INSERT,UPDATE,DELETE) statements
- DCL(GRANT, REVOKE)
- Aggregate functions(SUM,AVG,MIN,MAX)
- COUNT, DISTINCT
- COMMIT/ROLLBACK
- WHERE clause
- GROUP BY, HAVING, ORDER BY
- IN, LIKE, WITH CHCK
- NULL/NOT NULL/NOT NULL WITH DEFAULT
- JOINs(INNER,LEFT OUTER,RIGHT OUTER, FULL JOIN)
- UNION & UNION ALL
- VIEWS (updatable & non-updatable)
- SYNAONYMs/ALIASes
- Sub queries
- SPUFI & QMF tools
DB2 Application Programming
- RDBMS concepts
- Normalization
- DB2 concepts
- Locking & concurrency
- Embedding SQL in COBOL
- COBOL-DB2 Program preparation
- Precompile process
- Binding process & all parameters
- BIND- PLAN & PACKAGE
- Locking modes & ISOLATION
- Constraints
- CURSORS
- STATIC SQLs
- DYNAMIC SQLs
- PREPARE
- EXECUTE IMMEDIATE
- SQLCA
- SQL codes/Meaning/Resolution
- DB2 Table unloads
- Data transfer from VSAM to DB2
- Data transfer from DB2 to VSAM
- Coding COBOL-DB2 realtime Programs
CICS(Customer Information Control System)
- Introduction to Online systems & CICS
- Batch Vs Online systems
- CICS Kernal tables and Programs
- CICS transations
- Converational & Pseudo-conversational Programming
- ASKTIME,FORMATTIME,START,ATI,CANCEL
- BMS Macros(DFHMSD,DFHMDI,DFHDF)
- Developing Maps & Mapsets
- SEND/SEND MAP/RECEIVE/RECEIVE MAP
- ALL VSAM FILE OPERATIONS(
- COMMAREA
- EIB(Exec Interface Block)
- HANDLE CONDITION, HANDLE AID & RESP
- IGNORE CONDITION
- PUSH & POP
- GETMAIN,LOAD,RELEASE
- LINK, XCTL, RETURN
- TDQ and TSQ
- CEMT/CESN/CESF/CEDA Transactions
- CICS abends/Meaning/Resolution
- Coding Realtime CICS programs using COBOL,CICS,VSAM & DB2
Tools
- FILE-AID
- CHANGEMAN/ENDEVOR
- EXPEDITOR
- SPUFI/QMF
- SDF(Screen Design Facility)
- ABEND-AID
PROJECTS
- 2 LIVE PROJECTS(INSURANCE & FINANCE)
- In-depth analysis of all the following environments
- DEVELOPMENT PROJECTS
- ENHANCEMENT PROJECTS
- PRODUCTION SUPPORT/MAINTENANCE PROJECTS
- SDLC(software Development Life Cycle)
- BRD(Business Requirement Document)
- Tech Specs preparation
- Writing Test Cases
- Documentation
- QA activities
ADDITIONALS
- Resume preparation
- Career Guiding
- Communication skills(verbal & written)
- Soft skills
- Group discussion after finishing each module
|
