Using DFSORT and ICETOOL

Course Number:  720-TF
Recommended Duration: 3 Days

Intended Audience
Experienced programmers and analysts who need a solid, in-depth exploration of DFSORT and ICETOOL capabilities.

Objectives
Students who complete this course will be able to code JCL and DFSORT and ICETOOL control statements to utilize the power of these utilties. This includes using these utilities instead of tedious programming languages to create reports (with up to three levels of control breaks), XML files, and HTML files from flat files, VSAM files, members of PDS or PDSE or files in the Hierarchical File System (HFS).

Prerequisites
A working understanding of JCL is suggested.

Topics

• DFSORT control statements: INCLUDE, OMIT, INREC, OUTREC, SORT, OUTFIL, OPTION, SUM, RECORD, MERGE

• ICETOOL operators: COPY, COUNT, DEFAULTS, MODE, RANGE, SORT, STATS, UNIQUE, VERIFY, DISPLAY, OCCUR, SUBSET, SELECT, SPLICE

• Supported data types

• Synbolic names, user-defined and DFSORT-provided

• Dates and times; relative dates; dates with two-digit years

• The Century Window

• The Hierarchical File System (HFS)

• DFSORT and HFS files

• Report terminology

• Markup languages

• Introduction to XML

• DFSORT and XML

• Introduction to HTML

• DFSORT and HTML

• Collation sequences and locales in DFSORT

• The ICEGENER utility