Mainframe DFSORT/SYNCSORT

Want to get started with Mainframe SORT utility to enhance your ability with data and file processing? Do this course!

What you'll learn
How to use Mainframe SORT utility (DFSORT/SYNCSORT)
Understand data handling and manipulation using SORT
Reformatting data in Mainframe using SORT
Filtering data using SORT utility
Report creation using SORT utility

Description
What Will I Learn?

You will be learning basics of SORT utility and understanding it's usage. We will be giving you full details on all highly used SORT keywords that will help you to process file/data with ease. The course covers basics of SORT along with real data examples for each keyword. Along with this some frequently required data processing requirements are covered with examples.

How and where SORT knowledge will come in handy?

SORT knowledge does help in reducing efforts required with file/data manipulation. A number of data related actions such as sorting, filtering, manipulation, formatting, reformatting etc can be completed using SORT utility with minimal efforts.

As the SORT utility is fully developed, scope of it is very large. For a number of file/data requirement can be achieved with few lines of SORT statement instead of writing 1000 lines of COBOL code. Having knowledge of SORT will help you performing your daily tasks more efficiently.

By taking this course you will feel confident to use SORT utility and perform different data handling actions.

Course content is as follows

Overview of SORT Utility

SORT Basics

SORT Syntax

SORT Keywords

SORT FIELDS Keyword

MERGE FIELDS Keyword

Skipping Records (SKIPREC/STOPAFT)

INCLUDE Keyword

OMIT Keyword

INREC - BUILD/FIELDS

INREC - OVERLAY

INREC - FINDREP

INREC - IFTHEN

OUTREC - BUILD/FIELDS

OUTREC - OVERLAY

OUTREC - FINDREP

OUTREC - IFTHEN

JOIN KEYS

Arithmetic Operations using SORT

HEADER/TRAILER Keyword

Report creation using SORT

Transforming Data

VB/FB file conversion and VB File handling

Prerequisites?

Basic Mainframe knowledge

Basic JCL knowledge

Who this course is for
Mainframe Developers
Mainframe Tech Leads
Mainframe Architect