Joined: 26 Nov 2002 Posts: 12368 Topics: 75 Location: San Jose
Posted: Thu Dec 15, 2011 11:31 am Post subject:
nbdtrjk1,
How do you recognize the start of the key? is it the first record of the Key(3,3) ?? _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Posted: Thu Jan 26, 2012 7:29 am Post subject: retaining previous values when putting out new detail line
Along the lines of retaining previous values, would it be possible to reformat a report into detail lines that contain a date value appended to the front of the detail line? Here is my example:
Code:
INPUT:
FRUIT INVENTORY PRODUCED ON: 01-25-12
APPLES 20
PEARS 15
ORANGES 35
FRUIT INVENTORY PRODUCED ON: 01-17-12
APPLES 27
PEARS 34
ORANGES 42
OUTPUT: (Date to be reformatted to YYMMDD for sorting purposes)
120125 APPLES 20
120125 PEARS 15
120125 ORANGES 35
120117 APPLES 27
120117 PEARS 34
120117 ORANGES 42
_________________ 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