Mainframe DFSORT/SYNCSORT

Name: Mainframe DFSORT/SYNCSORT
Rating: 3.9 (23 reviews)

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

Created byLTS Tech Solutions LTD

Last updated 1/2022

English

English [Auto],

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

4 sections • 13 lectures • 1h 58m total length

Intro0:18
Begin your journey into mainframe dfsort and syncsort with this introductory lecture. Establish a foundation for understanding their core sorting tools.
Introduction to course2:00
Explore mainframe DFSORT and SYNCSORT utilities, learn how to define sort steps, and apply keywords to manipulate data and generate organized files.

SORT Basics and Syntax15:28
Explore the basics of mainframe sort with dfsort/syncsort, including syntax and actions like copy, merge, and reformat. Understand input and output keywords such as sort in, sort out, and include.
Basic SORT Keywords5:03
Learn the basic dfsort/syncsort keywords, including sort, include, indirect, rec, overlay, and outfil, and apply them to sort, reformat data, and manage headers, trailers, and conditional processing.

Sorting Data5:15
Copy data to an output file with a simple copy statement, then sort by multiple fields in ascending or descending order. Understand how alphanumeric and numeric values drive the sort.
Skipping and Merging data6:15
Explore skipping and stopping after records, sorting by selected fields, and merging pre-sorted files, with copying and processing specified data ranges in mainframe dfsort/syncsort.
INCLUDE and OMIT Keyword9:33
Apply include and omit keywords in mainframe dfsort/syncsort to process records meeting include conditions in the first two positions, using quotes for character values and combining multiple criteria.
INREC Keyword20:44
Explore the INREC keyword in mainframe dfsort/syncsort to reformat input data, using build or, find, grep, if then, and overlay for column manipulation, constant insertion, and conditional processing.
INREC IFTHEN Keyword17:49
Explore how to use the inrec ifthen keyword with f10 in dfsort to apply multiple conditional actions, copy or overlay data, and hardcode values based on first two characters.
OUTREC Keyword14:05
Explore the outrec keyword in dfsort/syncsort to copy data, reformat records, and move fields using overlay and sequence numbers; learn how sorting, if-then logic, and start-pushing shape the output.
OUTFIL Keyword4:21
Learn how to use the outfil keyword to split a single input into multiple named files with specific formatting and include conditions.

Joining files using SORT (JOINKEYS)12:40
Learn to join two files with join keys, producing match, F1 only, and F2 only outputs, using F1 and F2 as inputs and sorting as needed.
Arithmetic Operations using SORT5:18
learn arithmetic operations in mainframe sort (dfsort/syncsort): multiply, add, subtract, divide, and average on numeric fields, with output file formatting in m11, six-length, and preserved zeros.

Requirements

Basic understanding of Mainframes and JCL

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

Mainframe DFSORT/SYNCSORT

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 2min

SORT basic syntax and keywords2 lectures • 21min

Sort utility operations - Part 17 lectures • 1hr 18min

Sort utility operations - Part 22 lectures • 18min

Requirements

Description

Who this course is for: