SYNCSORT - questions

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
mainframeman
Member
Posts: 4
Joined: Sat Dec 09, 2006 7:22 am

SYNCSORT - questions

Post by mainframeman » Sat Dec 09, 2006 7:48 am

I have a few questions. I trying to decide if I need to write a cobol program or can use syncsort to accomplish this task. I am trying to generate a report which will include a header at the top of every page and the total number of records processed in the trailer at the end of the report. I am in an IBM Mainfram shop. I am using syncsort because I am not familiar with DFSORT. Is this even available? How can I determine which one to use. I know that syncsort is used here. Not sure about DFSORT

This is the code that I have so far:

This is from the sysin card:

SORT FIELDS=COPY
OUTREC FIELDS=(01:52,10, WTN
11:83,16, POF/POE
27:62,08, DATE
35:72,01,CHANGE=(07,C'3',C'ADD', ACTION
C'4',C'DELETE'),NOMATCH=(72,1))

How do I add header/trailer with sum fields to the trailer? Is this possible? I am very new to syncsort?

OUTPUT SO FAR:

2153487745000099080007613520040712ADD
2156282020000099080007613520060929ADD
2156571151000099080008243820060419ADD
2156571151000099080008243820060419ADD
2157507442000099080007613520050328ADD
2157507442000099080007613500000000DELETE

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Sat Dec 09, 2006 9:59 pm

I am using syncsort because I am not familiar with DFSORT. Is this even available? How can I determine which one to use. I know that syncsort is used here. Not sure about DFSORT
If your site uses Syncsort, then it's probable it doesn't also have DFSORT. Most sites have one or the other. It is possible that Syncsort is the primary sort product at your shop and DFSORT is also available, but in that case you'd have to JOBLIB/STEPLIB to DFSORT in the libraries where your System Programmers installed it, so you'd have to ask them.

I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.

If, in fact, you can use DFSORT, let me know and I'll be happy to help you with it.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others