SYNCSORT In-Depth

Duration:   3 days

Participants:   Programmers with experience programming on a mainframe or others with a strong understanding of mainframe data storage.

Objectives:   Upon successful completion of this course you will be able to: -  Use Syncsort to sort or merge FB and VB mainframe datasets. -  Use Syncsort to eliminate undesired records, and to change the order and width of columns. -  Use Syncsort as a copy program. -  Use Syncsort to create sophisticated reports with headers/trailers, subtotals, grand totals, rearranged columns, etc. -  Write efficient sorts.

Overview:   SyncSort is more than just a sorting program. This course gives IT professionals the ability to use the many features of SyncSort for z/OS, a powerful utility that is often used to create robust reports and create customized data files, without coding an application program. In addition to learning the SORT and MERGE features you will also learn the many report enhancing and data file customization features as well as other SyncSort time-saving options.

Prerequisites:   Working knowledge of TSO/ISPF and basic JCL.

Format:   Lecture and discussion with hands-on exercises.

Topic Outline:   -  Basic JCL for SYNCSORT -  SYNCSORT Control Cards         SORT/MERGE         INCLUDE/OMIT         INREC/OUTREC         RECORD         SUM/XSUM         MODS/OUTFIL         ALTSEQ (Alternate Collating Sequences) -  Advanced JCL for SYNCSORT         EXEC parms, including MAXSORT, PARASORT, DYNALLOC, etc.         Calculating SORTWKXX sizes         $ORTPARM         Output DDs         Troubleshooting techniques and error messages -  SORT WRITER Report Facility         Headers, trailers         Control breaks         Totaling -  Creating Sophisticated Reports         Dates, time, page numbers         Subtotals/totals         Headers/trailers -  Variable Block Records with SYNCSORT -  Advanced and New Features         DB2 Query support         EXIT routines         SYNCTOOL         HISTOGRM         Tape Sort         Value-added products -  Performance Considerations         EXEC Parms         DD statements and work areas disk space         Control statement issues         CORE         Incore Sort         Checkpoint/nested         Sort concepts and how to write more efficient sorts         SORT vs MERGE

Course List       Site Map       Home