[thim-heading title=”Mainframe Developer Training ” clone_title=”” line=””]

JCL Course Syllabus

INTRODUCTION TO JCL

JOB STATEMENT

  • CLASS
  • PRTY
  • MSGCLASS
  • MSGLEVEL
  • TYPRUN

JOBLIB/STEPLIB

  • JOBLIB
  • STEPLIB

EXEC STATEMENT

  • PARM
  • ACCT
  • ADDRSPC
  • DPRTY
  • PERFORM
  • RD

COMMON PARAMETER IN BOTH JOB AND EXEC STATEMENTS

  • REGION
  • COND
  • TIME

DD STATEMENT

  • DSN
  • Temporary Datasets
  • DISP
  • UNIT
  • VOL
  • SPACE
  • DCB

SPECIAL DD STATEMENTS

  • DUMMY
  • Concatenating Data sets
  • Passing data to COBOL program using – SYSIN DD *
  • SYSOUT
  • SYSUDUMP
  • SYSADUMP

INSTREAM and CATALOGED PROCEDURES

  • Introduction
  • Instream Procedure
  • Cataloged procedure
  • Modify statements in a procedure
  • Symbolic parameters

Generation Data Groups (GDG)

  • INTRODUCTION
  • CREATION OF GDG
  • USING GDG
  • ALTERING GDG DEFINITION
  • DELETING GDG

Control Job Processing (IF THEN ELSE) in JCL

  • Introduction
  • Example JCL

Restarting and checkpoint in JCL

  • Introduction
  • Example JCL

VSAM Course Syllabus

INTRODUCTION TO VSAM

  • Virtual Storage
  • Virtual Storage Access Method
  • Advantages and Disadvantages of VSAM
  • Logical Record
  • Physical Record
  • Control Interval
  • Control Interval Splits
  • Spanned Records

VSAM TYPES

  • Key Sequential Data Set
  • Entry Sequential Data Set
  • Relative Record Data Set
  • Linear Data set

ACCESS METHOD SERVICES

  • IDCAMS
  • Using IDCAMS
  • Jcl for IDCAMS
  • Basic IDCAMS commands
  • Define command
  • REPRO
  • REUSE
  • REPLACE
  • IMPORT AND EXPORT
  • VERIFY
  • PRINT
  • LISTCAT
  • SPANNED
  • ALTER
  • DELETE
  • MODAL COMMANDS

ALTERNATE INDEXES

  • Alternate Indexes
  • Alternate index PATHS
  • AIX Organization
  • RELATE
  • UPGRADE
  • KEYS
  • RECORDSIZE
  • DEFINE PATH
  • PATH ENTRY
  • UPDATE

VSAM IN COBOL PROGRAM

  • Using VSAM with Cobol
  • START Statement
  • WRITE
  • REWRITE
  • CLOSE
  • FILE STATUS

COBOL Course Syllabus

Introduction to COBOL

  • Introduction to COBOL
  • A First COBOL Program
  • Writing Structured COBOL
  • Conditional Statements
  • The GO TO Statement

Data Structures and Storage

  • Declaring Variables
  • Using Data Structures
  • Formatting Output
  • 77 and 88 Levels
  • Declaring and Using Arrays
  • Loan Schedule Report

File I/O

  • File/Record Descriptions
  • Physical/Logical File Descriptions
  • Reading Records from a File
  • Sequentially Writing Records
  • Indexed File I/O
  • Printing Reports

COBOL Techniques

  • Converting to Uppercase
  • Copy Files
  • Selecting Records
  • Sorting & Reporting Data
  • Control Breaks/Summary Totals
  • Handling Dates

VSAM IN COBOL PROGRAM

  • Using VSAM with Cobol
  • START Statement
  • WRITE
  • REWRITE
  • CLOSE
  • FILE STATUS

DB2 Course Syllabus

