Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Can any one give me any sample join synctool?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
Sanath sekhar Reddy N

New User


Joined: 31 Oct 2012
Posts: 31
Location: INDIA

PostPosted: Thu Aug 08, 2013 12:03 pm    Post subject: Can any one give me any sample join synctool?
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: 287
Location: Room: TREE(3). Hilbert's Hotel

PostPosted: Thu Aug 08, 2013 12:10 pm    Post subject:
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: 31
Location: INDIA

PostPosted: Thu Aug 08, 2013 3:50 pm    Post subject: Hi
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

Moderator


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

PostPosted: Thu Aug 08, 2013 3:55 pm    Post subject:
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: 2285
Location: @my desk

PostPosted: Thu Aug 08, 2013 4:13 pm    Post subject: Re: Hi
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.

http://ibmmainframes.com/about47092.html

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

Moderator


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

PostPosted: Thu Aug 08, 2013 4:16 pm    Post subject:
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: 2285
Location: @my desk

PostPosted: Thu Aug 08, 2013 4:37 pm    Post subject:
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

Site Director


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

PostPosted: Thu Aug 08, 2013 8:32 pm    Post subject:
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    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Fri Aug 09, 2013 5:44 am    Post subject: Reply to: Can any one give me any sample join synctool?
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    IBMMAINFRAMES.com Support Forums -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 21 Sun Aug 27, 2017 10:35 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts scheduling between OPC and TWS give u... nsbl IBM Tools 4 Sun Mar 12, 2017 5:35 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us