View All Questions
Ask a New Question
Posted by Guest - Dfsort Header Record :|
I am trying to use DFSORT to merge several files into one but retain only one of header records.
I have 6 fixed length flat files, each with the same format:
I want to merge the files but only retain one header rec.
How do I achieve this?
i would use icetool as this gives you alot more flexibility especially when saving duplicates, etc. Off the top I don't remember all the parms but I know it has alot of options for doing this type of thing. If you have dfsort then you have icetool also at your shop.
Frank Yaeger Says:
How you would use DFSORT to do this depends on exactly what you're trying to do.
Please 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.
Can the header records be identified in some way (e.g. HDR in positions 1-3) or can they only be identified as the first record of each file?
Do you really want to MERGE the files (MERGE implies that the records in each file are already in sorted order) or do you just want to append them or what?
Frank Yaeger - DFSORT Development Team (IBM) - firstname.lastname@example.org
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT/MVS is on the Web at www.ibm.com/storage/dfsort
Add your reply below ...
This site allows you to ask questions and get answers from various posters. You may also answer any posts if you feel like you have input to give.
Feel free to ask for help with any new question you wish, but most of the questions here are tech related. You will find many questions and answers
related to your Ipod or Ipod Nano, Itunes, audio and video converting, spyware or adware cleanup, pc or other computer questions, and even mainframe
questions. Although these are the tech questions most often asked, you will find help on almost any computer or software related subject. Feel free to
go to the main menu and review the posts already present, or feel free to ask your own question. (Some questions will be closed once the moderator
feels they are sufficiently answered and that no other input is needed).
See All Tips Iphone Apps