Канал: Mainframe Made Easy

IMS DB Programming & CICS Programming Training

IMS DB Programming & CICS Programming Training

Upcoming Ez Learn Trainings as of 5th June

Upcoming Ez Learn Trainings as of 5th June

EBCDIC Char Set

EBCDIC Char Set

COBOL DB2 CICS Compilation Procedure

COBOL DB2 CICS Compilation Procedure

How to use KSDS in CICS Region

How to use KSDS in CICS Region

CEDF - Debugging

CEDF - Debugging

FSET Modified Data Tag & CICS Common Abend codes

FSET Modified Data Tag & CICS Common Abend codes

Basic Mapping Support (BMS)

Basic Mapping Support (BMS)

LINK & Dynamic Cursor Positioning

LINK & Dynamic Cursor Positioning

CICS Pseudo Conversation Program Preparation

CICS Pseudo Conversation Program Preparation

Basic CICS Program (Non Conversational)

Basic CICS Program (Non Conversational)

CICS Fundamental Concepts

CICS Fundamental Concepts

Discussion on Abends & SQL Codes

Discussion on Abends & SQL Codes

DB2 Cursors in detail

DB2 Cursors in detail

COBOL DB2 Debugging & SQL Codes Discussion

COBOL DB2 Debugging & SQL Codes Discussion

COBOL DB2 Program Preparation

COBOL DB2 Program Preparation

Advantages of Database over File System

Advantages of Database over File System

SQL Subqueries

SQL Subqueries

SQL Views

SQL Views

SQL Joins

SQL Joins

SQL Foreign Keys Concepts

SQL Foreign Keys Concepts

SQL Using SPUFI

SQL Using SPUFI

SQL SELECT and its Clauses

SQL SELECT and its Clauses

SQL Create and Maintain Table

SQL Create and Maintain Table

SQL Basics Introduction

SQL Basics Introduction

COBOL REPORT WRITING CONCEPTS - INTRODUCTION

COBOL REPORT WRITING CONCEPTS - INTRODUCTION

COBOL INTERVIEW QUESTIOS PART 1

COBOL INTERVIEW QUESTIOS PART 1

COBOL Static Vs Dynamic Call

COBOL Static Vs Dynamic Call

COBOL USAGE COMPUTATIONAL CLAUSES (COMP & COMP-3)

COBOL USAGE COMPUTATIONAL CLAUSES (COMP & COMP-3)

ARRAYS INTRODUCTION AND NON INDEXED TABLE CREATION & USAGE

ARRAYS INTRODUCTION AND NON INDEXED TABLE CREATION & USAGE

Converting Numeric Formats (ZD to PD, ZD to BI and reverse)

Converting Numeric Formats (ZD to PD, ZD to BI and reverse)

Convert a Case (Lower to Upper / Vice versa) or format (EBCDIC to ASCII and Vice versa)

Convert a Case (Lower to Upper / Vice versa) or format (EBCDIC to ASCII and Vice versa)

Using System Date in INREC/OUTREC

Using System Date in INREC/OUTREC

Find and Replace a String

Find and Replace a String

JOINS KEYS - Full Outer Join

JOINS KEYS - Full Outer Join

JOINKEYS Write unmatched records only

JOINKEYS Write unmatched records only

JOINKEYS - Left and Right Outer Joins

JOINKEYS - Left and Right Outer Joins

SORT - Joinkeys - Matching 2 Input files based on a Key and extracting Matching records only

SORT - Joinkeys - Matching 2 Input files based on a Key and extracting Matching records only

DISP=SHR/OLD - Using same file as Input and Output

DISP=SHR/OLD - Using same file as Input and Output

ALTSEQ Parameter - Removing Junk data in a file

ALTSEQ Parameter - Removing Junk data in a file

MERGE FIELDS - Merging already pre-sorted records quickly

MERGE FIELDS - Merging already pre-sorted records quickly

SPLIT / STARTREC / ENDREC Usage in SORT

SPLIT / STARTREC / ENDREC Usage in SORT

Identifying Invalid Numeric Data in SORT using INCLUDE COND

Identifying Invalid Numeric Data in SORT using INCLUDE COND

EQUALS - Usage in SUM FIELDS to select first dup record

EQUALS - Usage in SUM FIELDS to select first dup record

OUTREC FIELDS - Continued - Reformatting Records

OUTREC FIELDS - Continued - Reformatting Records

Submitting Duplicate Jobs in Spool

