Using DFSORT and ICETOOL


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.
This course shows how to effectively exploit the benefits offered by this utility.

This course is available 'on demand' (minimum 2 students) for public presentation and for one-company, on-site presentations.

Objectives

On successful completion of this course you will be able 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.

Who Should Attend

Programmers, Operations Analysts, Operators and Systems Programmers

Prerequisites

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

Duration

2 days

Fee (per attendee)

£900 (ex VAT)

Course Code

TI

Contents

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.


© RSM Technology 2017