Course Description

Using DFSORT and ICETOOL

This course: course objectives; course outline;
Related curriculum; Topic list; Course list; Home page

Benefits

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

Audience

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

Prerequisites

A working understanding of JCL.

Related IBM Materials

This course is drawn from the IBM manuals; access to them in the classroom is desirable but not required: Access to this and other DFSORT publications is available for free on the internet at http://www.ibm.com/storage/dfsort .

SC26-7523 - DFSORT 

• 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
  
  

Exercises

There are 20 machine exercises comprising over 55 DFSORT and ICETOOL jobs..