Could anyone please help me out on sorting records with in a group as per the example shown below:
The below file contains diff types of records with more than one batch: A-Batch, Z-Trailer, and group of H,D,I is one record.I type record is not mandatory in each group.
I'm trying to sort records based on the code present in H type record.The position of the code is 18 with 3 bytes length.Could you please help me out to get the output as shown below: The group containing code ABC in type H record is shown on TOP in batch1 and group containing code MDR in type H record is shown on TOP in batch2.
While I'm looking at output dataset, there is ZERO '0' written in the last byte of the output file.Any idea please why the last byte is written with '0'.
Other than this everything looks good as expected.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
I don't see 0 in the last byte when I run the job using your input example as shown. Something must be different on your end. If your input had '0' in the last byte, so would the output.