Mainframes
-
MAINFRAME BASICS and MVS
Introduction to MVS
Key concepts and Terminlogy
Characteristics features of MVS
Multi programming
Multi processing
Real and Auxiliary Storage
Spooling
Paging
Address Spaces
Swapping
Data Management overview(MVS Functions)
Types of Data and Dataset Organization
VSAM and Non-VSAM datasets organization
Label and Catalog
I/O Devices
Unit Record Devices
Magnetic Tape
DASD-Direct Access Storage Device
MVS Tools Overview
Interactive System Productivity Facility (ISPF)
Primary Options Menu
Command Overview
MVS System Concepts
Job Management Overview
VS COBOL-11
Introduction to COBOL
History of COBOL and introduction to VSCOBOL 11
Details of COBOL Coding sheet
Structure of COBOL program
Divisions of COBOL program
Explanation with Sample program
Working with Data
Hierarchical representation of data
COBOL data types
Elementary and Group data items
JUSTIFY
SIGN Clause
Display vs Computational Numeric Data
USAGE Clause
SYNC Clause
Figurative Constants
RENAMES
REDEFINES
CONDITION NAMES
Program Structure
Programming style
Sections and Procedures
EXIT
Program Control
Types of statements
Arthimetic Verbs
Decision Making
Iterations
Trapping Run Time Errors
Exception handling
Table Handling
File Sorting
Sorting(Internal,external,bubble,shuttle sorts)
Input and output procedures
Merge
File Handling
File processing Overview
Types of files
Open and Close
The Write VERB
A Direct READ
The START Verb
The Delete Verb
Writing New Records
Sub Programming
The use of embedded and external subprograms
COPY statement
CALL
The Linkage Section
STATIC and DYNAMIC CALL
CALL BY CONTENT and CALL BY REFERENCE
EXIT Program and Go back
String Functions
STRING
UNSTRING
INSPECT
REFERENCE MODIFICATION
Job Control Language(JCL)
Introduction
Key parameters in JCL
Job statement
POSITIONAL PARAMETERS
KEYWORD PARAMETERS
Exec statement
POSITIONAL PARAMETERS
KEYWORD PARAMETERS
DD statement
POSITIONAL PARAMETERS
KEYWORD PARAMETERS
Special DD statements
TEMPORARY DATASETS
BACKWARD REFERENCES
SYSOUT
SYSUDUMP
SYSADUMP
Other JCL statements
COMMENTS STATEMENTS
DELIMETER STATEMENTS
NULL STATEMENT
Procedurs
PROC and PEND statement
SYMBOLIC parameters
PROC statement
PEND statement
Invoking Procedure
Generation Data Groups(GDG)
Introduction
Creation of GDG
Altering GDG definition
Deleting GDG
IBM JCL Utilities
Control Job Processing
IF the ELSE
MAXCC,LASTCC
DO..END
CANCEL
Sort
Internal Sort
External Sort
Explanation with Real time scenarios
OMIT,INCLUDE
INREC,OURREC
SKIPREC,STOPAFT
VIRTUAL STORAGE ACCESS METHOD(VSAM)
Introduction
Basic concepts of VSAM
Advantages of VSAM
CI,CA and splits
VSAM DATASETS
KSDS,RBS
ESDS
RRDS,RRN
LDS
Internal organisation of VSAM
VSAM Dataset Allocation
Dataset components
Parameters used for defining culsters
Alternate Index Allocation
Access Methods Services
Define VSAM/Generation Dataset Groups
Define ALTERNATEINDEX
BLDINDEX
Define PATH
Other IDCAMS COMMANDS
LISTCAT
ALTER
VERIFY
REPRO
MODAL
FILE-STATUS CODES
DATABASE 2(DB2)
Introduction to RDBMS
Overview of DB2
DB2 Objects
SQL
DB2 Application Development Overview
EMBEDDED SQL
DATA TYPED of DB2
JOINS
INNER and OUTER JOIN
LEFT and RIGHT JOIN
DB2 PRECOMPILATION PROCESS
DBRM
BIND
PACKAGE
PLAN
HOST VARIBALES
NULL INDICATORS
SQLCA
CURSOR
USE of CURSOR
WITH HOLD OPTION
DEADLOCK
LOCKS and LATCH
MODES OF LOCKS
SHARED
EXCLUSIVE
RELEASE OPTION
ISOLATION LEVELS
DB2 TOOLS
SPUFI
QMF
DCLGEN
DB2 UTILITIES