View previous topic :: View next topic
|
Author |
Message |
poolarajesh
New User
Joined: 22 Jan 2004 Posts: 4
|
|
|
|
I am using a SYNCSORT step to write the record count into the output file. But I am not able to edit the count field like DFSORT. I don?t have the exact idea whether SYNCSORT will allow editing of count field or not. I have tried the syntax of DFSORT itself (count=(edit=(TTTTTT))). But it is giving me syntax error. Can anyone help me? |
|
Back to top |
|
|
bigreddastud
New User
Joined: 19 Jan 2006 Posts: 6
|
|
|
|
I'd guess you solved this long ago, but here's the solution for SYNCSORT I had to use. I didn't code it, I merely stumbled onto it:
Code: |
//******************************************
//****COUNT RECORDS IN FILE USING SYNCSORT
//******************************************
//STEPH EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DS=MY.INFILE.TOCOUNT,
// DISP=SHR
//SORTOUT DD DSN=THE.INFILE.RECORD.COUNT,
// DISP=(NEW,CATLG,CATLG),
// DCB=(RECFM=FB,LRECL=008),
// UNIT=SYSDA,
// SPACE=(TRK,(1,1))
//SYSIN DD DATA
SORT FIELDS=COPY
OUTFIL NODETAIL,REMOVECC,TRAILER1=(COUNT)
/*
|
BTW I su** with JCL/Mainframe so don't bother asking me any further questions |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
bigred,
The job you posted does NOT do what was asked for. COUNT by itself does NOT give an edited count as COUNT=(EDIT=(TTTTTT)) does.
Quote: |
BTW I su** with JCL/Mainframe so don't bother asking me any further questions |
I guess that explains why you've posted two "solutions" that don't satisfy the actual requirements. You seem to think this count job, which has been posted on this board numerous times by me and others, is something new. It isn't, so please stop posting it as a solution for everything. |
|
Back to top |
|
|
bigreddastud
New User
Joined: 19 Jan 2006 Posts: 6
|
|
|
|
Well sorry Frank, but I was unable to find a SYNCSORT solution to store the count of a datafile in another dataset.
You are correct, you've shown code many times how to do this in DFSORT, but please, this was my attempt to suggest the solution using SYNCSORT since none of your solutions I tried worked with SYNCSORT. I'm not trying to take any credit for this solution, or undermine you apparent supreme knowledge of DFSORT in any way, I am just trying to post something that solved my similar (but as you pointed out not exact) problem after several hours of searching. I'm just trying to help the community that was useful to me and probably others.
Yes, I am a mainframe Noob, and I was under the impression that this forum was for people to help one another, not get all in a tizzy. Lots of threads supply answers that don't relate 100% to the original post, but sometimes that leads to a better solution.[/u] |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Yes, this forum is for people to help each other, but by providing relevant responses. You presented this as a solution to two problems that it wasn't a solution to. Other mainframe Noobs (whatever that is) unknowingly might have wasted their time trying to use this solution where it didn't apply.
If you had posted that solution in a thread where somebody had asked how to print the count of the records, I wouldn't have said anything. If you'd started a new Topic for the solution and explained why, I wouldn't have objected to that either. It was just the way you presented it that I objected to. Peace. |
|
Back to top |
|
|
bigreddastud
New User
Joined: 19 Jan 2006 Posts: 6
|
|
|
|
Frank Yaeger wrote: |
It was just the way you presented it that I objected to. Peace. |
Agreed.
I should have read the posts better. I was just discouraged/annoyed on the seemingly tiny amount of info I've been able to find on the net for syncsort specific things. Everything's DFSORT oriented for the most part. I was just trying to (albeit ineffectively) to help anyone possibly in a similar situation as myself. I shouldn't have flamed on you based on my actions/reactions. Peace back at you.
BTW, you do seem to be quite the DFSORT genius, so keep up the good knowledge sharing. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
I was just discouraged/annoyed on the seemingly tiny amount of info I've been able to find on the net for syncsort specific things. Everything's DFSORT oriented for the most part |
This is not by accident. It's the result of actions taken by the two companies (IBM for DFSORT and Syncsort, Inc for Syncsort).
The DFSORT books are freely available on the web from:
www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
The DFSORT website provides lots of technical information, examples, papers, tricks, Q&A, etc:
www.ibm.com/storage/dfsort/
Syncsort's books are not available on the web. Syncsort's website is marketing oriented.
I am a Moderator on several help boards where I provide DFSORT/ICETOOL solutions. Syncsort does not participate on these help boards.
If you or anyone else on this board would like some documents prepared by the DFSORT Team that describe what we see as the advantages of DFSORT over Syncsort, as well as considersations for migrating from Syncsort to DFSORT, send me an e-mail offline (yaeger@us.ibm.com). Please put "DFSORT" somewere in your Subject line to catch my attention.
Quote: |
BTW, you do seem to be quite the DFSORT genius, so keep up the good knowledge sharing. |
Thanks for the compliment. I'm an actual DFSORT developer and the "inventor" of DFSORT's ICETOOL. So I know a lot about this stuff having developed a lot of it, and I'm happy to share that knowledge with DFSORT customers. |
|
Back to top |
|
|
|