Introduction to DB2

  • What is database and its basic types
  • Database models
    • Hierarchical
    • Network
    • RDBMS
    • Object Oriented
  • Discuss about storage group and volumes table spaces
  • Index spaces
  • Basic Information About
    • Table
    • Row
    • Column
    • Queries
    • View
    • Trigger
    • Synonyms
    • Alias
  • Discuss Physical Storage of DB2
    • DB2 objects
    • Buffer pools
  • Features of Database design and its types
  • Discuss the advantages of DB2 over VSAM
  • Discuss the features of data integrity and referential integrity

Interaction with DB2

  • Interaction with DB2 using TSO with SPUFI tool and QMF tool
  • Introduction to SQL for interacting with DB2
  • Introduction to COBOL-DB2 application program
    • Using run JCL we can pass the queries
    • With execute immediate
    • Using prepare and execute technique
    • Using dynamic SQL for running the queries
  • Discussing the compilation of COBOL-DB2 program
  • Facility of Error handling in DB2
    • Using DSNTIAR procedure approach
    • Using SQL codes
  • Discussing commit and rollback features
  • Introduction to CURSOR concept
  • Handling Null values in DB2
  • HANDLING VARCHARS
  • Locks facility
  • Error Handling
  • Error Handling – Introduction
  • SQLCA
  • DSNTIAR
  • WHENEVER
  • COMMIT
  • Rollback

DB2 Utilities

  • Data Consistency Utilities
  • CHECK Utility
  • REPAIR Utility
  • REPORT Utility
  • DIAGNOSE Utility
  • Backup and Recovery Utilities
  • COPY Utility
  • MERGECOPY Utility
  • QUIESCE Utility
  • RECOVER Utility
  • REBUILD Utility
  • REPORT RECOVERY
  • Data Organization Utilities
  • LOAD Utility
  • REORG Utility
  • Catalog Manipulation Utilities
  • CATMAINT Utility
  • MODIFY Utility
  • RUNSTATS Utility
  • STOSPACE Utility

Miscellaneous

  • DB2 Commands
  • Dynamic SQL – Introduction
  • Dynamic SQL – Types
  • When to use Dynamic SQL
  • Execute Immediate SQL
  • Non-select dynamic SQL
  • Parameter marker
  • Fixed-list select
  • Varying-list select SQL

Stored Procedure

  • Stored Procedure – Development
  • Creating Stored Procedures
  • Managing Stored Procedures
  • Executing a Stored Procedures

CICS Course Syllabus

INTRODUCTION TO CICS

  • CICS
  • Batch Vs. Online
  • CICS Program Format
  • Task and Transaction
  • How to Initiate Transactions

CICS CONCEPTS

  • Multitasking
  • Multi-Threading
  • Quasi-Reentrancy
  • Conversational , Non-Conversational and pseudo conversational programming

CICS RESOURCE DEFINITION

  • PPT
  • PCT
  • FCT
  • TST
  • DCT
  • RCT

MAPSETS, MAPS, MAP FIELDS

  • Physical & Symbolic Maps

FILE HANDLING IN CICS AND VSAM

  • File control
  • Types of VSAM Files

QUEUES

  • TSQ
  • TDQ

CICS REGION COMMANDS

  • XCTL and LINK
  • GETMAIN and FREEMAIN

RECOVERY AND RESTART

  • Recovery and Restart
  • Facilities for CICS Recovery and Restart

CICS EXCEPTION HANDLING

  • Test and Debugging Commands
  • Functions of EDF

COBOL-CICS-DB2

  • General structure of CICS program
  • CICS provided facilities for Programming
  • How to work with DB2 databases
  • How to design, code and test a modular CICS program
  • How to compile a CICS program?
  • Pre-requisites for the execution of a CICS program
  • Execution
QUICK ENQUIRY

We are glad that you preferred to contact us. Please fill our short form and one of our friendly team members will contact you back.

ExperiencedFresher

X
Quick Enquiry