Banner Banner Banner Banner Banner Banner Banner Banner Banner

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