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:

Code: Select all

999 
666
333 
111 
222 
Expected Output:

Code: Select all

999 
111 
222 
333 
666

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.