Page 1 of 1
Include and not-include records in output.
Posted: Sun Oct 13, 2013 8:39 pm
by KavalJeet
Hi,
Can we use the SKIPREC=n but not omit the record from the output file. Perhaps I'm not able to put things better in words so I'll show an example:
Input:
Expected Output:
Re: Include and not-include records in output.
Posted: Fri Nov 22, 2013 11:01 am
by zprogrammer
Hi Kavaljeet,
Unfortunately in your example no record is skipped.
Re: Include and not-include records in output.
Posted: Fri Nov 22, 2013 10:28 pm
by William Collins
You mean you want to SORT but leave the first record where it is? First on input is first on output?
Look at ICETOOL's DATASORT operator.
Re: Include and not-include records in output.
Posted: Sun Mar 16, 2014 10:02 am
by KavalJeet
Pandora-Box wrote:Hi Kavaljeet,
Unfortunately in your example no record is skipped.
I meant, skipping the first record from sort operation.
Re: Include and not-include records in output.
Posted: Sun Mar 16, 2014 10:51 pm
by William Collins
And did you look at DATASORT?
Re: Include and not-include records in output.
Posted: Wed Apr 02, 2014 5:20 pm
by KavalJeet
Hi Bill,
Unfortunately I did not get a good reference for DATASORT:
https://www.google.co.in/search?q=datas ... rt&start=0
ftp is blocked in office so could not open the second link in above. I'll search again.
Thanks for your time.