Use of SORTED in SORT FIELDS allowed?

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.

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

Use of SORTED in SORT FIELDS allowed?

Postby 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: 542
Joined: Wed Apr 23, 2014 8:45 pm
Been thanked: 11 times

Re: Use of SORTED in SORT FIELDS allowed?

Postby 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?

Postby 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: 542
Joined: Wed Apr 23, 2014 8:45 pm
Been thanked: 11 times

Re: Use of SORTED in SORT FIELDS allowed?

Postby 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


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

Who is online

Users browsing this forum: CommonCrawl [Bot] and 0 guests