|
View previous topic :: View next topic
|
| Author |
Message |
jmreddymca
Warnings : 1
New User
Joined: 14 Oct 2007
Posts: 29
Location: Bangalore
|
|
|
|
Hi friends,
could you please tell me , what is the difference between syncsort & dfsort. |
|
| Back to top |
|
 |
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
| Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
jmreddymca
in the link provided by superk, Rupesh.Kothari states that IFTHEN is not available in SYNCSORT; which is a wrong information, may be he is holding an old version of SYNCSORT.
1. Basically, SYNCSORT and DFSORT are 2 competitive SORT products.
2. Some of the features present in one will/may not be available in the other.
3. Some of the features that are in DFSORT like PARSE, SQZ, JFY, NUM, SPLIT1R, etc are not available in SYNCSORT, however its available as the early release in SYNCSORT(check this Topic=>
http://ibmmainframes.com/viewtopic.php?t=24948
4. Some feature's of SYNCSORT like JOOINKEY feature is not available in DFSORT....
5. And so on....
Most important point is the documentation: DFSORT documentation will be easily available to everyone easily(here=> http://www.ibm.com/storage/dfsort/, but SYNCSORT documentation is available only on providing your license # in the SYNCSORT website http://www.syncsort.com/(or you can catch up with Alissa Margulies). |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| in the link provided by superk, Rupesh.Kothari states that IFTHEN is not available in SYNCSORT; which is a wrong information, may be he is holding an old version of SYNCSORT |
That information WAS correct when posted in Aug, 2005. IFTHEN was available with DFSORT in Dec, 2004. It was not available with Syncsort until much later.
| Quote: |
| Some of the features that are in DFSORT like PARSE, SQZ, JFY, NUM, SPLIT1R, etc are not available in SYNCSORT, however its available as the early release in SYNCSORT |
Note that all of those functions have been available with DFSORT since April, 2006. They are still NOT generally available with Syncsort. Early release is NOT the same as general availability.
| Quote: |
| 4. Some feature's of SYNCSORT like JOOINKEY feature is not available in DFSORT.... |
I think you mean JOINKEYS. Note that DFSORT had SPLICE years before Syncsort had JOINKEYS.
It's certainly true that DFSORT's documentation is available online whereas Syncsort's is not. It's also true that DFSORT's ICETOOL is fully documented and available online, whereas there is NO documentation available for Syncsort's SYNCTOOL. |
|
| Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
| Quote: |
| That information WAS correct when posted in Aug, 2005. |
Ohh frank i did not observe the date of post  |
|
| Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
Frank,
| Quote: |
| DFSORT is IBM's sort product and an optional feature of z/OS. DFSORT includes ICETOOL and ICEGENER. |
I dont have DFSORT installed in my site and even then am able to use ICETOOL. I am asking this as you have mentioned that DFSORT includes ICETOOL. Please throw some light on this. |
|
| Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
Aaru
| Quote: |
| I dont have DFSORT installed in my site and even then am able to use ICETOOL |
When you provide
and submit the JOB, internally SYNCSORT would call SYNCTOOL in the place of ICETOOL.
Also do you know when you provide
| Code: |
| PGM=ICEMAN or PGM=SORT |
internally whatever SORT product your site is using that SORT product would be invoked. |
|
| Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
Prem,
| Quote: |
| internally SYNCSORT would call SYNCTOOL in the place of ICETOOL. |
Thanks for the information. I ran a job with ICETOOL and found the same
| Code: |
SYNCTOOL RELEASE 1.5.3 - COPYRIGHT 2004 SYNCSORT INC.
|
| Quote: |
| whatever SORT product your site is using that SORT product would be invoked. |
I am aware of this one. |
|
| Back to top |
|
|
jmreddymca
Warnings : 1
New User
Joined: 14 Oct 2007
Posts: 29
Location: Bangalore
|
|
|
|
| thanks for the information prem & Aaru |
|
| Back to top |
|
|
|
|
