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
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
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
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
Mainframe Developer Training Batch Size
Regular Batch ( Morning, Day time & Evening)
Seats Available : 6 (maximum)
Weekend Training Batch( Saturday, Sunday & Holidays)
Seats Available : 8 (maximum)
Fast Track batch
Seats Available : 7 (maximum)
Mainframe Developer Training Duration
Regular Classes( Morning, Day time & Evening)
Duration : 6 weeks
Weekend Training Classes( Saturday, Sunday & Holidays)
Duration : 8 Weeks
Fast Track Training Program( 3+ hours classes daily)
Duration : within 4 weeks
