P.S.: I tried to test it but with a small data it does not show really a difference. But here at my work place a debate is going on that 'it might'
...please suggest. My shop uses Syncsort, but I think this functionality should be same irrespective of SORT product so post is in DFSORT forum.
I don't know what you mean by "some technical explanation". I thought I gave a technical explanation that "we combine contiguous fields internally". What I mean is that the "key" is handled in the same way (as one contiguous 30-byte key) for both SORT statements. Of course, I can only speak for DFSORT whereas you said you're using Syncsort.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
A technical answer is in Frank's reply
we combine contiguous fields internally when possible as in this case.
Before the actual sorting is started, the code looks at the sort fields and when they are contiguous, it internally creates a single sort field (just like the shorter syntax that was posted), rather than working with 4 (from your example).