Use of SORTED in SORT FIELDS allowed?

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Post Reply
Vipin Verma
Registered Member
Posts: 14
Joined: Tue Aug 20, 2013 10:45 am

Use of SORTED in SORT FIELDS allowed?

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

Re: Use of SORTED in SORT FIELDS allowed?

Post by 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.
Regards
Nic
Vipin Verma
Registered Member
Posts: 14
Joined: Tue Aug 20, 2013 10:45 am

Re: Use of SORTED in SORT FIELDS allowed?

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

Re: Use of SORTED in SORT FIELDS allowed?

Post by 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?
Regards
Nic
Vipin Verma
Registered Member
Posts: 14
Joined: Tue Aug 20, 2013 10:45 am

Re: Use of SORTED in SORT FIELDS allowed?

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

Re: Use of SORTED in SORT FIELDS allowed?

Post by nicc »

Have you actually referred to the manual? SORTED is not an option of COPY or SORT but of JOINKEYS.
Regards
Nic
Vipin Verma
Registered Member
Posts: 14
Joined: Tue Aug 20, 2013 10:45 am

Re: Use of SORTED in SORT FIELDS allowed?

Post by Vipin Verma »

:shock: need to recheck..
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

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