Use of SORTED in SORT FIELDS allowed?

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Previous topicNext topic

Topic Author
Vipin Verma
New Member
Posts: 8
Joined: Tue Aug 20, 2013 10:45 am

Use of SORTED in SORT FIELDS allowed?

Post by Vipin Verma » Fri Apr 21, 2017 11:58 pm

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
Global Moderator
Global Moderator
Posts: 580
Joined: Wed Apr 23, 2014 8:45 pm

Re: Use of SORTED in SORT FIELDS allowed?

Post by nicc » Sat Apr 22, 2017 2:20 am

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.


Regards
Nic


Topic Author
Vipin Verma
New Member
Posts: 8
Joined: Tue Aug 20, 2013 10:45 am

Re: Use of SORTED in SORT FIELDS allowed?

Post by Vipin Verma » Sun May 21, 2017 7:55 pm

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
Global Moderator
Global Moderator
Posts: 580
Joined: Wed Apr 23, 2014 8:45 pm

Re: Use of SORTED in SORT FIELDS allowed?

Post by nicc » Mon May 22, 2017 3:22 pm

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?


Regards
Nic

Previous topicNext topic

Return to “IBM DFSort, ICETOOL, ICEMAN, ICEGENER.”