Include and not-include records in output.

[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

[zprogrammer]

Hi Kavaljeet,

Unfortunately in your example no record is skipped.

[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.

[KavalJeet]

Hi Kavaljeet,

Unfortunately in your example no record is skipped.

I meant, skipping the first record from sort operation.

[William Collins]

And did you look at DATASORT?

[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.