Smart DFSORT Tricks

View a PDF version of SORTTRCK (193KB)

List of tricks

• Introduction: Details of functions used in tricks
• Introduction: PTF level of functions needed for tricks
• Sort detail records between headers and trailers
• Add comma at end of all records except the last
• Keep or remove the first and/or last records
• Keep or remove specific relative records
• Replace or remove strings anywhere in a file
• Change all zeros in your records to spaces
• Display the number of input or output records
• Select n values for each key
• Include or omit groups of records
• Sort groups of records
• Combine multiple records into one record
• Report on GDG base limits
• Copy GDGs created today
• Copy GDG records in first in, first out order
• Create files with matching and non-matching records
• Join fields from two files on a key
• Join records on a key with missing fields
• Join fields from two files record-by-record
• Keep dropped duplicate records (XSUM)
• Split a file to n output files dynamically
• Five ways to split a data set
• Set RC=12 or RC=4 if file is empty, has more than n records, etc
• Find and extract values from different positions
• Sum a number with a decimal point
• Check for a numeric string
• VB to FB conversion
• FB to VB conversion
• Extract and justify delimited fields
• Squeeze out blanks or other characters
• Add leading and trailing apostrophes
• Deconstruct and reconstruct CSV records
• Only include records with today's date
• Include records using relative dates
• Fields from different record types
• Change a C sign to an F sign in PD values
• Display SMF, TOD and ETOD date and time in readable form
• Delete all members of a PDS
• Create DFSORT Symbols from COBOL Copybook
• Sample records
• Insert date and time of run into records
• Change uppercase to lowercase or lowercase to uppercase
• RACF "SPECIAL" report with and without DFSORT symbols
• Multiple output records from some (but not all) input records
• Replace leading spaces with zeros
• Generate JCL to submit to the internal reader
• Totals by key and grand totals
• Omit data set names with Axxx. as the high level qualifier
• Dataset counts and space by high level qualifier
• Delete duplicate SMF records
• Sort ddmonyy dates
• Turn cache on for all volumes
• C/C++ calls to DFSORT and ICETOOL
• REXX calls to DFSORT and ICETOOL
• Concurrent VSAM/non-VSAM load
• DCOLLECT conversion reports