z/OS DFSORT: Getting Started
Previous topic |
Next topic
|
Contents
|
Contact z/OS
|
Library
|
PDF
Contents (exploded view)
z/OS DFSORT: Getting Started
SC23-6880-00
Note
Abstract for DFSORT Getting Started
Introduction
What is DFSORT?
DFSORT on the World Wide Web
DFSORT FTP site
Data sets, records and fields
Sorting data sets
Merging data sets
Copying data sets
Joining data sets
What else can you do with DFSORT?
Creating and running DFSORT jobs
Writing jobs
Summary of DFSORT control statements
Running jobs
Creating and using the sample data sets
Learning to write JCL and DFSORT control statements
Sorting, merging, and copying data sets
Sorting data sets
Sorting by multiple fields
Continuing a statement
Comment statements
JCL for sorting data sets directly
Merging data sets
Writing the MERGE control statement
JCL for merging data sets directly
VB data set considerations
Starting positions
Short control fields
Copying data sets
Specifying COPY on the SORT, MERGE, or OPTION statement
JCL for copying data sets directly
Including or omitting records
Writing the INCLUDE statement
Writing the OMIT statement
Allowable comparisons for INCLUDE and OMIT
Writing constants
Character strings
Hexadecimal strings
Decimal numbers
Numeric tests for INCLUDE and OMIT
Alphanumeric Tests for INCLUDE and OMIT
Substring search for INCLUDE and OMIT
VB data set considerations
Starting positions
Short control fields
Summary
Summing records
Writing the SUM statement
Suppressing records with duplicate control fields
Handling overflow
VB data set considerations
Starting positions
Short summary fields
Reformatting records with fixed fields
Reformatting records after sorting with BUILD or FIELDS
Reordering fields to reserve space
Inserting binary zeros
Inserting blanks
Inserting strings
Character strings
Hexadecimal strings
Setting up a basic report
Translating uppercase to lowercase, EBCDIC to ASCII, and more
Converting numeric fields to different formats
Editing numeric fields
Displaying data in hexadecimal
Displaying data as bits
Performing arithmetic with numeric fields and constants
Converting date fields
Performing arithmetic with date fields
Doing lookup and change
Left-justifying and right-justifying data
Left-squeezing and right-squeezing data
Reformatting records with OVERLAY
Extending records with OVERLAY
Reformatting records with FINDREP
Reformatting records with IFTHEN
Reformatting records before sorting
Using other statements with INREC
Preventing overflow when summing values
Inserting sequence numbers
VB data set considerations
RDW
Starting positions and columns
Variable data
Summary
Reformatting records with variable fields
Using %nnn, %nn and %n Parsed Fields with BUILD and OVERLAY
Using %nnn, %nn and %n Parsed Fields with IFTHEN
Where You Can Use %nnn, %nn and %n Fields in BUILD and OVERLAY
PARSE parameters
Creating multiple output data sets and reports
Creating multiple identical copies
Selecting and sampling by relative record number
Including, omitting, and saving discards
Reformatting
Repeating
Splitting
Creating reports: OUTFIL vs ICETOOL
Creating reports with OUTFIL
Data
Headers
Trailers and statistics
No data or carriage control characters
VB data set considerations for headers and trailers
Sections
Updating counts and totals in trailer with OUTFIL
Converting FB to VB
Converting VB to FB
Joining records
Calling DFSORT from a program
Passing control statements
Calling DFSORT from a COBOL program
Sorting records
Merging records
Sorting with COBOL FASTSRT
Calling DFSORT from a PL/I program
Overriding installation defaults
Specifying PARM parameters on a JCL EXEC statement
Specifying an OPTION control statement in DFSPARM
Using DFSORT efficiently
Be generous with main storage
Allow memory object sorting, Hipersorting and dataspace sorting
Use high–speed disks for work data sets
Eliminate unnecessary fields with INREC
Eliminate unnecessary records with INCLUDE or OMIT
Eliminate unnecessary records with STOPAFT and SKIPREC
Consolidate records with SUM
Create multiple output data sets with OUTFIL
Replace program logic with DFSORT control statements
Use FASTSRT with COBOL
Avoid options that might degrade performance
Learning to use ICETOOL
Using the ICETOOL utility
ICETOOL operators
Sample input data sets
Writing required JCL statements
ICETOOL comment and blank statements
Printing statistics for numeric fields
Continuing an operator statement
Statistics for VB data set record lengths
Creating identical sorted data sets
Creating different subsets of a sorted data set
Creating multiple unsorted data sets
Counting values in a range
Printing simple reports
Printing tailored reports
Using formatting items
Edit masks
Number of digits
Leading zeros
Edit patterns
No statistics
Division
Leading, floating and trailing characters
Printing sectioned reports
Printing how many times fields occur
Selecting records by field occurrences
Joining fields from different data sets
Matching records from different data sets
Sorting records between headers and trailers
Keeping or removing headers, trailers and relative records
Merging previously sorted data sets
Complete ICETOOL job and TOOLMSG output
Learning to use symbols
Defining and using symbols
Creating the SYMNAMES data set
Defining symbols for fields
Using symbols for fields in DFSORT statements
Using symbols for fields in ICETOOL operators
Defining and using symbols for constants
Creating the sample data sets
Descriptions of the sample data sets
Processing order of control statements
Accessibility
Using assistive technologies
Keyboard navigation of the user interface
z/OS information
Notices
Programming interface information
Trademarks
Copyright IBM Corporation 1990, 2014