Mainframe DFSORT/SYNCSORT – Free Udemy Courses

What Will I Learn?

You will be learning the basics of SORT utility and understanding its usage. We will be giving you full details on all highly used SORT keywords that will help you to process files/data with ease. The course covers the 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. Several data-related actions such as sorting, filtering, manipulation, formatting, reformatting, etc can be completed using the SORT utility with minimal effort.

As the SORT utility is fully developed, its scope of it is very large. Several file/data requirements can be achieved with a few lines of SORT statement instead of writing 1000 lines of COBOL code. Knowing SORT will help you perform 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 – FIND REPS
• INREC – IF THEN
• OUTREACH – BUILD/FIELDS
• OUTREACH – OVERLAY
• OUTREACH – FIND REPS
• OUTREACH – IF THEN
• 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