You can format the records to be sorted in a particular way, prior to the sorting. This is also possible. For re-formatting of records, there are mainly 3 tools at your disposal - BUILD - Reformat each record by specifying all of its items one by one. Here, you can add,delete or re-arrange fields. Suppose you are given the following Input Dataset. In the output report, you are asked to display only the name of the Insurance Agent and the Sales Figure.
|Published (Last):||16 July 2015|
|PDF File Size:||12.20 Mb|
|ePub File Size:||1.54 Mb|
|Price:||Free* [*Free Regsitration Required]|
Advanced search. Each record is of 80 byte length of a flat file. I have to merge the records so that - The first 2 records of the input file should appear in the first row of output file. Record 3 and 4 of the input file should appear in the 2nd row of output file. Record 5 and 6 of the input file should appear in the 3rd row of output file. Also if possible, please let me know what changes needs to be done if input file is changed to VBA. Thank you. Please do not get confused between input and output file.
The problem I have is that people can explain things quickly but I can only comprehend slowly. Regards Nic. I will appreciate if I can get the answer in the Forum. A search resulted in 45 hits - many were multiple hits on the same topic so not so much to look through. Did you also read the manual? Did you try to code anything? If not, why not? But perhaps I'm at completely wrong place.
It is rude - and generally will not help you get a faster answer and may slow down the response as people are put off by the rudeness. Now that Enrico has given you the evr-so-simple answer are you now getting your desired result? Select all.
Thanx a lot Wolfgang. Do you know your hidden name meaning? Click here to find your hidden name meaning. TEXT is used to decide the text to be written before the count. Only the header and trailer kept in place and rest of the data is sorted.
JCL - Utility Programs
Advanced search. Each record is of 80 byte length of a flat file. I have to merge the records so that - The first 2 records of the input file should appear in the first row of output file. Record 3 and 4 of the input file should appear in the 2nd row of output file. Record 5 and 6 of the input file should appear in the 3rd row of output file.