Actually the 2nd row needs to be spliced into a new file .
How can i do the same using ICETOOL.
The input file is of FBA record format and record length is 133 .
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Since your input file has RECFM=FBA, I'll assume the data you show actually starts in position 2 after the ANSI carriage control character. I'll also assume that we can identify the first record of each pair by the fact that it starts with nonblanks and the second record of each pair by the fact that it starts with blanks. Given that, here's a DFSORT/ICETOOL job that will do what you asked for. You'll need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) in order to use INREC with SPLICE. If you have DFSORT, but you don't have the April, 2006 PTF, ask your System Programmer to install it (it's free). For complete details on all of the new DFSORT and ICETOOL functions available with the April, 2006 PTF, see:
Joined: 23 Dec 2005 Posts: 61 Location: Providence , US
Hi Frank,
Thanks yet again for helping me out to solve one of the queries. Actually , I wanted my data in the first line to remain the same and the o/p file should have data of the first and second line both without any data deletion . (This I should have mentioned in my requirements , as my example was having spaces at the right side which created confusion. My appologies... )
I modified the job to do the same.
The first line was starting from 3rd byte .
The second line was starting from 15th byte.