Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Mon Oct 20, 2003 10:35 am Post subject:
Rahul,
I'm sorry, but I can't really figure out what's wanted here or whether Kolusu's solution actually gives you what you want. You only showed one header record, one trailer record and one detail record, and you didn't show what you want for the output. Could you please show an example of more records in the header/trailer file and more records in the detail file, and what you want the output to look like. Once I understand what you want, I'll be able to tell you if it can be done with the SPLICE operator of DFSORT's ICETOOL. _________________ 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
Joined: 26 Nov 2002 Posts: 12366 Topics: 75 Location: San Jose
Posted: Mon Oct 20, 2003 1:26 pm Post subject:
Frank,
From my understanding of the question, Rahul has one header/footer file which contains 'n' different headers and footers but are unique.And he has another file which has just the detail records. The detail record has the ORG name and form name. For this detail record ORG name and form he needs to extract the header and footer and write it as a single file.
In brief the output file should have the header record for the ORG name and the form name , followed by all the detail records and then finally the corresponding footer record.
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Mon Oct 20, 2003 2:10 pm Post subject:
Kolusu,
Rahul said
Quote:
1) File 1 can have any number of header and footer. Output file involve only those header and footer..whose detail record is present.
2) Org(T44010) and Form name(DRCDR1) is unique for each header,footer & Detail record.
I take this to mean that the 'n' different headers/footers could match n different detail records and he wants ALL of the header/detail/footer records that matched, e.g. you could have header A, detail A, footer A, header D, detail D, footer D, etc. It seemed to me that your job gets only one header and footer.
But it's probably pointless to discuss our interpretations of what Rahul meant rather than have Rahul show us exactly what he wants with good examples of his input and output. _________________ 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
All times are GMT - 5 Hours Goto page Previous1, 2
Page 2 of 2
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