Courses


Main Frames

Course : Main Frames Duration : 45 Hrs
Course Content : MAINFRAME BASICS and MVS
Introduction to MVS
Key concepts and Terminlogy
Characteristics features of MVS
  • Multi programming
  • Multi processing
  • Real and Auxillary 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
  • Struvture 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

copyright © 2010 eworldclasses.com All Rights Reserved