Could you please help merge 2 files horizontally based on the key.
Following is the example
File1 : Key is first 18 numbers(No duplicates and LRECL is 55 and FB) and file is sorted
File2 : Key is first 18 numbers(Duplicates present and LRECL is 150 and FB) and file is sorted
If records present on both files, merge horizontally as FILE2||FILE1
If records present in file2 only,write the entire contents of file2 only.
If records present in file1 only,nothing to be written to output
Thank you so much.It has worked.
Could you please let me know, how to find a character in position 25 and replace it with a number. The record length in 223 and is FB.
Replace { with 0 at position 25.
Replace A with 1 at position 25.
Replace B with 2 at position 25.
Replace C with 3 at position 25.
Replace D with 4 at position 25.
Replace E with 5 at position 25.
Replace F with 6 at position 25.
Replace G with 7 at position 25.
Replace H with 8 at position 25.
Replace I with 9 at position 25.
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
madishpa wrote:
Hi Kolusu,
Thank you so much.It has worked.
Could you please let me know, how to find a character in position 25 and replace it with a number. The record length in 223 and is FB.
It sounds like you have sign overpunch Zoned decimal data and you want to see the readable format of them. Is that true? What would you do if the the 25th byte had }JKLMNOPQR which denotes negative numbers?
This is the representation of the ZD numbers . The number on top represents the sign over punch and the lower number represents the readable decimal number