The DFSORT ICETOOL is a data set reporting utility that provides a batch front-end for DFSORT. It is capable of performing complex sorting, copying, merging, reporting and analytical tasks using multiple data sets in a single job. It can be called from a program or executed directly in a batch job. ICETOOL provides a set of 'operators' that provides a wide variety of tasks.<br>This course shows how to effectively exploit the benefits offered by this utility.<br><br>This course is available 'on demand' (minimum 2 students) for public presentation and for one-company, on-site presentations.
Using DFSORT and ICETOOL
A good knowledge and understanding of JCL. This can be gained by attending the course z/OS JCL Workshop Part 1 - Foundation Skills.
- code jobs that invoke DFSORT
- code jobs that invoke ICETOOL
- exploit ICETOOL to optimise your batch applications
- use ICETOOL to produce listings
- exploit ICETOOL to analyse data
- exploit ICETOOL to invoke SORT, MERGE and JOINKEYS
- exploit symbols when invoking DFSORT and ICETOOL.
Inroduction to ICETOOL
What does ICETOOL do ?; ICETOOL job format; Operator statement syntax; Comment statements; Return Codes.DFSORT
Introduction; Data Facility/Sort; How Sort works; Sort phases; Control fields; Sort operation; Control statements; JCL requirements; Messages; Syntax; Sort fields specification; MERGE field specification; MODS specification; INCLUDE/OMIT specification; RECORD specification; OUTFIL specification; ALTSEQ specification; OUTREC specification; SUM specification; OPTION specification; Common format codes for control fields.ICETOOL Operators
Syntax, Function and Examples of ICETOOL Operators: COPY; COUNT; DATASORT; DEFAULTS; DISPLAY; MERGE; MODE; OCCUR; RANGE; RESIZE; SELECT; SORT; SPLICE; STATS; SUBSET; UNIQUE; VERIFY.Invoking ICETOOL
Invoking ICETOOL directly; JCL requirements; Return Codes; Messages; Invoking ICETOOL from a program; TOOLIN interface; Parameter list interface; Explanation of fields; Statement Area Address and Statement Area; Return Area Address and Return Area; Examples.Using Symbols for Fields and Constants
Field and Constant Symbols Overview; DFSORT Example; SYMNAMES DD statement; SYMNAMES statements; SYMNOUT DD statement; using symbols on DFSORT statements; using symbols on ICETOOL statements.
Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.
Find dates and prices
Online booking is currently not available for this course, to find out more please call us on 01753 898320 or email us at firstname.lastname@example.org to discuss how we can help.
Fully accredited to ensure we provide the highest possible standards in learning