| View previous topic :: View next topic |
| Author |
Message |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12369
Topics: 75
Location: San Jose
|
 Posted: Tue Nov 29, 2005 1:10 pm Post subject: Smart DFSORT Tricks |
 |
|
Smart DFSORT Tricks
| Code: |
o Find and extract values from different positions
o Extract and justify delimited fields
o Squeeze out blanks or other characters
o Add leading and trailing apostrophes
o Deconstruct and reconstruct CSV records
o Only include records with today's date
o Include records using relative dates
o Fields from different record types
o Create files with matching and non-matching records
o Split a file to n output files dynamically
o Five ways to split a data set
o Sum a number with a decimal point
o Check for a numeric string
o Change a C sign to an F sign in PD values
o Display the number of input or output records
o Display SMF, TOD and ETOD date and time in readable form
o Include or omit groups of records
o Sort groups of records
o Set RC=12 or RC=4 if file is empty, has more than n records, etc
o Delete all members of a PDS
o Keep dropped duplicate records (XSUM)
o Create DFSORT Symbols from COBOL COPYs
o Join fields from two files on a key
o Join fields from two files record-by-record
o VB to FB conversion
o FB to VB conversion
o Sort records between a header and trailer
o Keep the last n records
o Sample records
o Change all zeros in your records to spaces
o Insert date and time of run into records
o Change uppercase to lowercase or lowercase to uppercase
o RACF "SPECIAL" report with and without DFSORT symbols
o Multiple output records from some (but not all) input records
o Replace leading spaces with zeros
o Generate JCL to submit to the internal reader
o Totals by key and grand totals
o Omit data set names with Axxx. as the high level qualifier
o Dataset counts and space by high level qualifier
o Delete duplicate SMF records
o Sort ddmonyy dates
o Turn cache on for all volumes
o C/C++ calls to DFSORT and ICETOOL
o REXX calls to DFSORT and ICETOOL
o Pull records from a Master file
o Concurrent VSAM/non-VSAM load
|
can be found at
http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
 |
Phantom
Data Mgmt Moderator
Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet
|
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