Submitting Duplicate Jobs in Spool

DATASET Concatenation - How to combine PS datasets in Input ddname?

DATASET Concatenation - How to combine PS datasets in Input ddname?

Usage of XSUM - SORTXSUM ddname - Capturing Duplicate Records

Usage of XSUM - SORTXSUM ddname - Capturing Duplicate Records

OUTREC FIELDS Usage in detail - Reformatting Records

OUTREC FIELDS Usage in detail - Reformatting Records

EDITING a derived Numeric Column in INREC/OUTREC

EDITING a derived Numeric Column in INREC/OUTREC

SEQNUM - How to add Sequence Numbers with different initial and Incremental values in INREC/OUTREC

SEQNUM - How to add Sequence Numbers with different initial and Incremental values in INREC/OUTREC

ADD/SUB - 2 or more Numeric Columns

ADD/SUB - 2 or more Numeric Columns

Usage of ADD/SUB/MUL/DIV in INREC and OUTREC

Usage of ADD/SUB/MUL/DIV in INREC and OUTREC

Converting UFF (Unified Free Format) to ZD (Zoned Decimal) in INREC/OUTREC

Converting UFF (Unified Free Format) to ZD (Zoned Decimal) in INREC/OUTREC

INREC FIELDS - Selecting Specific Columns

INREC FIELDS - Selecting Specific Columns

EDITING Numeric Fields - Masking, Adding Signs and $ , - / @ etc

EDITING Numeric Fields - Masking, Adding Signs and $ , - / @ etc

How do we get Duplicate Records in Mainframe?

How do we get Duplicate Records in Mainframe?

OUTREC FIELDS - Selecting Specific columns we want

OUTREC FIELDS - Selecting Specific columns we want

OUTFIL FILES - Creating multiple Output files

OUTFIL FILES - Creating multiple Output files

SUM FIELDS - Adding Numeric Columns

SUM FIELDS - Adding Numeric Columns

SUM FIELDS=NONE - Removing Duplicate Records

SUM FIELDS=NONE - Removing Duplicate Records

Sort Parameters - OMIT COND - Filtering Records by giving exclude condition

Sort Parameters - OMIT COND - Filtering Records by giving exclude condition

Sort Parameters - Include Cond - Usage of SS (substring) data type to identify a string present

Sort Parameters - Include Cond - Usage of SS (substring) data type to identify a string present

Sort Parameters - INCLUDE COND - Compare 2 Numeric Columns

Sort Parameters - INCLUDE COND - Compare 2 Numeric Columns

Sort Parameters - Include cond - Giving multiple conditions

Sort Parameters - Include cond - Giving multiple conditions

SORT Parameters - INCLUDE COND - Filtering Records using one or more conditions

SORT Parameters - INCLUDE COND - Filtering Records using one or more conditions

SORT FIELDS with SKIPREC and STOPAFT

SORT FIELDS with SKIPREC and STOPAFT

Sort fields - Sequencing on one or more columns

Sort fields - Sequencing on one or more columns

SORT FIELDS - Sequencing Data on one or more columns

SORT FIELDS - Sequencing Data on one or more columns

How Sort Program works - Sequence of control cards execution by System

How Sort Program works - Sequence of control cards execution by System

DFSORT / SYNCSORT Definition Explained

DFSORT / SYNCSORT Definition Explained

Debugging - IEBGENER Multiple Steps

Debugging - IEBGENER Multiple Steps

Debugging - IEBGENER - Single Step JCL

Debugging - IEBGENER - Single Step JCL

Temporary files in JCL - Explained thru IEBGENER

Temporary files in JCL - Explained thru IEBGENER

Swapping 2 PS files thru IEBEGENR - JCL Demo

Swapping 2 PS files thru IEBEGENR - JCL Demo

PS TO PS Swapping Logic Explained thru IEBGENER

PS TO PS Swapping Logic Explained thru IEBGENER

IEBGENER - PDS(Member) to PS Copy

IEBGENER - PDS(Member) to PS Copy

IEBGENER - Using DISP=SHR/OLD/MOD in Output PS file

IEBGENER - Using DISP=SHR/OLD/MOD in Output PS file

IEBGENER - JCL explaining PS to PS file copy

IEBGENER - JCL explaining PS to PS file copy

IBM UTILITY PROGRAM - IEBGENER Explanation

IBM UTILITY PROGRAM - IEBGENER Explanation

