|
View previous topic :: View next topic
|
| Author |
Message |
Ramanan-R
New User
Joined: 21 Mar 2007
Posts: 66
Location: Chennai, Tamilnadu, India
|
|
|
|
Hi All  ,
I am using the following JCL, but the output does not come in specified sort order as given in the below Syctool control card. Please advice...
| Code: |
//JSTEP010 EXEC PGM=SYNCTOOL
//**
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//**
//IN DD DSN=Input dataset...
// DISP=SHR
//*
//OUT DD SYSOUT=*
//**
//TOOLIN DD *
COPY FROM(IN) TO(OUT) USING(CTL1)
/*
//CTL1CNTL DD *
*
INCLUDE COND=(424,001,CH,EQ,C'X',AND,
394,001,CH,EQ,C'Y')
*
INREC FIELDS=(395,004,
342,026,
424,010,
984,010)
*
SORT FIELDS=(001,004,BI,A,
041,010,CH,D,
005,026,CH,D)
*
OUTREC FIELDS=(001:001,004,BI,EDIT=(TTTTTTTTT),
010:X,
011:031,010,
021:X,
022:041,010,
032:X,
033:005,026)
/*
|
Thanks in advance!
Ramanan R |
|
| Back to top |
|
 |
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
Hi,
I believe you.
Gerry |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
The job will have done what you told it to do. . .
You need to post a bit of sample input, the output you want from the sample input, the "wrong"actual output and the informational data presented by the run. |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2482
Location: @my desk
|
|
|
|
Its doing what it has been asked to do - COPY. Change the COPY to SORT.
| Code: |
| COPY FROM(IN) TO(OUT) USING(CTL1) |
Change the above to
| Code: |
| SORT FROM(IN) TO(OUT) USING(CTL1) |
|
|
| Back to top |
|
|
Ramanan-R
New User
Joined: 21 Mar 2007
Posts: 66
Location: Chennai, Tamilnadu, India
|
|
|
|
Thanks Arun...
Its working perfect... I assume DFSORT/ICETOOL would sort even if it is COPY
Thanks again..
Ramanan R |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
| Ramanan-R wrote: |
| Its working perfect... I assume DFSORT/ICETOOL would sort even if it is COPY |
No, you need to tell the sort what to do. "SORT ..." and "COPY..." are different functions. |
|
| Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
Hi,
from my tests, DFSORT will sort even if you have COPY.
Gerry |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
Hi Gerry,
if you look at the Chapter 2, sub-topic: Copying Data Sets of DFSORT: Getting Started, it says(emphasis added by me),
| Quote: |
Copying Data Sets
With DFSORT you can copy data sets directly without performing a sort or merge. |
...did you mean something else?
PS. I'm not a DFSort spoke-person, if I've interpreted the manual wrongly, please do correct me. |
|
| Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
Hi Anuj,
ran the same JCL with DFSORT and SYNCSORT using
| Code: |
| COPY FROM(IN) TO(OUT) USING(CTL1) |
and DFSORT sorts the records.
Gerry |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
Hi Gerry,
I've sent a note to Frank to have a look on this thread - I'm not the correct person, I believe, to comment on this any further (as my shop uses SyncSort these days). |
|
| Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
| Yes, SyncSort and DFSort behave differently in this situation. However, if so desired, SyncSort can be modified to perform the SORT in CTLnCNTL when COPY has been specified in TOOLIN. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| DFSORT's ICETOOL will, in fact, do a SORT in this case. We found that for some reason, people often use a COPY operator instead of a SORT operator when they want to do a SORT, so if we see a SORT statement in that case, we do a SORT. Makes sense to us. |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2482
Location: @my desk
|
|
|
|
| Quote: |
| Its working perfect |
Good to hear it's working. Thanks for letting us know. |
|
| Back to top |
|
|
Ramanan-R
New User
Joined: 21 Mar 2007
Posts: 66
Location: Chennai, Tamilnadu, India
|
|
|
|
Thank you all for your information...
Regards,
Ramanan R |
|
| Back to top |
|
|
|
|
