Posted: Fri Mar 09, 2012 2:00 pm Post subject: merging files
I WANT TO MERGE TWO FILES.LAYOUT OF TWO FILES IS SAME LY.
FOR EX. I/P FILE1 & FILE2 HAS 3 FIELD.
THE THIRD FIELD CONTAINS 2 BYTE ALPHANUMERIC SUPPOSE IN FILE1 IT IS 10 AND IN FILE2 IT IS 01.
THE TWO FILES ARE SORTED BASED ON FILED1 AND AFTER MERGING IS GOING TO BE DONE.
WHILE MERGING I WANT THE 3RD FIELD TO BE 11 INSTEAD OF 10 IN FILE1 AND 01 IN FILE2
Joined: 09 Aug 2008 Posts: 1631 Location: Mumbai, India
Posted: Fri Mar 09, 2012 3:31 pm Post subject:
1. TURN OFF YOUR CAPS LOCK.
2. You've posted in COBOL part of the Forum - so are you looking for a COBOL solution? As this can be easily written in a SORT step. (only if I correctly understood what you mean)
3. And before I, for one, attempt to answer, You need to do a good job explaining your requirement:
THE TWO FILES ARE SORTED BASED ON FILED1 AND AFTER MERGING IS GOING TO BE DONE. WHILE MERGING I WANT THE 3RD FIELD TO BE 11 INSTEAD OF 10 IN FILE1 AND 01 IN FILE2
what does bold text mean here?
Possibly show us an example of inputs and the expected output. _________________ Regards,
you have obviously not bothered to look at the document provided
by the link that I gave you to the JOINKEYS explanation in my previous post,
no one is going to cut and past and thus repeat what the manuals so ably explain. _________________ Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
Joined: 18 Feb 2006 Posts: 812 Location: San Jose, CA
Posted: Fri Mar 09, 2012 11:38 pm Post subject:
If you want detailed help, you need to give a detailed explanation of what you want to do. Your explanation is not clear.
Show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example. _________________ Frank Yaeger - DFSORT Development Team (IBM) - email@example.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://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