MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Smart DFSORT Tricks

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> JCL/SORT
View previous topic :: View next topic  
Author Message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12354
Topics: 75
Location: San Jose

PostPosted: Tue Nov 29, 2005 1:10 pm    Post subject: Smart DFSORT Tricks Reply with quote

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 - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Phantom
Data Mgmt Moderator
Data Mgmt Moderator


Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet

PostPosted: Wed May 30, 2007 8:58 am    Post subject: Reply with quote

If you want to a Cartesian join of 2 datasets, then DFSORT SPLICE can come in handy.

Cartesian Join match using DFSORT Splice
http://www.mvsforums.com/helpboards/viewtopic.php?t=6271&highlight=cartesian


Thanks,
Phantom
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> JCL/SORT All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group