Use of SORTED in SORT FIELDS allowed?

[Vipin Verma]

Hi,

Is the use of SORTED in SORT FIELDS allowed, like this:

Code: Select all

SORT FIELDS=(...),SORTED

I see that this is usually used in JOINKEYS and could not find out an example using it with out JOINKEYS.

[nicc]

SORTED in JOINKEYS tells DFsort not to sort the data because it is already sorted. Why would you want to use SORTED when you are sorting? If you want the syntax of something look it up in the manual.

[Vipin Verma]

I just wanted to copy the records as is while removing the duplicates on key so I asked about the use of SORT. I should have asked about COPY FIELDS but COPY FIELDS will have just same effect as SORT as far I know??

[nicc]

as far I know??

So you have not even experimented to try and determine the difference, if any? Or read the manual? Do not know the difference between the meaning of COPY and SORT?

[Vipin Verma]

COPY does not really sort but SORT does sort operation. But for simple copy operation SORT and COPY are same. SORTED means the files are already sorted.

This is what I understood.

[nicc]

Have you actually referred to the manual? SORTED is not an option of COPY or SORT but of JOINKEYS.

[Vipin Verma]

need to recheck..