Posted: Tue Jun 03, 2003 9:36 am Post subject: Is it possible to extract only detail records from a report?
Hi,
Using SORT or other utility, is it possible to extract only detail records to an output file? I have a file in the following format and want to create an output file with only detail records. Please help.
prog01 county of panama date:02/06/2003
detail record description
person first name last name
pn age
somebody1 01 kr 30
somebody2 02 zz 28
somebody3 03 tr 19
*** end of report ***
Is it possible to extract only middle records (from somebody1 to somebody3) to an output file?
Thanks,
Maqbul _________________ MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Tue Jun 03, 2003 9:55 am Post subject:
Maqbul,
You say you want to extract "middle records" (from somebody1 to somebody3). How can they be identified as "middle records"? How do we know where the "middle records" start and end?
That is, how do you identifiy which are the "detail records"? What makes them "detail records" (something unique in the records? their position relative to something?)? Do you only have one group of header, detail and trailer records or more than one group? This kind of task involves pattern recognition. You need to tell us what the pattern is. _________________ 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
