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
 
Editing of count field in SYNCSORT like DFSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Editing of count field in SYNCSORT like DFSORT
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    Post subject:
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 Moderator


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

PostPosted: Thu Jan 19, 2006 5:03 am    Post subject:
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    Post subject:
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 Moderator


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

PostPosted: Thu Jan 19, 2006 8:26 pm    Post subject:
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    Post subject:
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 Moderator


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

PostPosted: Fri Jan 20, 2006 12:28 am    Post subject:
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:

http://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:

http://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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts column with count of rows within dist... ronald wouterson DB2 4 Sun Sep 17, 2017 9:48 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Remove leading spaces from numeric field rexx77 SYNCSORT 6 Wed Sep 06, 2017 2:15 am
No new posts JES2 job size field matching Windows ... SRICOBSAS All Other Mainframe Topics 4 Tue Sep 05, 2017 5:49 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm

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