IBM Utility Program - Debugging IEBCOPY JCL

IBM Utility Program - Debugging IEBCOPY JCL

IBM Utility Program - IEBCOPY (JCL explaining copying selective members from one PDS to other)

IBM Utility Program - IEBCOPY (JCL explaining copying selective members from one PDS to other)

IBM Utility Program - IEBCOPY (JCL explaining copying all members from one PDS to other)

IBM Utility Program - IEBCOPY (JCL explaining copying all members from one PDS to other)

IBM Utility Program - IEBCOPY (To take backup of a PDS) - Explanation

IBM Utility Program - IEBCOPY (To take backup of a PDS) - Explanation

JES3 Job Entry Subsystem

JES3 Job Entry Subsystem

IEFBR14 JCL Errors Debugging

IEFBR14 JCL Errors Debugging

IEFBR14 Deleting all GDG versions

IEFBR14 Deleting all GDG versions

IEFBR14 Deleting one or more PS files

IEFBR14 Deleting one or more PS files

IEFBR14 Creating one or more PS/PDS files

IEFBR14 Creating one or more PS/PDS files

IEFBR14 Sample JCL Explained

IEFBR14 Sample JCL Explained

IBM Utility Program IEFBR14 - Create/Delete PS/PDS/GDG Versions

IBM Utility Program IEFBR14 - Create/Delete PS/PDS/GDG Versions

TSO ISPF - How to use Multiple Screens in a Single Session?

TSO ISPF - How to use Multiple Screens in a Single Session?

TSO ISPF - TSO Reconnection Option - How to logon when it says already logged on?

TSO ISPF - TSO Reconnection Option - How to logon when it says already logged on?

TSO ISPF - How to calculate Space requirements in TRK/CYL?

TSO ISPF - How to calculate Space requirements in TRK/CYL?

TSO ISPF - Keyboard usage / Scroll Options

TSO ISPF - Keyboard usage / Scroll Options

TSO ISPF - Option 3.14 - Searching a String in PDS Members

TSO ISPF - Option 3.14 - Searching a String in PDS Members

TSO ISPF - Option 3.13 - Comparing 2 PS files with Processing Options

TSO ISPF - Option 3.13 - Comparing 2 PS files with Processing Options

TSO ISPF - Option 3.4 - Creating PDS Members

TSO ISPF - Option 3.4 - Creating PDS Members

TSO ISPF - Option 3.4 - Editing a PS file (Line Commands)

TSO ISPF - Option 3.4 - Editing a PS file (Line Commands)

TSO ISPF - Option 3.3 - PDS to PDS copy

TSO ISPF - Option 3.3 - PDS to PDS copy

TSO ISPF - Option 3.3 - PS to PS file copy

TSO ISPF - Option 3.3 - PS to PS file copy

TSO ISPF - Option 3.2 - Rename/Delete/Info of a PS file

TSO ISPF - Option 3.2 - Rename/Delete/Info of a PS file

TSO-ISPF - Option 3.2 - Allocate a PS dataset

TSO-ISPF - Option 3.2 - Allocate a PS dataset

TSO-ISPF - Option 3 2 - Allocate PDS dataset

TSO-ISPF - Option 3 2 - Allocate PDS dataset

IMS DB Advanced Interview Questions

IMS DB Advanced Interview Questions

IMS DB Interview Question Part 2

IMS DB Interview Question Part 2

IMS DB Interview Questions Part 1

IMS DB Interview Questions Part 1

COBOL Figurative Constants

COBOL Figurative Constants

COBOL Arithmetic Expression

COBOL Arithmetic Expression

COBOL Accept Display Commands

COBOL Accept Display Commands

Db2 Programming II

Db2 Programming II

DB2 Programming I

DB2 Programming I

VSAM & AIX

VSAM & AIX

JCL Revision 1

JCL Revision 1

JCL Revision 2

JCL Revision 2

DB2 Pre-compilation Procedure

DB2 Pre-compilation Procedure

IMS DB Revision 2

IMS DB Revision 2

IMS DB Revision 1

IMS DB Revision 1

IMS DB - Exercises on various calls

IMS DB - Exercises on various calls

IMS DB - Discussion on Get Next (GN) and Insert (ISRT) calls

IMS DB - Discussion on Get Next (GN) and Insert (ISRT) calls

IMS DB Demo Part 2

IMS DB Demo Part 2

IMS DB Demo Part 1

IMS DB Demo Part 1