xTechnology Trainings

IBM Mainframe Concepts
- Architecture
  30 min
- Input/output Devices
  30 min
JCL Course Syllabus
- Introduction TO JCL
  30 min
Job statement
- Class
  30 min
- PRTY
  30 min
- MSGCLASS
  30 min
- MSGLEVEL
  30 min
- TYPRUN
  30 min
JOBLIB/STEPLIB
- JOBLIB
  30 min
- STEPLIB
  30 min
EXEC STATEMENT
- PARM
  30 min
- ACCT
  30 min
- ADDRSPC
  30 min
- DPRTY
  30 min
- PERFORM
  30 min
- RD
  30 min
common parameter in both job and exec statements
- REGION
  30 min
- COND
  30 min
- TIME
  30 min
DD STATEMENT
- DSN
  30 min
- Temporary Datasets
  30 min
- DISP
  30 min
- UNIT
  30 min
- VOL
  30 min
- SPACE
  30 min
- DCB
  30 min
Special dd statements
- DUMMY
  30 min
- Concatenating Data sets
  30 min
- Passing data to COBOL program using – SYSIN DD *
  30 min
- SYSOUT
  30 min
- Sysudump
  30 min
Instream and Cataloged procedures
- Introduction
  30 min
- Instream Procedure
  30 min
- Cataloged procedure
  30 min
- Modify statements in a procedure
  30 min
- Symbolic parameters
  30 min
Generation Data Groups (GDG)
- Introduction
  30 min
- Creation of GDG
  30 min
- Using GDG
  30 min
- Altering gdg definition
  30 min
- Deleting gdg
  30 min
Control Job Processing (IF THEN ELSE) in JCL
- Introduction
  30 min
- Example JCL
  30 min
Restarting and checkpoint in JCL
- Introduction
  30 min
- Example JCL
  30 min
Introduction TO VSAM
- Virtual Storage
  30 min
- Virtual Storage Access Method
  30 min
- Advantages and Disadvantages of VSAM
  30 min
- Logical Record
  30 min
- Physical Record
  30 min
- Control Interval
  30 min
- Control Interval Splits
  30 min
- Spanned Records
  30 min
VSAM TYPES
- Key Sequential Data Set
  30 min
- Entry Sequential Data Set
  30 min
- Relative Record Data Set
  30 min
- Linear Data set
  30 min
Access method services
- IDCAMS
  30 min
- Using IDCAMS
  30 min
- JCL for IDCAMS
  30 min
- Basic IDCAMS commands
  30 min
- Define command
  30 min
- REPRO
  30 min
- Reuse
  30 min
- Replace
  30 min
- Import and export
  30 min
- Verify
  30 min
- Print
  30 min
- Listcat
  30 min
- Spanned
  30 min
- ALTER
  30 min
- DELETE
  30 min
- Modal commands
  30 min
ALTERNATE INDEXES
- Alternate Indexes
  30 min
- Alternate index PATHS
  30 min
- AIX Organization
  30 min
- RELATE
  30 min
- UPGRADE
  30 min
- KEYS
  30 min
- R
  30 min
- Define ecordsizepath
  30 min
- PATH ENTRY
  30 min
- UPDATE
  30 min
VSAM IN COBOL PROGRAM
- Using VSAM with COBOL
  30 min
- START Statement
  30 min
- WRITE
  30 min
- REWRITE
  30 min
- CLOSE
  30 min
- FILE STATUS
  30 min
Introduction to COBOL
- Introduction to COBOL
  30 min
A First COBOL Program
- Writing Structured COBOL
  30 min
- Conditional Statements
  30 min
- The GO TO Statement
  30 min
Data Structures and Storage
- Declaring Variables
  30 min
- Using Data Structures
  30 min
- Formatting Output
  30 min
- 77 and 88 Levels
  30 min
- Declaring and Using Arrays
  30 min
- Loan Schedule Report
  30 min
File I/O
- File/Record Descriptions
  30 min
- Physical/Logical File Descriptions
  30 min
- Reading Records from a File
  30 min
- Sequentially Writing Records
  30 min
- Indexed File I/O
  30 min
- Printing Reports
  30 min
COBOL Techniques
- Converting to Uppercase
  30 min
- Copy Files
  30 min
- Selecting Records
  30 min
- Sorting & Reporting Data
  30 min
- Control Breaks/Summary Totals
  30 min
- Handling Dates
  30 min
VSAM IN COBOL PROGRAM
- Using VSAM with COBOL
  30 min
- START Statement
  30 min
- WRITE
  30 min
- REWRITE
  30 min
- CLOSE
  30 min
- FILE STATUS
  30 min
Introduction to DB2
- What is database and its basic types
  30 min
- Database models
  30 min
- Hierarchical
  30 min
- Network
  30 min
