• Architecture
• Input/output Devices

INTRODUCTION TO JCL

• CLASS
• PRTY
• MSGCLASS
• MSGLEVEL
• TYPRUN

• JOBLIB
• STEPLIB

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

• REGION
• COND
• TIME

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

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

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

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

• Introduction
• Example JCL

• Introduction
• Example JCL

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

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

• 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 index PATHS
• AIX Organization
• RELATE
• UPGRADE
• KEYS
• RECORDSIZE
• DEFINE PATH
• PATH ENTRY
• UPDATE

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

• Introduction to COBOL

• Writing Structured COBOL

• 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/Record Descriptions
• Physical/Logical File Descriptions
• Reading Records from a File
• Sequentially Writing Records
• Indexed File I/O
• Printing Reports

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

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

• What is database and its basic types
• Database models
• Hierarchical
• Network

• 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 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

• WHENEVER
• COMMIT
• Rollback

• 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

• 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 – Development
• Creating Stored Procedures

• Executing a Stored Procedures

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

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

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

• Physical & Symbolic Maps

• File control
• Types of VSAM Files

• TSQ
• TDQ

• XCTL and LINK
• GETMAIN and FREEMAIN

• Recovery and Restart
• Facilities for CICS Recovery and Restart

• Test and Debugging Commands

• 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