IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Can any one give me any sample join synctool?


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Sanath sekhar Reddy N

New User


Joined: 31 Oct 2012
Posts: 30
Location: INDIA

PostPosted: Thu Aug 08, 2013 12:03 pm
Reply with quote

Hi

Can any one give me any sample join synctool jcl?


Regards
Sanath
Back to top
View user's profile Send private message
mistah kurtz

Active User


Joined: 28 Jan 2012
Posts: 316
Location: Room: TREE(3). Hilbert's Hotel

PostPosted: Thu Aug 08, 2013 12:10 pm
Reply with quote

try this link icon_smile.gif
Back to top
View user's profile Send private message
Sanath sekhar Reddy N

New User


Joined: 31 Oct 2012
Posts: 30
Location: INDIA

PostPosted: Thu Aug 08, 2013 3:50 pm
Reply with quote

This link has many syncsort examples.so iam finding difficult to search synctool jcl using join.
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Thu Aug 08, 2013 3:55 pm
Reply with quote

Why not refer to manual
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Thu Aug 08, 2013 4:13 pm
Reply with quote

Sanath sekhar Reddy N wrote:
This link has many syncsort examples.so iam finding difficult to search synctool jcl using join.
The very first link got from the URL provided above has a working Synctool JOIN.

ibmmainframes.com/about47092.html

Unfortunately, there is NO Synctool manual.
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy

PostPosted: Thu Aug 08, 2013 4:16 pm
Reply with quote

Synctool is nothing but ICETOOL in SYNCSORT correct?
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Thu Aug 08, 2013 4:37 pm
Reply with quote

Hi,

DFSORT is an IBM product and DFSORT/DFSORT's ICETOOL is well documented. But Syncsort's equivalent product SYNCTOOL does not have a formal documentation.

The syntax/keywords found in the ICETOOL section of the DFSORT programming guide is intended for use by those who have DFSORT installed at their site. The same control statements cannot be expected to work well with Syncsort's SYNCTOOL.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Aug 08, 2013 8:32 pm
Reply with quote

Hello,

Currently, the best documentation available for Synctool is the ICETOOL documentation.

However there are documented features in ICETOOL that are NOT available in Synctool.

Quote:
Synctool is nothing but ICETOOL in SYNCSORT correct?
No, this is not correct.
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Fri Aug 09, 2013 4:21 am
Reply with quote

Pandora-Box wrote:
Synctool is nothing but ICETOOL in SYNCSORT correct?


Pandora-Box,

You of all the people shouldn't be issuing such blatant statements. DFSORT's ICETOOL is a fully documented, fully supported feature of DFSORT. It has been a part of DFSORT since DFSORT Release 11.1 which became available in February, 1991. So DFSORT's ICETOOL has been available and official for over 22 years now! Syncsort's SYNCTOOL only has a subset of the functions available with DFSORT's ICETOOL and is an unsupported/undocumented utility from syncsort.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Fri Aug 09, 2013 5:44 am
Reply with quote

For all the nonsense going on, no-one has question the TS about their requirement for a "join synctool" example.

JOINKEYS is part of SORT. Yes, it can appear in a "CNTL" file for a SyncTool operator, but we have no evidence that that is what is actually wanted.

Just as whatever "load" SyncSort provides is "aliased" to SORT (highly likely), so whatever "load" is supplied for SyncTool is often "aliased" to ICETOOL.

Causes a lot of confusion amongst people who don't know which product they are using, but makes "migration" easier.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Join multiple records using splice DFSORT/ICETOOL 5
No new posts Join 2 files according to one key field. JCL & VSAM 3
No new posts Synctool-dynamic split job for varyin... JCL & VSAM 7
No new posts JOIN STATEMENT PERFORMANCE. DFSORT/ICETOOL 12
No new posts Help needed to assemble IMS sample co... ABENDS & Debugging 4
Search our Forums:

Back to Top