RDBMS
- Object Oriented
  30 min
- Discuss about storage group and volumes table spaces
  30 min
- Index spaces
  30 min
- Basic Information About
  30 min
- Table
  30 min
- Row
  30 min
- Column
  30 min
- Queries
  30 min
- View
  30 min
- Trigger
  30 min
- Synonyms
  30 min
- Alias
  30 min
- Discuss Physical Storage of DB2
  30 min
- DB2 objects
  30 min
- Buffer pools
  30 min
- Features of Database design and its types
  30 min
- Discuss the advantages of DB2 over VSAM
  30 min
- Discuss the features of data integrity and referential integrity
  30 min
Interaction with DB2
- Interaction with DB2 using TSO with SPUFI tool and QMF tool
  30 min
- Introduction to SQL for interacting with DB2
  30 min
- Introduction to COBOL-DB2 application program
  30 min
- Using run JCL we can pass the queries
  30 min
- With execute immediate
  30 min
- Using prepare and execute technique
  30 min
- Using dynamic SQL for running the queries
  30 min
- Discussing the compilation of COBOL-DB2 program
  30 min
- Facility of Error handling in DB2
  30 min
- Using DSNTIAR procedure approach
  30 min
- Using SQL codes
  30 min
- Discussing commit and rollback features
  30 min
- Introduction to CURSOR concept
  30 min
- Handling Null values in DB2
  30 min
- HANDLING VARCHARS
  30 min
- Locks facility
  30 min
- Error Handling
  30 min
- Error Handling – Introduction
  30 min
- SQLCA
  30 min
DSNTIAR
- WHENEVER
  30 min
- COMMIT
  30 min
- Rollback
  30 min
DB2 Utilities
- Data Consistency Utilities
  30 min
- CHECK Utility
  30 min
- REPAIR Utility
  30 min
- REPORT Utility
  30 min
- DIAGNOSE Utility
  30 min
- Backup and Recovery Utilities
  30 min
- COPY Utility
  30 min
- MERGECOPY Utility
  30 min
- QUIESCE Utility
  30 min
- RECOVER Utility
  30 min
- REBUILD Utility
  30 min
- REPORT RECOVERY
  30 min
- Data Organization Utilities
  30 min
- LOAD Utility
  30 min
- REORG Utility
  30 min
- Catalog Manipulation Utilities
  30 min
- CATMAINT Utility
  30 min
- MODIFY Utility
  30 min
- RUNSTATS Utility
  30 min
- STOSPACE Utility
  30 min
Miscellaneous
- DB2 Commands
  30 min
- Dynamic SQL – Introduction
  30 min
- Dynamic SQL – Types
  30 min
- When to use Dynamic SQL
  30 min
- Execute Immediate SQL
  30 min
- Non-select dynamic SQL
  30 min
- Parameter marker
  30 min
- Fixed-list select
  30 min
- Varying-list select SQL
  30 min
Stored Procedure
- Stored Procedure – Development
  30 min
- Creating Stored Procedures
  30 min
Managing Stored Procedures
- Executing a Stored Procedures
  30 min
INTRODUCTION TO CICS
- CICS
  30 min
- Batch Vs. Online
  30 min
- CICS Program Format
  30 min
- Task and Transaction
  30 min
- How to Initiate Transactions
  30 min
CICS CONCEPTS
- Multitasking
  30 min
- Multi-Threading
  30 min
- Quasi-Reentrancy
  30 min
- Conversational, Non-Conversational and pseudo conversational programming
  30 min
CICS RESOURCE DEFINITION
- PPT
  30 min
- PCT
  30 min
- FCT
  30 min
- TST
  30 min
- DCT
  30 min
- RCT
  30 min
MAPSETS, MAPS, MAP FIELDS
- Physical & Symbolic Maps
  30 min
FILE HANDLING IN CICS AND VSAM
- File control
  30 min
- Types of VSAM Files
  30 min
QUEUES
- TSQ
  30 min
- TDQ
  30 min
CICS REGION COMMANDS
- XCTL and LINK
  30 min
- GETMAIN and FREEMAIN
  30 min
RECOVERY AND RESTART
- Recovery and Restart
  30 min
- Facilities for CICS Recovery and Restart
  30 min
CICS EXCEPTION HANDLING
- Test and Debugging Commands
  30 min
Functions of EDF - COBOL-CICS-DB2
- General structure of CICS program
  30 min
- CICS provided facilities for Programming
  30 min
- How to work with DB2 databases
  30 min
- How to design, code and test a modular CICS program
  30 min
- How to compile a CICS program
  30 min
- Prerequisites for the execution of a CICS program
  30 min
- Execution
  30 min

Mainframe Developer Training

This content is protected, please login and enroll course to view this content!

Prev CICS

Next CICS Program Format