Posted: Thu Feb 19, 2009 5:31 am Post subject: Questions on DFSort
I have one input file including fields Country, Company,Busniss Unit, EE serial No, Month, Salary. can I use ICE Tool to sort this file and generate the other 2 files as follows?
1. If Country is not blank, sort it by Country, Company,Business Unit, EE serial No and SUM the Salary; Then write the records to file A.
2. If Country is blank, sort it by Company, Business Unit, EE serial No, Month and SUM the Salary; Then write the records to file B.
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Thu Feb 19, 2009 11:07 am Post subject:
Please show an example of the records in the input file and what you expect for output. Give the RECFM and LRECL of the input file. Give the starting position, length and format of each field in the input file. _________________ 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
