About this course

Course code TPTI
Duration 2 Days

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.

Prerequisites

A good knowledge and understanding of JCL. This can be gained by attending the course z/OS JCL Workshop Part 1 - Foundation Skills.

Delegates will learn how to

  • 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.

Outline

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.

2 Days

Duration
Delivery Method

Delivery method

Classroom

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 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.