Can you post your question more clearly. It will help if you could post the input dataset and the desired output dataset. _________________ Regards,
Programmer
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Thu Feb 03, 2005 11:03 am Post subject:
mfuser9099,
If I understand you correctly, you just want to add up a column of PD values and show the result in the output data set. Let's assume your PD field is in positions 11-14. You could use this DFSORT job to get your PD total.
Note that you'll need z/OS DFSORT V1R5 PTF UQ95214 or DFSORT R14 PTF UQ95213 (Dec, 2004) to use TO=PD in TRAILER1. For complete details on all of the new DFSORT and ICETOOL functions in this PTF, see:
If you have DFSORT, but don't have the appropriate PTF installed, ask your System Programmer to install it (it's free).
Without the TO=PD support in the PTF, creating the PD total is more complicated, especially if it can be negative. You could use SUM to get the PD total and move it where you want it, but that would require a SORT rather than a COPY and you'd need to have a field in every record with the same value to SORT on. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
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
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
