I have a file of 100 charcters length with 3 types of records A,B,C (which is called a set) with header and trailer. The records were in the the order HDR,A,B,C,TRL. It doesn't always all consist 3 records types for a particular set. For every C record, A & B are must. For Every B record, A record is must. Single record type A doesn't exists.
Now the requirement is i have a field coloum in 10th -13th position of record type B, (suppose say country name). Based on the country name i need segregate the information all the A,B,C of the corresponding records into 2 files.The country name in the B records is always same if it is more than one record.
Uday,
Please provide RECFM for the input file?is it FB?
How is header record constructed? Looking at the sample data, it seems it has System date after HDR and some number (00000120 in this case). What is this number? Is it always same?
Looks like your trailer record has count which needs to be updated with the new count after splitting the files? Is that correct?
I got the required output. Basically thanks ful to your logic and the command BUILD=(101,100,/,1,100)) -- This command make me very helpful. i read the Dfsort getting started book and Dfsort tricks, but not sure i have missed such a good command. thanks you alot.
Hi Sql,
The length is 100 & RB. Yes the number changes, basically it is a batch header number, increments whenever the batch runs. Not much expertise level in DFsort. Reading sort books and going thru this forum i am trying to solve problems myself. Thank you.