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

Editing of count field in SYNCSORT like DFSORT


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
poolarajesh

New User


Joined: 22 Jan 2004
Posts: 4

PostPosted: Wed Apr 06, 2005 2:36 pm
Reply with quote

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
View user's profile Send private message
bigreddastud

New User


Joined: 19 Jan 2006
Posts: 6

PostPosted: Thu Jan 19, 2006 4:35 am
Reply with quote

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 icon_razz.gif
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Thu Jan 19, 2006 5:03 am
Reply with quote

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
View user's profile Send private message
bigreddastud

New User


Joined: 19 Jan 2006
Posts: 6

PostPosted: Thu Jan 19, 2006 8:02 pm
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Thu Jan 19, 2006 8:26 pm
Reply with quote

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
View user's profile Send private message
bigreddastud

New User


Joined: 19 Jan 2006
Posts: 6

PostPosted: Fri Jan 20, 2006 12:05 am
Reply with quote

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
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Fri Jan 20, 2006 12:28 am
Reply with quote

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
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts To get the count of rows for every 1 ... DB2 3
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts To find whether record count are true... DFSORT/ICETOOL 6
Search our Forums:

Back to Top