Mainframe DFSORT/SYNCSORT

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