Mainframe DFSORT/SYNCSORT

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

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.

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.

Course Content

  • Introduction –> 2 lectures • 2min.
  • SORT basic syntax and keywords –> 2 lectures • 21min.
  • Sort utility operations – Part 1 –> 7 lectures • 1hr 18min.
  • Sort utility operations – Part 2 –> 5 lectures • 44min.

Mainframe DFSORT/SYNCSORT

Requirements

  • Basic understanding of Mainframes and JCL.

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
Get Tutorial